Retrieve multiple records from Dataverse

Dustin Miner

The post describes several methods to retrieve multiple records from Dataverse

Retrieve data using C#

Query Expression

Figure 1

FetchXML

Figure 2
Figure 3

LINQ

Note: Early binding is required for this. In this example, there would need to be an early binding file for ‘SystemUser’ (Figure 5)

Figure 4
Figure 5

Retrieving data using TypeScript / JavaScript

Web API

Example 1

Figure 6

Example 2

Figure 7

Figure 8 & 9 represents how Figure 7 can be updated to use a custom helper function setLookupValue(). For more information see Get and set a dataverse lookup column

Figure 9

Example 3

Figure 10

Further reading

Make XRM WebAPI calls synchronous

References

https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/xrm-webapi/retrievemultiplerecords

https://learn.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.iorganizationservice.retrievemultiple?view=dataverse-sdk-latest

Post Views: 447

Related Posts