How can I do a Bulk upload of attachments into servicenow table?

Pratiksha2
Mega Sage

I am having bulk of attachments stored in my laptop folder.

Now my requirement is to upload all the attachments into the ServiceNow custom table at one time.

 

Can anyone please help me to achieve this?

 

Thank You in Advance!

Pratiksha

3 REPLIES 3

Ratnakar7
Mega Sage
Mega Sage

Hi @Pratiksha2 ,

 

Yes, you can upload attachments in bulk into a ServiceNow table using the Data Import functionality. Here are the steps:

  1. Create a new data source by navigating to System Import Sets > Data Sources and clicking on New.

  2. Fill in the necessary details such as Name, Table Name, and File Extension.

  3. Add a new File field to the data source .

  4. Map the fields in the data source to the fields in the target table. Make sure to map the File field to the Attachment field in the target table.

  5. Save the data source and go back to the list view.

  6. Click on the Load Data button and select the files that you want to upload.

  7. Click on Transform Map to map the fields in the data source to the fields in the target table.

  8. Create a new Transform Map or use an existing one to map the fields.

  9. Click on Submit to start the import.

Once the import is complete, you should see the attachments in the target table. Note that the maximum file size for attachments is 100MB in ServiceNow, so make sure that your files do not exceed this limit.

 

You can also refer below article-links:
Bulk Loading Attachments to ServiceNow With PowerShell 

Loading data from an email attachment 

 

If my response was helpful in resolving the issue, please consider accepting it as a solution by clicking on the Accept solution button and giving it a thumbs up 👍. This will benefit others who may have a similar question in the future.

 

Thank you!

Ratnakar

how will the attachment from excel get added to the source table?

Teju Dhoran
Kilo Sage
Kilo Sage

Hi,

Yes, you can upload attachments in bulk into a ServiceNow table using the Data Import functionality. Here are the steps: Create a new data source by navigating to System Import Sets > Data Sources and clicking on New. Fill in the necessary details such as Name, Table Name, and File Extension.

https://www.servicenow.com/community/developer-forum/how-can-i-do-a-bulk-upload-of-attachments-into-....