topic Re: RE: Microsoft Dataverse VBO in Product Forum

Microsoft Dataverse VBO

AbhijithRaj — Thu, 03 Mar 2022 07:11:00 GMT

Hi All,

Has anyone tried the Microsoft Dataverse vbo? Using this VBO, I was trying to retrieve and update the tables.

Please can any one give me a resolution or an idea how to use this VBO?

Thanks in advance,

------------------------------
Abhijith Raj
Automation Engineer
FourNxt
Asia/Kolkata
------------------------------

RE: Microsoft Dataverse VBO

PabloSarabia — Thu, 03 Mar 2022 07:44:00 GMT

Hi @Abhijith Raj

Inside the VBO page from the Digital Exchange you have a full guide about how to use this Object and how it works.

Here you have the link, hope this helps you

Guide

See you in the community, bye :)

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
634726270
------------------------------

RE: Microsoft Dataverse VBO

AbhijithRaj — Thu, 03 Mar 2022 07:52:00 GMT

Hello Pablo,

Thank you so much for our response. I have gone through the guide and was able to establish a successful connection to the dataverse environment. But my doubt is how to use the action "Retrieve multiple records". How do we mention from which table/entity we need to retrieve the records?

Thanks in advance.

------------------------------
Abhijith Raj
Automation Engineer
FourNxt
Asia/Kolkata
------------------------------

RE: Microsoft Dataverse VBO

shashank.kumar280 — Thu, 03 Mar 2022 08:28:00 GMT

Hi Abhijith,

This doc https://docs.microsoft.com/en-us/powerapps/developer/data-platform/webapi/perform-operations-web-api would be a good place to understand more about the API as there are number of parameters that could be passed into the API.

As I was looking into the WebAPI definition, it seems it might need some changes/parametrization in order to make it generic. From the below screenshot it seems the table name should go in place of "accounts". So it would be /tablename?[filter].
I didn't try it out now to validate this on my end as don't have the Dataverse account setup. But if it works then you might have to parameterize the URL path accordingly in other actions as well.

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

RE: Microsoft Dataverse VBO

ewilson — Thu, 03 Mar 2022 12:26:00 GMT

Hi @Abhijith Raj,

Thanks for bringing this to our attention. It seems an older, pre-release, version of the connector was pushed to the DX. It has been replaced with a version that supports specifying the table name, and key value where applicable.

The corrected version can be found here.

Cheers,

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

RE: Microsoft Dataverse VBO

AbhijithRaj — Thu, 03 Mar 2022 15:15:00 GMT

Thank you Shashank for the suggestion. Let me try it out.

------------------------------
Abhijith Raj
Automation Engineer
FourNxt
Asia/Kolkata
------------------------------

RE: Microsoft Dataverse VBO

AbhijithRaj — Thu, 03 Mar 2022 15:16:00 GMT

Thank you so much for the update Eric.

I was trying to connect to Power Apps. Could you please give me an idea what should be mentioned in the field "Dynamics365URL"?

Regards,

------------------------------
Abhijith Raj
Automation Engineer
FourNxt
Asia/Kolkata
------------------------------

Re: RE: Microsoft Dataverse VBO

maneesh.vemula1 — Thu, 06 Jun 2024 02:56:15 GMT

Hi Eric - I am seeing the below error when running the 'Retrieve multiple records' action from the business object.

Internal : Unexpected error Error during Web API HTTP Request
HTTP Status Code: 401
HTTP Response Content:

I am able to authenticate and get the access token before I perform the above action. The App ID registered has system admin security role so that should not be an issue.

Do you have any guidance or any other things i need to look at to resolve this?