Data Insert API

Back to API List

Used to insert data into a Data Table.

Property	Value
Method	POST
Endpoint	https://{{host}}/api/public/tables/{{tableName}}
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.

Path Parameters

Parameter	Description
host	Environment URL, for example, https://platform.kore.ai
tableName	Name of the table to insert data into

Sample Request

curl -X POST \
  https://{{host}}/api/public/tables/{{tableName}} \
  -H 'auth: {{YOUR_JWT_ACCESS_TOKEN}}' \
  -H 'content-type: application/json' \
  -d '{
      "data": {
        "First_Name": "test",
        "Last_Name": "name",
        "Gender": "female",
        "Number": 263
       }
     }'

Body Parameters

Parameter	Description
data	Object with column_name/value pairs: "data": { "<col1_name>": "<value1>", "<col2_name>": "<value2>" }

Sample Response

{
    "First_Name": "test",
    "Last_Name": "name",
    "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-66a3238xxxxx",
    "Created_By": "st-98e05480-0257-5e35-b6d2-66a3238xxxxx",
    "sys_Id": "sys-545dae21-8675-5a95-9c1b-a223bc6xxxxx",
    "_id": "23n473m816309s62937xxxxx"
}