CRM COQL fetch for up to 100K records
07/28/2025 12:21 PM - By Jesus Sosa
repeats = repeat(",",49);
info repeats;
offset = 0;
iteration = 0;
allContacts = list();
iterationComplete = false;
for each r in repeats
{
if(iterationComplete == false)
{
queryMap = Map();
queryMap.put({"select_query":"select Last_Name, First_Name from Contacts where Last_Name is not null limit " + offset + ", 2000"});
response = invokeurl
[
url :"https://www.zohoapis.com/crm/v8/coql"
type :POST
parameters:queryMap.toString()
connection:"crmcoql"
];
contacts = response.get("data");
info contacts.size();
if(contacts.size() < 2000)
{
iterationComplete = true;
break;
}
allContacts.addAll(contacts);
info allContacts.size();
iteration = iteration + 1;
offset = iteration * 2000;
}
}