Read selected data from D365FO based on filter using Postman

Hi,

In this post we will view the steps to read the data from a given entity based on filter criteria in D365FO. For demo purpose, I have chosen CustomerV2 entity.

Step 1: Register D365FO in Azure Platform. Please refer to previous post to view the steps for App registration.

 Application registration of D365FO with Azure 

Step 2: Setup Postman with D365FO. Note: Used environment variables to setup bearer token and authorization in this post.

 Postman Set up with D365FO 

Step 3: Retrieve the OData URL for customer entity. In my case it is https://D365FO URL/data/CustomersV2.

Step 4: Launch Postman, select the Devbox collection and click on three dots. Select Add Request and provide name (say) Filter Customer based on account.

Add Request

Request Name

Step 5: Provide the command for the GET Request with URL as {{resource}}/data/CustomersV2?$filter=CustomerAccount eq 'TEST001' where resource is the D365FO URL provided in the environment section.

Here under parameters section, used query option $filter and supplied the value as CustomerAccount eq 'TEST001'. 

Step 6: Under Headers group, created new entries for

Step 7: Click on Send button to view the output with the status as 200 OK.

Regards,

Chaitanya Golla