Since I couldn't pull all contacts from Zoho Books to Creator, I decided to create two lists and keep them in sync. Among other things, keeping them in sync means if a contact is updated in Zoho Books, the corresponding contact should be updated in Zoho Creator.
But before I can update the record in Creator, I need to first fetch the correct record. So after digging through the available documentation, I came up with the following script.
contact = customer.get("contact_name");
booksID = customer.get("contact_id");
response1 = zoho.creator.getRecords("me","customers","Customer_List","Display_Name==\"contact\"",1,200);
response2 = zoho.creator.getRecords("me","customers","Customer_List","Display_Name==\"contact\"",201,400);
response3 = zoho.creator.getRecords("me","customers","Customer_List","Display_Name==\"contact\"",401,600);
response4 = zoho.creator.getRecords("me","customers","Customer_List","Display_Name==\"contact\"",601,800);
The above script is supposed to fetch me a record from Zoho Creator whose Display Name matches that of the chosen contact in Zoho Books. However, I keep getting the response that no such contact is available in zoho creator.