I have created a custom table in D365 Finance & Operations which is used to save some user selected information about financial dimensions setup, invoice journals and payment methods. This information needs to be exposed to an oData endpoint as it is used in an integration with a third-party system which pushes information to D365 and needs to know which journal to use, which dimensions to push etc.
The custom table that we have contains references to several other tables. Below is a screenshot of the table with relations expanded:
The way I created the Data entity is by right clicking on the table and selecting automatic creation of the data entity through the provided wizard. The entity is marked as public and we try to make a request against that endpoint. The result is:
Since the generated entity did not copy the relations to the other tables, I presume it required manually adding them, so I did:
The cardinality is set to ZeroOne on all with Association relationship type. It did not change the resulting error.
I am not sure which subquery the engine is referring to and whether an additional configuration is necessary so we can see in an oData endpoint the data saved in that table.
Any ideas what I am missing in this entity to do this seemingly easy operation of exposing the data of the table through an oData endpoint?
