Error using zoho.sheet.createRecords: There was a problem while trying to integrate with DRE
In Deluge, when I try to use zoho.sheet.createRecords to add to more than 1000 rows, I get this error:
There was a problem while trying to integrate with DRE
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;
}
}
}
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Orchestly Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー