Skip to main content

Dataverse / Dynamics CRM

Read accounts, contacts, opportunities, and any custom entities from Microsoft Dataverse (the data backbone of Dynamics 365 Customer Engagement).

Discover​

SELECT * FROM crm_show_entities();
SELECT * FROM crm_describe(entity => 'account');

Read​

SELECT name, revenue, industrycode
FROM crm_read(entity => 'account')
WHERE statecode = 0;  -- Active accounts

$expand is supported for related-entity navigation:

SELECT name, primarycontactid_value
FROM crm_read(
  entity => 'account',
  expand => 'primarycontactid'
);

Predicate pushdown applies to all standard scalar columns.