Used to insert bulk data into Data Table.
| Method | POST |
| Endpoint | https://{{host}}/api/public/tables/{{tableName}}/bulk |
| Content Type | application/json |
| Authorization | auth: {{JWT}}
|
| App Access | Write access to the Data Table from the Data Definition in DaaS.
For more information, see app assignment for accessing the data in a table and Data as a Service articles. |
Path Parameters
| Parameter | Description |
|---|---|
| host | Environment URL, for example, https://bots.kore.ai |
| tableName | Name of the table to insert bulk data |
Sample Request
curl -X POST \
https://{{host}}/api/public/tables/{{tableName}}/bulk \
-H 'auth: {{YOUR_JWT_ACCESS_TOKEN}}' \
-H 'content-type: application/json' \
-d '{
"data": [
{
"First_Name": "Jane",
"Last_Name": "Smith",
"Gender": "female",
"Number": 263
},
{
"First_Name": "Mike",
"Last_Name": "Mike",
"Gender": "male",
"Number": 234
}
]
}'
Body Parameters
| Parameter | Description |
|---|---|
| data | Array of objects with the column_name: value pairing
"data": [
{
"<col1_name>": "<value1>",
"<col2_name>": "<value2>",
},
{
"<col1_name>": "<value1>",
"<col2_name>": "<value2>",
}
]
|
Note: The maximum payload size is 50 MB. One way to ensure that the payload size is within the permitted limit is to paste the entire payload in a JSON file and check its size before running the API.
Sample Response
{
"records": [
{
"First_Name": "Jane",
"Last_Name": "Smith",
"Gender": "female",
"Number": 263,
"Updated_On": "2020-03-28T07:02:09.652Z",
"Created_On": "2020-03-28T07:02:09.652Z",
"Updated_By": "st-98e05480-0257-5e35-b6d2-66a323834f9d",
"Created_By": "st-98e05480-0257-5e35-b6d2-66a323834f9d",
"sys_Id": "sys-545dae21-8675-5a95-9c1b-a223bc6f4bc8",
"_id": "27eh4823jh43246jnn2455h34"
},
{ "First_Name": "Mike",
"Last_Name": "Mike",
"Gender": "male",
"Number": 234,
"Updated_On": "2020-03-28T07:02:09.652Z",
"Created_On": "2020-03-28T07:02:09.652Z",
"Updated_By": "st-98e05480-0257-5e35-b6d2-66a323834f9d",
"Created_By": "st-98e05480-0257-5e35-b6d2-66a323834f9d",
"sys_Id": "sys-545dae21-8675-5a95-9c1b-a223bc6f4bc8",
"_id": "27eh4823jh43246jnn2455h34"
}
]
}