OData Filters

OData is an Open standard protocol for creating and consuming data.

We can create or update or delete only a single record using OData.

URL to get the all public entities.

D365 URL/data

To get the Particular Entity:

URL/data/public collection name of entity/?cross-company=true.

the name should be same as public collection name even capital and small letters also.

without using cross-company=true you will not get any data.

To get in JSON format :

URL/data/Vendors?cross-company=true&$format=json

To apply filters:

URL/data/Vendors?cross-company=true&$format=json&$filter=VendorAccountNumber eq 'US_SI_000006'

&$select=VendorAccountNumber ,DefaultOffsetAccountType

Filter details which can apply in URL

OData Actions:

Reference:

Data Integration with OData

https://www.youtube.com/watch?v=RshNKniFomI