All ToolsDataverse OData Builder

Dataverse OData Builder

Compose Dataverse Web API endpoint URLs for Power Apps and Power Automate HTTP actions. Build /api/data/v9.2/... queries with full OData parameter support.

Dataverse OData tips

Entity names are plural logical names: accounts, not Account
Lookup value columns use _fieldname_value in $select (e.g. _ownerid_value)
GUIDs in $filter are unquoted: accountid eq 00000000-0000-0000-0000-000000000000
Use navigation property names for $expand (e.g. primarycontactid)

Environment URL

Entity (Table) Name

API Version

$select — columns to return

$expand — navigation properties

$filter — OData filter expression

$top — max records

$orderby

Generated Endpoint URL

https://orgabc.crm.dynamics.com/api/data/v9.2/accounts

Required Request Headers

OData-MaxVersion:4.0— Declares OData version support

OData-Version:4.0— Required for all Web API requests

Accept:application/json— Returns JSON; add odata.metadata=minimal to reduce payload

Content-Type:application/json; charset=utf-8— Required for POST/PATCH