Odata request to D365 F&O returning a blank response. How to troubleshoot and resolve?

Recently, my customer’s team reported that they are sending Odata request to D365, but they are getting blank response. Same Odata request was working on another UAT environment with the same data, but its not working in this environment.

Now, let’s talk about how to troubleshoot and resolve this issue. What you need to check is the user that is tied to the client id, that external application is using to pass the data to D365. By default, OData returns only data that belongs to the user’s default company. In my case, the company was selected as DAT, so it was not returning any data. Here is how to resolve this:

Goto System administration -> setup -> Azure Active Directory applications. On this form, check which Client Id you are using in your external applications, select that record and click on the User under the User ID column. On Users form, make sure that the Company selected is the one that has the required data for which the request is being made from external applications:

The second option is to use the cross company filter with Odata request, so that you get the data outside of the user’s default company. Remember, this will return data from all the companies setup in D365 that the user has access to. Here is the link to the docs site explaining how to use the cross company filter :

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata#cross-company-behavior

Enjoy!