Saturday, October 12, 2019

D365FO - Data integration by OData (Part 1 of 5)

D365FO - Data integration by OData (Part 1 of 5) You are here!
D365FO - Data integration by OData (Part 2 of 5)
D365FO - Data integration by OData (Part 3 of 5)
D365FO - Data integration by OData (Part 4 of 5)
D365FO - Data integration by OData (Part 5 of 5)



There are many ways to integrate with D365FO. OData is one of them. This series show you how to do simple integration. I researched data from books and Internet and put the references at the end of this blog series.

Basically this is a simple concept to integrate an external system with D365FO. The big customization is OData client which will be created as C# console application. The scope of this series are in green rectangular.


















There are 3 main steps:
  1. Create a table, data entity, and OData service endpoint (Part 1)
  2. Register and prepare (OData client) application authentication in AAD and D365FO (Part 2)
  3. Create OData client application (Part 3, 4, and 5)


Create a table, data entity, and OData service endpoint


First, we create a sample 'MyCar' table.

CarID, BrandName, SerieName and Color declared as string, Price as real, and PurchasedDate as date. Then create an index for CarID and set that index to be table's Primary Index. 



Then create a data entity. After finished creating, note some data entities, tables, and security privileges are added into project.























**Note: After the data entity is created, OData service endpoint is also created automatically. 
**Note: All customization and tests are made in OneBox machine.

Now, re-check what we've just created.

Table 

The result looks good. We can see the table with empty data.











OData

If you get return something similar to the following figure, then it means OData service endpoint is ready to use.







=== End of Part 1 ===

2 comments:

  1. Hi,

    i want to create customer group can you tell what changes should i do?

    ReplyDelete
    Replies
    1. Hi,

      when dealing with the AX standard database tables e.g. customer group, it is likely to be easier, because you don't need to create a custom table as shown in above example. You can consume (get or send update) to that table directly by creating an OData URL.

      Delete