In Deluge, when I try to use zoho.sheet.createRecords to add to more than 1000 rows, I get this error:

Only some of the data is added to the sheet. The number of rows added varies each time, but it never adds them all.

Also, when I try to open the sheet I am adding to, it won't load the data for a very long time. It is essentially so slow that it is unusable. I have to reload it over and over to get it to show any data, and then it is very spotty and slow. 

Are there any known workarounds or fixes, for this? I can't use the Sheets API, because it quickly uses up all of our webhooks.

pageList = {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45};

for each  x in pageList

{

response = invokeurl

[

url:"https://inventory.zoho.com/api/v1/contacts?organization_id=xxxxxxxxx&page=" + x + "&per_page=200"

type:GET

connection:"zoho_inventory"

];

current_contacts = response.getJson("contacts");

for each  contact in current_contacts

{

if(contact.get("contact_id").size() > 0)

{

row1 = Map();

row1.put("Contact ID",contact.get("contact_id"));

rowsData = List();

rowsData.add(row1);

queryData = Map();

response = zoho.sheet.createRecords("dpuhwab77xxxxxxxxxxxxxxxxxxxx","Sheet1",rowsData,queryData,"zoho_sheets");

info response;

}

}

}