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;
}
}
}
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー