GitHub
Books
Fetch Records Using CRM IDs

Fetch Records Using CRM IDs

You can fetch Books records using the records CRM ID when using the Books to CRM integration. This allows you to fetch a Books contact record using the CRM account id, as well as other records. The Books API documentation only lists accounts, contacts, and vendors as module options but any integration module should work.

Prerequisites

  • Enable the Books to CRM integration.
  • Create a Deluge script to access the data, or utilize it through the Books API.

Deluge Script

booksOrgId = "**************";
contactId = "**************";
connectionName = "**************";
 
customer = zoho.books.getRecords("Customers", booksOrgId, "zcrm_contact_id=" + contactId, connectionName);

Known Id Options

Crm ModuleBooks ModuleField
AccountsContactszcrm_account_id
ContactsContact Personszcrm_contact_id
VendorsContactszcrm_vendor_id
ProductsItemszcrm_product_id