How to do?
Import data from external source where response data is delivered in Json.
Dataset is large and will be delivered in chunks
A chunk is 500 objects and part of the response of the first chunk will be an id for the next chunk. This means that the request for the second chunk can only be performed when data from the first chunk has been fetched.
I want the imported chunks to be listed after each other
Chunk 1’s data
Chunk 2’s data
I found out how to get the first chunk by updating a field in google sheet and then onchange event trigger to run a script which is actually just inserting a new formula in a cell like =importjson(xxx?123) - 123 is just a incremented value. The importjson will then run.