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