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 answer by Thomas LindView original
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
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.
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.
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?
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.