I have an aplication which connects with an API through JSON Rest. In this API, every call can extracts an maximum of 1.500 registers through 15 pages, each one with 100 registers. The parameter which sets the beggining of the load is the log date ('YYYY-MM-DD hh:mm:ss'), limited between initial date and final date (here, the ReloadTime()).
Day by day it works fine, using the below load script:
SET vInitialDate=(here We have the maximum date generated in the last load).
Every load is programmed through QMC to starts every 20 minutes. The problem here is when the number of registers reachs 1.500. In the script above, the load stops when this happens. In this situation, I have to wait for the next programmed load to extract the others records and so on.
Is there a way to insert the maximum log date in the each loop's load, possibiliting restarting of the routine considering each new maximum date, stopping the load when reaching zero number of the rows?