Using OData API and need the filteration of data using creation and updation data

Finance and Operations/AX Developer Forum
1

Hi,

We have been using the OData Rest API and need on how we can filter the data for CustomersV2,ReleaseProducts,InventorySitesOnHand,etc. using the creation and update date filter currently as I have checked the created and modified date parameters are not available in the default entity list.

Also, ShipmentsTableV2 endpoint is not available in default meta data entities kindly suggest how to enable it for use.

It would be good a call with any technical team members or have your valuable input for the same.

2

First of all, think about what you mean by a modified date time of an entity. For example, if I update customer’s primary address, the entity starts returning different data. But there is no change in CustTable, therefore its ModifiedDateTime still has the same value. What result do you want to get in such a case?

Which entity do you mean by ShipmentsTableV2? Where did you get this name?

3

Hi @MartinDrab ,

Thanks for you response.

We are basically trying to fetch the Customers, Products, Inventorys records using the OData REST API for D356 Finance and Operation. But we are not able to filter using the time when it was created or modified.

We are using the below request URLs:
{{baseUrl}}/data/CustomersV3
{{baseUrl}}/data/ReleasedProductsV2
{{baseUrl}}/data/InventorySitesOnHand

Is there a way through which we can fetch the records using the created date of the records and also using the modified date?

4

You didn’t give me any new information, therefore please see my previous reply.

I understand that you want to filter by “the time when it was modified”, but what does it mean? You need to know what values you want to get there before you can create such an entity field and use it in filters.

5

Hi @MartinDrab ,

We are doing an API integration in which need to get notified when something is updated in the Customer/Product/Inventory. Any modified date time parameter or Webhook settings for this purpose will help?

Can we have a teams/zoom meeting so that we can explain you our requirement more specifically?

6

There is no such settings. You can add a field to entities, but you can’t develop it without first deciding what value you want to get. Entities typically consists of multiple tables (notice my example with customer address).

I’m willing to help you in this forum but I don’t have time for being hired to work on your project.

7

It might be an extra step, but could you export it to a data lake using the native data lake export functionality? The lake has info about when the record was created and modified. It’d be slightly asynchronous, but im not sure how real time your application needs to be.