How do I get more than 200 records from CRM
I want to populate a lookup field in a Creator Form with the Account Name from the Accounts module in our CRM. I will be creating a quote in our CRM later in the process and I don't want the users to mistype the clients name and then have to have multiple records for the same client in the CRM (just because of mistakes).
I can get it to work fine with the code below, but I can't quite figure out how to use multiple calls to get ALL the records from our CRM not just the first 200. Or even if I can get all the records and not just 200.
My drop down list on the form is called "ddnClients"
My Code:
crm_query = Map();
crm_query.put("sort_order","asc");
crm_query.put("sort_by","Account_Name");
clientList = zoho.crm.getRecords("Accounts", 1, 200, crm_query, "myconnection");
for each clientRecord in clientList
{
input.ddnClients:ui.add(clientRecord.get("Account_Name"));
}
How do I get the balance of the records and add them into my drop down list?