For a REST endpoint we need to load incremental, how can I set up incremental columns in ODX and pass this values in the RSD file?
Solved
ODX REST api with incremental values
Best answer by Thomas Lind
Hi Gaspard
There is not an specific guide for this exact thing, but there are some options regarding dates that can be used.
Create an dynamic date range filter
When you have this range that automatically changes, you can just set up incremental load on the table the RSD file generates and it will add just the new rows. Be sure the field you set up the rule on gets updated with a newer date/number if there is changes, otherwise it will not be added by the rule.
The official CData guide also have some suggestions, but I have not used it yet.
https://cdn.cdata.com/help/DWF/ado/pg_customschemaselect.htm#process-select-where-on-the-server
Try it out.
+5Hi Gaspard
There is not an specific guide for this exact thing, but there are some options regarding dates that can be used.
Create an dynamic date range filter
When you have this range that automatically changes, you can just set up incremental load on the table the RSD file generates and it will add just the new rows. Be sure the field you set up the rule on gets updated with a newer date/number if there is changes, otherwise it will not be added by the rule.
The official CData guide also have some suggestions, but I have not used it yet.
https://cdn.cdata.com/help/DWF/ado/pg_customschemaselect.htm#process-select-where-on-the-server
Try it out.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
