{"id":23933,"date":"2020-07-09T07:34:16","date_gmt":"2020-07-09T06:34:16","guid":{"rendered":"https:\/\/developer.kore.ai\/v8-0\/?p=23933"},"modified":"2021-03-25T12:32:55","modified_gmt":"2021-03-25T12:32:55","slug":"data-insert-bulk-api","status":"publish","type":"post","link":"https:\/\/developer.kore.ai\/v8-0\/docs\/bots\/api-guide\/data-insert-bulk-api\/","title":{"rendered":"Data Insert (Bulk) API"},"content":{"rendered":"
\r\n\t
\r\n\t\t
\r\n\t\t\t

Used to insert bulk data into Data Table.<\/p>\n

To use this API, the app needs to be given Write access to the Data Table from the Data Definition in DaaS (see here for details<\/a>)<\/p>\n

POST<\/b> https:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/bulk<\/code><\/span><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n

<\/div><\/div>\r\n\t
\r\n\t\t
\r\n\t\t\t

Query Parameters<\/span><\/h3>\n\n\n\n\n\n\n
Parameter<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
host<\/span><\/td>\nEnvironment URL, for example, https:\/\/bots.kore.ai<\/code><\/span><\/td>\n<\/tr>\n
tableName<\/span><\/td>\nName of the table to insert bulk data<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n
<\/div><\/div>\r\n\t
\r\n\t\t
\r\n\t\t\t

Body Parameters<\/span><\/h3>\n\n\n\n\n\n
Parameter<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
data<\/td>\nArray of objects with the column_name: value pairing<\/p>\n
\"data\": [\r\n    {\r\n        \"<col1_name>\": \"<value1>\",\r\n        \"<col2_name>\": \"<value2>\",\r\n      },\r\n     { \r\n         \"<col1_name>\": \"<value1>\", \r\n         \"<col2_name>\": \"<value2>\", \r\n      }\r\n   ]<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n
<\/div><\/div>\r\n\t
\r\n\t\t
\r\n\t\t\t
Authorization<\/span><\/h3>\n
Invoke the API with JWT in the header with the following syntax:<\/p>\n
auth: {{JWT}}<\/code><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n
<\/div><\/div>\r\n\t
\r\n\t\t
\r\n\t\t\t
Response content type<\/span><\/h3>\n
application\/json<\/code><\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n
<\/div><\/div>\r\n\t
\r\n\t\t
\r\n\t\t\t
Sample Request<\/span><\/h3>\n
curl -X POST \\\r\n  http:\/\/{{host}}\/api\/public\/tables\/{{tableName}} \\\r\n  -H 'auth: {{YOUR_JWT_ACCESS_TOKEN}}<\/em>' \\\r\n  -H 'content-type: application\/json' \\\r\n  -d '{\r\n      \"data\": [\r\n         {\r\n          \"First_Name\": \"Jane\",\r\n          \"Last_Name\": \"Smith\",\r\n          \"Gender\": \"female\",\r\n          \"Number\": 263\r\n         },\r\n         { \r\n           \"First_Name\": \"Mike\", \r\n           \"Last_Name\": \"Mike\", \r\n           \"Gender\": \"male\", \r\n           \"Number\": 234 \r\n         }\r\n       ]\r\n     }'<\/pre>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n
<\/div><\/div>\r\n\t
\r\n\t\t
\r\n\t\t\t
Sample Response<\/span><\/h3>\n
{\r\n\"records\": [\r\n  {\r\n    \"First_Name\": \"Jane\",\r\n    \"Last_Name\": \"Smith\",\r\n    \"Gender\": \"female\",\r\n    \"Number\": 263,\r\n    \"Updated_On\": \"2020-03-28T07:02:09.652Z\",\r\n    \"Created_On\": \"2020-03-28T07:02:09.652Z\",\r\n    \"Updated_By\": \"st-98e05480-0257-5e35-b6d2-66a323834f9d\",\r\n    \"Created_By\": \"st-98e05480-0257-5e35-b6d2-66a323834f9d\",\r\n    \"sys_Id\": \"sys-545dae21-8675-5a95-9c1b-a223bc6f4bc8\"\r\n  },\r\n  { \"First_Name\": \"Mike\", \r\n    \"Last_Name\": \"Mike\", \r\n    \"Gender\": \"male\", \r\n    \"Number\": 234, \r\n    \"Updated_On\": \"2020-03-28T07:02:09.652Z\", \r\n    \"Created_On\": \"2020-03-28T07:02:09.652Z\", \r\n    \"Updated_By\": \"st-98e05480-0257-5e35-b6d2-66a323834f9d\", \r\n    \"Created_By\": \"st-98e05480-0257-5e35-b6d2-66a323834f9d\", \r\n    \"sys_Id\": \"sys-545dae21-8675-5a95-9c1b-a223bc6f4bc8\" \r\n   }\r\n]\r\n}<\/pre>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n
<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"Used to insert bulk data into Data Table. To use this API, the app needs to be given Write access to the Data Table from the Data Definition in DaaS (see here for details) POST https:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/bulk Query Parameters Parameter Description host Environment URL, for example, https:\/\/bots.kore.ai tableName Name of the table to insert bulk data...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-23933","post","type-post","status-publish","format-standard","hentry","category-api-guide"],"_links":{"self":[{"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/posts\/23933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/comments?post=23933"}],"version-history":[{"count":4,"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/posts\/23933\/revisions"}],"predecessor-version":[{"id":26895,"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/posts\/23933\/revisions\/26895"}],"wp:attachment":[{"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/media?parent=23933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/categories?post=23933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developer.kore.ai\/v8-0\/wp-json\/wp\/v2\/tags?post=23933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}