What's the best way to retrieve records through API when survey is over 30,000 records?

[stephanealoo]

Hi,
Would this work for you

Link KoBoToolbox to Power Bi using APİ and 30000 rows limitation Problem

You’ll have to retrieve the data in batches. You can use https://kc.humanitarianresponse.info/api/v1/data/XXXX?format=csv&sort={"_id":1}&start=30000 to skip the first 30,000 submissions, for example. The sort part is important; without it, your submissions may not be returned in a consistent order, and the batches may omit or duplicate submissions. You may also use MongoDB query operators to filter your data, as described in “Query submitted data of a specific form” in the documentation at the …

Regards,
Stephane