I have a CSV file stored in the Catalyst Stratus bucket, and I need to perform a bulk write insert operation into a Catalyst Datastore using the data from this CSV file. I am looking for a way to achieve this through a REST API.

I have a CSV file stored in the Catalyst Stratus bucket, and I need to perform a bulk write insert operation into a Catalyst Datastore using the data from this CSV file. I am looking for a way to achieve this through a REST API.

• catalystbyzoho
• zohocatalyst

1 Answer 1

You can use the bulkWrite.createJob() method in the Node.js SDK to perform a bulk write insert operation using a file stored in Stratus. You only need to pass the object details into the bucket. You can refer to the official help documentation here.

Additionally, if you prefer to use the Catalyst REST API, you can pass the object details into the Bulk Write API as shown below.

POST https://api.catalyst.zoho.com/baas/v1/project/<project-id>/bulk/write HTTP/1.1
Content-Type: application/json
Authorization: Zoho-oauthtoken secret_oauth_access_token

{
  "table_identifier": "table_Name",
  "object_details": {
    "bucket_name": "bucket_Name",
    "object_key": "object_path"
  }
}