getAPIResultList(); appears to have a 1000 records restriction/limit.

Am using getAPIResultList() on a sheet with 1600+ entries/records but it only returns 1000. Why? And how do I code to process all records come what may?

Have answered my own question. Just discovered the setLimitSize() & setLimitFrom() functions which explains everything. Find it surprising that Ragic don’t offer a more elegant solution rather than all users having to code around this limitation.

1 Like