How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

We frequently use Advanced Find to query the data in Dynamics 365 CRM Online environment, but this always not helps us to achieve the desired results.

In XrmToolBox, there is a Tool "SQL 4 CDS" to query Dynamics 365 CRM/ Dataverse environment online.

Follow the below steps to query your Dynamics CRM data.

Step 1

Launch XrmToolBox and Install "SQL 4 CDS" tool.

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

Step 2

Click on Yes to connect to your organization.

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

Step 3

Select your required Dataverse connection and Click on Connect.

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

XrmToolBox is getting connected to the Dataverse environment.

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

Step 4

Once, XrmToolBox is connected to Dataverse environment successfully, you can see the below SQL Query editor like window.

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

Step 5

You can start writing your SQL Query in the Query editor.

In this example, i want to get the Top 10 records of Contact table with firstname, lastname, fullname, mobilephone and emailaddress1 rows data.

Select top 10 firstname, lastname, fullname, mobilephone, emailaddress1 from contact

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

Step 6: Click on Execute to get the result.

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

Below is the result retrieved from Contact table from the required Dataverse environment.

How To Query Data In Dynamics 365 CRM Online Using XrmToolBox

You can query based on your requirement and get the desired results using this SQL 4 CDS tool in XrmToolBox.

Hope you liked this article and do please share your valuable feedback on this article.