Hi All,

Just wanted to share some code I created this morning that counts the total # of records in any module using Zoho Connections and API V2. All you have to do is create a connection to your CRM by clicking on the settings tab then click on "Connections" under Developer Space. Create your Zoho OAuth connection and copy your InvokeUrl code.

Hopefully Zoho can implement something better but for now this works for me and you can expand on it.

2. max = collection("1","2","3","4","5","6");
3. page = 0;
4. Count = 0;
5. for each record in max
6. {
7. page += 1;
8. URL = "https://www.zohoapis.com/crm/v2/Leads?page="+page+"&per_page=200";
9. response=invokeUrl
10. [
11.   url: URL
12.   type: GET
13.   connection: zcrm
14. ];
15. 
    
16. Information = response.get("info");
    
17. // This is the "info" section in the json list so that you can get the page info.
18. 
    
19. Count += Information.get("count");
    
20. // This gets the total number of records per page.
21. 
    
22. MoreRecords = Information.get("more_records");
    
23. // This is a boolean value. If there are more records it will be true.
24. 
    
25. PageNumber = Information.get("page");
    
26. // This gets the page number. I'm thinking of modifying the collection with this number to adjust the # of API calls if possible.
27. 
    
28. if(MoreRecords == false)
    
29. {
30. info "Total Records: " + Count;
31. return "No More Records";
32. }
33. }
34. return "Finished";