I have created a script to pull incoming records to a database and post them to another dbase via REST. I have everything working, however I have one hurdle. The source table is very large and I’d like to simply query only new records since the last run of the script. How can I keep track of either the timestamp I ran the last query or the last key number so I can only get the new records?
I don’t see a way to assign a “global variable” or something of the type that could hold this info. The only other solution that seems possible is to write this info into a file and read it back, but I don’t see how to do this either.
I am very new to the product and absolutely love it so far, but I may just be missing a very fundamental function here.
Any help is greatly appreciated!