blob data type to base64

[Mahesh120]

Hi All,

Am working on a migration project, where we need to migrate attachments from Tool A to Service Now.

Tool A hosted on Windows with SQL Database.Table which stores the attachment contentent has data type as 'blob'.

We are exporting the data in a csv format and planning to convert them into base64 format so that Service Now can understand properly.

Any help on this would be much appreciated.

Regards,

Mahesh.

[siriprudhivi]

Hi Mahesh,

While importing data into Service Now, you can use field tranform maps to convert the blob to base64 encoded string and save into sn attachments table. Here's link to how import sets work - Import Sets - ServiceNow Wiki.

Regards,

Siri

[Mahesh120]

Hi Siri,

Tried the same way but unable to get the data in right format.

Actually in my source database (MS SQL) the data type is 'image' (BLOB), even tried to convert it to base64 from the DB level itself and tried to attach it to records via background scripts. That also didn't worked.

Regards,

Mahesh.

[pankaj_puniani]

Hi,

There is a Soap Attachment creator integration which allows you to create attachments on Service Now records.

AttachmentCreator SOAP Web Service - ServiceNow Wiki

Thanks

Pankaj