Let say, I have an API that can request 2000 data only per request. I need to get all data which is > 200k. So I tried to get data by using offset and limit. To get all data I tried to increase offset. If the total get data is still not exceeding > 200k (totalData > totalGetData), it will repeat to make another request.
My question is, how to export for this large dataset in a single sheet.
Hi,
Let say, I have an API that can request 2000 data only per request. I need to get all data which is > 200k. So I tried to get data by using
offset
andlimit
. To get all data I tried to increase offset. If the total get data is still not exceeding > 200k(totalData > totalGetData)
, it will repeat to make another request.My question is, how to export for this large dataset in a single sheet.