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:
If we click on the Move Code to Editor button, we can Execute the code:
I was having trouble running this inside of the tool, but the generated code works perfectly in a browser console:
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.
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
