Skip to content

Data Insert (Bulk) API

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}}
See How to generate the JWT Token.
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" 
   }
 ]
}