cancel
Showing results for 
Search instead for 
Did you mean: 

Sharepoint Skill - Get Attachment

GeetanjaliVajra
Level 3
Hi All,

I am trying to use the Get Attachment action from the Sharepoint API service but it is not returning any data. The attachments would be image files (.tiff). I am not sure how to form the OData query. Could someone help in this regard if you have already used this action?


------------------------------
Geetanjali Vajrapu
Senior Developer
Tyson Foods
India
------------------------------
8 REPLIES 8

ewilson
Staff
Staff
Hello @Geetanjali Vajrapu,

Can you be a little more specific about which connector/VBO you're using? I don't recall their being a Get Attachment action on the Microsoft Graph - SharePoint connector or the Microsoft Graph - Download Files VBO. Although I would imagine you could use the Microsoft Graph - Download Files VBO if you know the file ID of the attachment.

Cheers,


------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

Hi Eric,

I am using the Sharepoint Skill - Sharepoint List Utility, which has an action - Get Attachment. 24724.png

------------------------------
Geetanjali Vajrapu
Senior Developer
Tyson Foods
Europe/London
------------------------------

Ah, I see. That connector was actually deprecated and ultimately removed from the DX early last year I believe. There may still be folks on here that are using those connectors, but my suggestion would be to look at the Microsoft Graph - Download Files VBO and the Download from SharePoint action.

In the meantime, can you share the full OData query you're trying to use now?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

@Geetanjali Vajrapu,

Try setting the OData Query input parameter to $expand=Attachments

Cheers,


------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

Hi Eric,

Below is the OData query that is being used:
"getbytitle('TestRPAUnloading')/Items?$expand=Attachments"

------------------------------
Geetanjali Vajrapu
Senior Developer
Tyson Foods
Europe/London
------------------------------

Hi Eric,

I tried using the below queries:

"$expand=Attachments" - This gives me the below error
24744.png

But when I use the below OData query, I do not get any error, but neither getting any output data as well.
"$expand=AttachmentFiles"

Below is the list of fields that I am getting from the Sharepoint List.
24745.png
24746.png

Any help would be really appreciated!

Thank you!

------------------------------
Geetanjali Vajrapu
Senior Developer
Tyson Foods
Europe/London
------------------------------

@Geetanjali Vajrapu,

In your first screenshot of results from SharePoint lists it looks like there's a column there titled File (Collection) and each row has a value of Row 1 of 1. If you click that, what content do you see in the embedded collection?

Cheers,


------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

Hi Eric,

There is a URI in the embedded collection.
24763.png

------------------------------
Geetanjali Vajrapu
Senior Developer
Tyson Foods
Europe/London
------------------------------