Skip to main content

Notifications

Dynamics 365 for Finance and Operations number of records on entity via odata query

A quick tip how to see entity total number of records without actual export (example from devbox on local Contoso VM):

https://usnconeboxax1aos.cloud.onebox.dynamics.com/data/Customers?$count=true&$top=0

Url parts:

  • https://usnconeboxax1aos.cloud.onebox.dynamics.com is your dynamics ax url
  • /data/ is a constant
  • Customers is entities public collection name
  • ?$count=true flag to output total records count
  • &$top=0 parameter to return 0 records themselves

It will downdload json file with following data:

2019_2D00_04_2D00_10-13_5F00_35_5F00_40_2D00_D365FO_5F00_July2017_5F00_PU11_5F00_MSF-on-LAPTOP_2D00_ERU051NN-_2D00_-Virtual-Machine-Connection.png

From this example we are having 2030 total count of customers

Comments