D365 F&SCM Dataentity query builder / DaxOnline

Query parameters

Data entity

Language

Base URL

edit

Company

Cross comp.

Filter

filter by key | filter by custom field

Use asterisk (*) for a broader search in the strings
Example: (Fld1 eq '1' or Fld2 eq '2') and Fld2 eq '*word*'
Date/time format: 2025-02-28T05:54:11Z

Parameters

Parameter	Description
$orderby=Rating,Category desc	Sorts the records.
$top=10	List the first three records.
$skip=10	Skip the first three records.
$count=true	Adds a node with records count.
$expand=ChildEntity($select=Fld1,Fld2)	Expand with information from child entity with public collection name ChildEntity. For this feature to work proper relation should be declared on the child data entity to parent data entity:

show/hide help
show/hide field selection: all field(s) selected.
show/hide URL

Field selection

URL

Field search

Based on Microsoft D365 F&SCM 10.0.42.

D365FO Tools

If you found value in these tools, I've set up a Buy Me a Coffee page as a way to show your support and cover some inevitable costs associated with running a site.

Buy Me a Coffee

D365 F&O oData public entity query builder

Query parameters

D365FO Tools

Useful Links

Tools

Advertisement