Dataverse - Update, Select and Insert

[anmaheswa]

Hi All,

Has anyone tried the Microsoft Dataverse vbo? DX Asset
Please can any one give me a resolution or an idea how to use this  to extract, update and insert values to the Dataverse 

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

[ewilson]

@anmaheswa,

Now that you have the Authorization header are you able to execute requests against Dataverse?

Cheers,
​

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

[anmaheswa]

I am stuck with this error now, the first screenshot is while trying to retrieve multiple records and the second one while trying to create a record.
Seems to be like an user authorization issue, I guess the AD user needs to be provided the necessary permissions on the dataverse side?




------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

[ewilson]

@anmaheswa,

I'm not deeply versed in Dataverse or Dynamics 365, but yes according to the error message it appears the client credentials don't have the appropriate permissions.

Cheers,

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

[anmaheswa]

That's correct, some security roles were missing. That's all sorted now and we have been able to work with data verse. Appreciate your quick response and constant help on this. Thanks a lot

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

[anmaheswa]

Hi Eric,

Could you share an example of a Retrieve a particular record  action. I tried a number of ways but have not been successful. I wanted to understand the value which needs to be passed in filter? Many thanks in advance

Thanks, Ankita

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

[ewilson]

Hi @anmaheswa

I don't have one myself, but I'm checking with the developer of the connector. Stay tuned.

Cheers,

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

[shashank.kumar280]

Hi @anmaheswa,

If you were trying to retrieve two columns(name & accountnumber) from a table called accounts with accountid as the key then set these inputs-

[tablename] = "accounts"

[key] = "accountid"

[filter] = "$select=name,accountnumber"

Note that filter is optional

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

[anmaheswa]

Sorry I was away for sometime, thank you so much for your help

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

[anmaheswa]

Thanks Shashank, sorry I was away for sometime but I shall give it a go now.

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

[maneesh.vemula1]

Hi Ankita - How were you able to retrieve multiple records? I am seeing this below error:

Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 404
HTTP Response Content: {"error":{"code":"0x80060888","message":"Resource not found for the segment 'xxxx'."}}

I am able to get the access token. I just provided the table name. Do i need to give the prefix or use the plural version of the table name? 

Let me know! Thanks