Unable to Download and Upload Attachments in SharePoint List Using Integration Services

Help Integration Service
1

I’ve successfully connected to SharePoint using Integration Services, which allows me to retrieve information from a SharePoint list. However, I’m struggling with downloading and uploading attachments to a SharePoint list.

I’ve searched through the available activities but haven’t found any specific activity that supports downloading attachments from a SharePoint list item or uploading new attachments to it.

Could someone please guide me on how to achieve these tasks? Are there any alternative activities or methods I can use to work with attachments in SharePoint lists?

Any advice or examples would be greatly appreciated!

Thank you in advance for your help!

2

@ZARA_Clark_Vincent_M,

To Download a file use Get File Activity from the Sharepoint Activities Package.

Thanks,
Ashok :slight_smile:

3

@ZARA_Clark_Vincent_M

there is no direct activity to do that…you can check the below vb code

cheers

4

It seems like the Get List Attachment activity is no longer available in the modern Office365 package. When I tried using the Get List Items activity, it only returns a boolean value indicating whether there’s an attachment for that specific list item ID (true or false), but it doesn’t provide any further details like the URL or attachment name that I could use to proceed with the Download File activity.

Do you have any suggestions or workarounds for accessing the attachment URLs, or perhaps a different approach to downloading attachments from a SharePoint list? I would greatly appreciate any insights you could share!

5

I’d appreciate it if you could elaborate further on using the Invoke Code activity to get the file URL of the attachment. Specifically, I’m looking to replace the Get List Items activity with code that can retrieve the URL of an attachment, given that I already have the specific list item ID (which I obtain through a trigger from Integration Services).

Could you guide me on how to adjust the code within the Invoke Code activity to fetch the specific attachment URL? Additionally, will I need to handle authentication separately when using the Invoke Code activity, or does it inherit the authentication context from the SharePoint connection established through Integration Services?

Any examples or detailed steps would be really helpful!

6

@ZARA_Clark_Vincent_M

the authentication cannot be the office365 activity authentication

here is a code for attaching the file similarly you can use csom endpoints to get the files as well

cheers