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
Best answer by Thomas Lind
View original
+5
Hi
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
+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.
+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.
+5
Hi
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?
+5
Hi
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
