topic RE: Sharepoint Skill - Get Attachment in Product Forum

Sharepoint Skill - Get Attachment

GeetanjaliVajra — Tue, 07 Jun 2022 12:31:00 GMT

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
------------------------------

RE: Sharepoint Skill - Get Attachment

ewilson — Tue, 07 Jun 2022 13:07:00 GMT

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
------------------------------

RE: Sharepoint Skill - Get Attachment

GeetanjaliVajra — Tue, 07 Jun 2022 13:20:00 GMT

Hi Eric,

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

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

RE: Sharepoint Skill - Get Attachment

ewilson — Tue, 07 Jun 2022 13:48:00 GMT

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
------------------------------

RE: Sharepoint Skill - Get Attachment

ewilson — Tue, 07 Jun 2022 13:58:00 GMT

@Geetanjali Vajrapu,

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

Cheers,

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

RE: Sharepoint Skill - Get Attachment

GeetanjaliVajra — Tue, 07 Jun 2022 14:09:00 GMT

Hi Eric,

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

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

RE: Sharepoint Skill - Get Attachment

GeetanjaliVajra — Tue, 07 Jun 2022 15:18:00 GMT

Hi Eric,

I tried using the below queries:

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

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.

Any help would be really appreciated!

Thank you!

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

RE: Sharepoint Skill - Get Attachment

ewilson — Tue, 07 Jun 2022 17:33:00 GMT

@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
------------------------------

RE: Sharepoint Skill - Get Attachment

GeetanjaliVajra — Wed, 08 Jun 2022 07:25:00 GMT

Hi Eric,

There is a URI in the embedded collection.

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