{"id":23933,"date":"2020-07-09T07:34:16","date_gmt":"2020-07-09T06:34:16","guid":{"rendered":"https:\/\/developer.kore.ai\/v10-1\/?p=23933"},"modified":"2023-07-19T14:12:43","modified_gmt":"2023-07-19T13:12:43","slug":"data-insert-bulk-api","status":"publish","type":"post","link":"https:\/\/developer.kore.ai\/v10-1\/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\n\n\n\n\n\n\n
Method<\/b><\/td>\nPOST<\/span><\/td>\n<\/tr>\n
Endpoint<\/b><\/td>\nhttps:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/bulk<\/code><\/td>\n<\/tr>\n
Content Type<\/b><\/td>\napplication\/json<\/code><\/td>\n<\/tr>\n
Authorization<\/b><\/td>\n\n

auth: {{JWT}}<\/code><\/p>\n

See How to generate the JWT Token<\/a>.<\/td>\n<\/tr>\n

App Access<\/b><\/td>\n\n

Write access to the Data Table from the Data Definition in DaaS.<\/p>\n

For more information, see app assignment for accessing the data in a table <\/a> and Data as a Service <\/a> articles.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

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

\r\n\t\t
\r\n\t\t\t

Path Parameters<\/span><\/h2>\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

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

\r\n\t\t
\r\n\t\t\t

Sample Request<\/span><\/h2>\n
curl -X POST \\\r\n  https:\/\/{{host}}\/api\/public\/tables\/{{tableName}}\/bulk \\\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
 <\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t
\r\n\t\t
\r\n\t\t\t
Body Parameters<\/span><\/h2>\n\n\n\n\n\n
Parameter<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
data<\/td>\n\n
Array 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
 <\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n\r\n\t
\r\n\t\t
\r\n\t\t\t
Sample Response<\/span><\/h2>\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    \"_id\": \"27eh4823jh43246jnn2455h34\"\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    \"_id\": \"27eh4823jh43246jnn2455h34\" \r\n   }\r\n]\r\n}<\/pre>\n
 <\/p>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<\/div><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"  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...","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\/v10-1\/wp-json\/wp\/v2\/posts\/23933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/comments?post=23933"}],"version-history":[{"count":13,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/23933\/revisions"}],"predecessor-version":[{"id":57986,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/23933\/revisions\/57986"}],"wp:attachment":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/media?parent=23933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/categories?post=23933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/tags?post=23933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}