Need to upload 168 different attachments - 1 each to 168 different records

[Arka Banerjee1]

Hi Team,

I need to upload 168 attachments, 1 each across 168 different records. Can you please help with how I can upload all of these in bulk.

Please note that there's no attachment field in the records, so all would go to sys attachment table itself. 

Could you please help with how I can upload them.

@Ankur Bawiskar 

[Arka Banerjee1]

Hi Atul,

From this script, how can I ensure that the specific record is being attached with the specific attachment? I dont see any record to attachement mapping in this script..

[Dr Atul G- LNG]

Hi @Arka Banerjee1 

I'm not a developer, but when we talk about Transform Maps, we typically use the standard import Excel format.

I saw that Ankur provided a script from Chatgpt—have a look/and change if needed and see if it works for your use case. What I showed was just a starting point to demonstrate that this can be achieved using a Transform Map.

[Ankur Bawiskar]

@Arka Banerjee1 

where are those 168 files stored?

in your local computer and from there you need to upload to 168 different records?

[Arka Banerjee1]

Its stored in sharepoint, I can download them to my local Client VDI This PC as well

[Ankur Bawiskar]

@Arka Banerjee1 

2 approaches

1) download all from sharepoint to your local machine and then use powershell script I gave below

OR

2) integrate with sharepoint via custom integration or spoke and then handle this

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏