topic RE: Dataverse - uploading attachment via Blue Prism. in Digital Exchange

Dataverse - uploading attachment via Blue Prism.

JonathanPringle — Wed, 24 May 2023 08:59:00 GMT

Hi

I am using the Dataverse connector to manipulate data in a Dataverse environment.

I'm trying to upload a document to a user defined table , with the column having a 'file' datatype. What is the syntax for the JSON. I know there is some sort of relationship between the table 'FileAttachment' (a system table) and the user defined table. Hoping someone has some idea. thanks

------------------------------
Jonathan Pringle
RPA Developer
Agilisys
Europe/London
------------------------------

RE: Dataverse - uploading attachment via Blue Prism.

shashank.kumar280 — Wed, 24 May 2023 10:58:00 GMT

Hi Jonathan,

Here is the Dataverse documentation about File data upload API. You will have to build a VBO to call this API in order to upload files.

Use file column data (Microsoft Dataverse) - Power Apps

The current version 1.1.0 of Dataverse connector on DX doesn't expose actions related to File API.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Dataverse - uploading attachment via Blue Prism.

JonathanPringle — Fri, 26 May 2023 14:23:00 GMT

Hi Shashank

Thank you for your reply and sorry for my delayed response. I will take a look at this potential solution.

thanks
Jonathan

------------------------------
Jonathan Pringle
RPA Developer
Agilisys
Europe/London
------------------------------

RE: Dataverse - uploading attachment via Blue Prism.

shashank.kumar280 — Mon, 12 Jun 2023 11:18:00 GMT

@Jonathan Pringle FYI - A new VBO has been included in the latest version of the Dataverse asset on DX that has actions to interact with File APIs of Dataverse

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------