Using the Dataverse REST Builder to Build REST Requests

7 Comments

One question that has come up a few times has been are there alternatives to the CRM REST Builder, an awesome tool that was built some time back by Jason Lattimer and appears to be no longer being maintained. Guido Preite has built a worthy alternative, the Dataverse REST Builder that runs in XrmToolbox, as a managed solution, and in Dataverse DevTools (VS Code). Let’s take a look at it.

First, let’s install it in XrmToolbox:

Connect to an org and open the tool. We see the File menu. Here we can create, load, and save collections, as well as export to Postman collections, export REST Client Environment, and export Thunder Client environment:

Let’s create a new collection, and create a New Request. We see there are many request types available:

Let’s try a simple Retrieve Multiple. We land on the Configure tab, where we can select the Web API version, async vs sync request, lots of other filters:

Let’s add a table. In typing the table name, the view is filtered:

Let’s select some columns:

And we get the option to filter by and order by:

Once our query is complete, click on one of the tabs to see the query. If we select Xrm.WebApi, we see our code:

Note the option to Move Code to Editor, which allows us to execute the code. I missed this previously, but this functionality won’t run inside of XrmToolbox (as per the message below) – it will run in the app, as we will see shortly:

Copying the generated code to a browser console, we see it works perfectly:

You also get other code formats, as well as the Power Automate list rows connector format:

Let’s try the Postman export. I renamed by collection and query, then exported:

In Postman, I import:

The collection imports, and after authenticating you can run the query:

To run it as a managed solution, download the file from here:

And install it through the Power Apps Maker portal:

Publish, and you will see it in your list of apps:

We can see the interface is the same as when running this through XrmToolbox, and we can execute successfully the query we built earlier:

The tool looks like a great way to build queries, and you can see Guido has thought through many of its features to make it very user friendly.

THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.
 

I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.

IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.

THANK YOU, AND LET'S KEEP LEARNING TOGETHER.

CARL

https://www.youtube.com/carldesouza

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube

 

7 Responses to Using the Dataverse REST Builder to Build REST Requests

  1. Hi there, thank you Carl for an amazing article on Dataverse Rest Builder connection. I am facing this error while establishing connection to my CRM Environment: Dataverse REST Builder requires the Microsoft Edge WebView2 runtime in order to run.

    I have the WebView2 installed on my computer.

    Thank you in advance.

Leave a Reply

Your email address will not be published. Required fields are marked *