Add Rows (Bulk)

1️⃣ Overview

Purpose:
Adds multiple new rows to a workbook within a workspace in a single request.

---

2️⃣ Endpoint

POST /noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk

---

3️⃣ Path Parameters

Parameter	Type	Required	Description
workspaceId	UUID	✅ Yes	Workspace identifier
workbookId	UUID	✅ Yes	Workbook identifier

---

4️⃣ Authentication

Requires authentication using:

Authorization: Bearer <token>

---

5️⃣ Request Headers

Header	Required
Authorization	✅ Yes

---

6️⃣ Request Body Schema

[
  {
    "cellValues": {}
  }
]

---

7️⃣ Field Descriptions

Bulk Row Data

Field	Type	Required	Description
cellValues	object	✅ Yes	Key-value mapping of workbook column internal names to their values

---

8️⃣ Example Request

curl -X POST https://be.datagol.ai/noCo/api/v2/workspaces/{workspaceId}/tables/{workbookId}/rows/bulk \
-H "Authorization: Bearer <token>" \
-H "Content-Type: application/json" \
--data-raw '[{"cellValues":{"first_name":"John","years_of_experience":5,"is_active":true,"start_date":"2024-02-18T05:00:00+00:00"}},{"cellValues":{"first_name":"Jane","years_of_experience":3,"is_active":false,"start_date":"2023-06-01T05:00:00+00:00"}}]'

---

9️⃣ Behavior Summary

Inserts multiple new records into the workbook in a single request.
Supports:
• Top-level array of row objects — not wrapped in a parent object  
• Internal column names must be used as keys  
• Data validation is performed on all rows before insertion  
• Date values must follow YYYY-MM-DD format  
• All rows are inserted atomically.