Limitations

Zoho CRM allows you to import your organization's data into CRM. You can import data(in CSV format) to individual CRM modules.
This API is asynchronous and the result is not available immediately. The result is available only in CSV file format, and compressed into a ZIP file.

CSV File Limits

  • The zip file can have multiple CSV files for one parent and multiple children.
  • The Bulk API does not support any delimiter except for comma, semicolon(;), colon(:), and pipe(|). The system detects the delimiter automatically based on the header in file.
  • You must include all required fields when you create a record. You can optionally include any other field for the module.
  • To associate a lookup field's value, the column header in the CSV file should be field_api_name.parent_field_api_name
    For example, if you have an Account Name lookup field, which refers to an account record in the Contacts module, and you have an Account record's ID value in your file, the column header would be Account_Name.id.

  • If you have an Account's Name in your file, then the header should be Account_Name.Account_Name. Here, the first Account_Name is the API name of the field 'Account Name' in the Contacts module and the second Account_Name is the API name of the field 'Account Name' in the Accounts module.
    The CSV file will have data as follows.

    Last_NamePhoneAccount_Name.id
    Kennedy000-00-00012345678
  • A CSV file can contain a maximum of 25000 records with 200 column headers. A file with records above this limit is considered as an improper file and leads to an error.
  • The details of the parent must be the first object in the "resource" array.
  • Each module can be mapped with only one CSV file.
  • For subforms and line items, the CSV file can contain a maximum of 200 rows(records). You can map any system-defined and custom fields.
  • For multi-select lookup, the maximum number of records(in the linking module)in the CSV is 100, while for multi-user lookup, the maximum allowed records is 10. You can only map the lookup fields in the linking module.
  • The size of the child CSV must be a maximum of 25MB.
  • For subforms - The CSV must contain the column header Parent_Id that holds the record IDs of the parent record of the subform.

Limits of Bulk Write APIs

  • You can upload only one zipped CSV file per bulk write request.
  • This API does not support Attachments, Notes, Events, Calls, upload file(fields), and record images.
  • The following fields are not supported for bulk write operation:
    • General fields - File Upload, Image Upload, Created By, Modified By, Created Time, Modified Time, Formula Fields, Auto Number, Campaigns integration.
    • Module-specific fields - Leads - Last Activity Time
      Deals - Lead Conversion Time,Overall Sales Duration, Forecast Category, Sales Cycle Duration
  • This API does not support workflows.
  • The number of bulk write jobs that you can initiate is based on the Zoho CRM edition and remaining credit limits on that day.
  • A single bulk write job will decrease 500 credits from the daily limit irrespective of its state.