September 12, 2022

Using VS Code and RapidAPI to call D365FO custom services

Filed under: 365 for Finance and Operations,Data Entities — Joe Brewer @ 3:59 pm

Here is a guide to install RapidAPI into VSCode.

Once you have installed RapidAPI, check out this guide for creating new requests.

Once you have created a new request for the custom service, change the request type to “POST” and put the full url to the service in the address box. For this example I am using the standard service for converting a decimal number to text.


To configure a service for D365FO, click on “Auth”, and then “OAuth 2”. Click on the “Client Credentials” radio button, enter the client id and client secret from the web application in Azure AD.

The access token url is where xxxxxxx is the tenant that the D365FO environment belongs to.

The scope is the url of the D365FO environment followed by “/.default”

The Token Prefix is “Bearer”

When you press the “Get Access Token” button, assuming the configuration is correct, you will get a pop up dialog showing the access token. Click on “Use Token” to accept and use the token. Note that once the OAuth 2 settings have been entered, the Headers tab will automatically update to show that the service will use OAuth 2 to authenticate.

Switch to the “Body” tab and enter the following JSON:

  "_sourceNumber": 12.34,
  "_languageId": "en-GB"

Pressing send will then send the request to D365FO and show the response:

Though I have not tested it yet, it appears that the request type can implement the ODATA verbs which would be very useful for testing data entities.

So, what do you think? Is this a contender for a Postman replacement for testing integration services with D365FO?

September 11, 2022

10.0.29 Data Entities for Finance & Operations

Filed under: 365 for Finance and Operations,Data Entities,Uncategorized — Joe Brewer @ 4:49 pm

Here is the latest collection of data entities for 10.0.29 in both en-GB and en-US languages. I have added some new columns which show which countries the data entities are enabled for, and the configuration key path if a configuration key is needed to enable the data entity.

10.0.29 Data Entities – en-US

10.0.29 Data Entities – en-GB

July 15, 2022

10.0.28 Data Entities for Finance & Operations

Filed under: 365 for Finance and Operations,Data Entities — Joe Brewer @ 3:44 pm

Sorry it’s taken a while to publish an updated version of the spreadsheet containing data entities and related metadata. I fully intend to release the code that I have written that does this in the future, once it has been cleaned up.

In the meantime, you can download the spreadsheet here. Please let me know what you think of this project.

2022-07-22 Update: The spreadsheet is now available in the en-US language. This version can be downloaded here.

March 11, 2022

postTargetProcess not being called on child entities in a composite entity

Filed under: 365 for Finance and Operations,Data Entities,Software — Joe Brewer @ 2:37 pm

If you have ever done any testing and development with data entities you may have noticed that the static method postTargetProcess() does not get called for child entities in a composite data entity. For a recent project I needed this method to be called on the SalesOrderHeaderChargeV2Entity and SalesOrderLineV2Entity when data is imported using the SalesOrdersV3 composite data entity is used to import sales orders.


February 13, 2022

10.0.24 Data Entities for Finance & Operations

Filed under: 365 for Finance and Operations — Joe Brewer @ 7:22 pm

This blog post represents a challenge that I set myself a while ago to generate a list of data entities with underlying tables. What I ended up coding was a way to generate a spreadsheet that contains all sorts of data that would be useful for easily finding appropriate data entities for specific tasks. Need to find a data entity for Arrival Groups (ITMArrivalGroupTable) that works with data management? No problem! Need a data entity for Retail Transaction Addresses (RetailTransactionAddressTrans) that can be accessed using ODATA? Piece of cake! How about a list of all data entities that can use multi-threading? You got it!

Older Posts »

Powered by WordPress