Solved

Incremental loading with APIs

  • 3 March 2023
  • 6 replies
  • 49 views

Badge

Dear Support,

My customer is using AFAS. From this tool they load data into TimeXtender with an API.

They have a wish to load the data from AFAS incrementally in the ODX.

Is it possible to load incrementally from an API to the ODX server and what are your suggestions to start with?

 

Best regards,

Christian Koeken

icon

Best answer by Thomas Lind 24 March 2023, 11:43

View original

6 replies

Userlevel 4
Badge +5

Hi @christian.koeken 

Yes if they are using the RSD REST provider, they should be able to add primary key and incremental rules on their data source (assuming the tables have primary key fields and a modified date timestamp). Please see the following guide

 

Userlevel 3
Badge +5

Hi Christian

That depends on how the API can be used. It is a requirement that a date field, ideally datetime field exists that can limit what is given back from the API.

Like URI: https://www.api.com/rest/v2/sales?from=2023-03-03

If you have that, you can use a RSD file and add a dynamic date to add to it, for example yesterday and then use that in your data source.

In the BU you can add a parameter and use the max value from the incremental table in a dynamic variable.

I have an idea that may give the same in a ODX, but I do not have a proof about it working.

Userlevel 3
Badge +5

Hi Christian

I actually have a file using AFAS, that was used as a template for testing if Incremental load would work.

So it will be possible to set it up for you as well.

Userlevel 4
Badge +5

@christian.koeken is the issue resolved? If so could you help us by marking a best answer above? Please let us know if we can assist further

Badge

Hi @Thomas Lind,

 

In your last post you said you have a file using AFAS, that was used as a template for testing if Incremental load would work.

Am I right that you have an example for me that would possibly work?

Userlevel 3
Badge +5


Hi @christian.koeken

Yes I have sent the files to you.

In essence what I do is a Input field, which is explained in my Advanced RSD guide and for the ODX you use a dynamic date range and a query slicer query.

Reply