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();