Download Bulk Write Result

Purpose

To download the result of the bulk write job as a CSV file.

Download URL

Use the URL present in the download_url parameter in the response of Get Bulk Write Job Details.
The file would be in .zip format. Extract it to get the CSV file. The filename would be in modulename-filename format. Example: Deals-bulkwrite.

The CSV file will contain the first three mapped columns from the uploaded file, and three more columns — ID, Status, and Errors.

  • STATUS - This column indicates if the record is added, skipped, updated, or unprocessed.

  • RECORD_ID - This column indicates the added/updated record ID in Zoho CRM.

  • ERRORS - This column contains the error code. The format is

    • <errorCode>-<column_header> for a single error. Example: MANDATORY_NOT_FOUND-Company

    • <errorCode>-<column_header>:<errorCode>-<column_header> for multiple errors. Example: MANDATORY_NOT_FOUND-Company,Last_Name:DUPLICATE_DATA-Email

    The possible errors are MANDATORY_NOT_FOUND, INVALID_DATA, DUPLICATE_DATA, NOT_APPROVED, BLOCKED_RECORD, CANNOT_PROCESS, LIMIT_EXCEEDED, and RESOURCE_NOT_FOUND

Sample Result

Sample Request

CopiedZCRMBulkWrite writeIns = ZCRMBulkWrite.GetInstance();// To get ZCRMBulkWrite instance
FileAPIResponse respone = writeIns.DownloadBulkWriteResult("https://download-accl.zoho.com/v2/crm/573045/bulk-write/300002357002/300002357002.zip");// Download bulk write result
Stream file = respone.GetFileAsStream();// To get file stream.
CommonUtil.SaveStreamAsFile("/Users/Desktop/", file, respone.GetFileName());//To download stream as zip.
file.Close();