Incremental ingestion of data

We need to pull data using GraphQL on an incremental basis. Since Retool doesn't support scheduled jobs yet, we are planning to run the GraphQL query every day for first log in ( not sure how to do this either).
We need to store the timestamp of the last query that was run so that we only retrieve records created after that timestamp to get data from GraphQL. Where would you suggest storing this timestamp?

Hi @historicgeek Could you use the .lastReceivedFromResourceAt property?

You could set your query to trigger manually & run once on page load.

Then, you can set the query to cache the results (under the Advanced tab of the query):

If multiple users will be opening the app, you can also have an admin in your org set the query caching to work across all users (Settings->Advanced):