In an earlier post, I described how to set up Postman to test calling your AX data entities. http://daxvisionerp.com/call-ax-data-entity-from-postman/
You can also read data from AX data entities using Excel. It is easy, no need for secret and token, etc, you just need to log in with your AAD credentials. Let me quickly show the steps using VendorsV2 entity: ‘https://usnconeboxax1aos.cloud.onebox.dynamics.com/data/VendorsV2’
- Click ‘Data/New Query/From Other Sources/From OData Feed’
2. Set data entity OData feed URL
The first time you will get a login dialog after clicking the ‘OK’ button.
4. Result in Excel, data loaded
So, this way you can easily load your data to Excel and get a comfortable format.
I used this post as reference: https://wem.io/documentation/tips-and-tricks/data/odata-excel2016/