CRM COQL fetch for up to 100K records

07/28/2025 12:21 PM - Comment(s) - 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;
    }
}

Jesus Sosa

Share -