Zoho times out on searchRecords request

Zoho times out on searchRecords request

Hi

I am using a block of Deluge code to check all my contacts that dont have a scheduled call for them and then if  they don't sheduling a call. I have 6000 contacts with about 70 percent of them already having scheduled calls. Its the 30 percent that dont that I am trying to get and fix.

I am getting inconsistent results with the searchrecords function, it also isn't assigning to all the contacts that dont have a scheduled call. It is also adding a scheduled call to a contact that alreasy has one, and lastly the most frustrating part is that ZOHO times out.

I am not entirely sure how the searchrecords command actually works in Zoho, does it just check the same records over and over again every time you run it and that's why it is timing out and not finding new records that don't have a scheduled call?

Could you also advise if the code below is actually the most effective way to do this?



  2. loop = {1,2,3,4,5.6,7,8,9,10};
  3. Contactswithoutcall = List();
  4. for each  ele in loop
  5. {
  6. MyContacts = zoho.crm.searchRecords("Contacts","(Owner:equals:4775614000000386180)",1,200);
  7. if(MyContacts.size() == 0)
  8. {
  9. break;
  10. }
  11. // Get contacts that dont have a scheduled call
  12. for each  rec in MyContacts
  13. {
  14. val = "";
  15. relcalls = zoho.crm.getRelatedRecords("Calls","Contacts",rec.get("id"));
  16. if(relcalls.size() > 0)
  17. {
  18. for each  call in relcalls
  19. {
  20. ctime = call.get("Call_Start_Time").toTime("yyyy-MM-dd'T'HH:mm:ss");
  21. if(ctime > now)
  22. {
  23. val = "Yes";
  24. }
  25. }
  26. }
  27. if(val == "")
  28. {
  29. Contactswithoutcall.add(rec.get("id"));
  30. }
  31. }
  32. }
  33. // info " Contact List;" + Contactswithcall;
  34. info "Account Count : " + Contactswithoutcall.size();

  36. for each  contactelement in Contactswithcall
  37. {
  38. contactDetails = zoho.crm.getRecordById("Contacts",contactelement);
  39. // info contactDetails;
  40. createdtime = zoho.currentdate.toTime("yyyy-MM-dd'T'HH:mm:ss").addBusinessDay(2);
  41. mp = Map();
  42. acctname = ifnull(contactDetails.get("Account_Name"),"");
  43. if(acctname != "")
  44. {
  45. acctid = acctname.get("id");
  46. accountDetails = zoho.crm.getRecordById("Accounts",acctid);
  47. mp.put("$se_module","Accounts");
  48. mp.put("What_Id",acctid);
  49. }
  50. mp.put("Subject","Prospecting");
  51. mp.put("Owner",ifnull(contactDetails.get("Owner"),"").get("id"));
  52. mp.put("Call_Type","Outbound");
  53. mp.put("Who_Id",contactDetails);
  54. mp.put("Call_Start_Time",createdtime.toString("yyyy-MM-dd'T'HH:mm:ss+02:00"));
  55. mp.put("$which_call","ScheduleCall");
  56. create = zoho.crm.createRecord("Calls",mp);