{"id":30469,"date":"2021-08-24T12:04:10","date_gmt":"2021-08-24T11:04:10","guid":{"rendered":"https:\/\/multisite.korebots.com\/v9-0\/uncategorised-ja\/data-insert-bulk-api\/"},"modified":"2021-08-24T12:10:06","modified_gmt":"2021-08-24T11:10:06","slug":"data-insert-bulk-api","status":"publish","type":"post","link":"https:\/\/multisite.korebots.com\/v9-0\/uncategorised-ja\/data-insert-bulk-api\/","title":{"rendered":"\u30c7\u30fc\u30bf\u633f\u5165\uff08\u4e00\u62ec\uff09API"},"content":{"rendered":"

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<\/div><\/div>

<\/div><\/div>

<\/span>\u30af\u30a8\u30ea\u30d1\u30e9\u30e1\u30fc\u30bf<\/span><\/h3>\n\n\n\n\n\n\n
\u30d1\u30e9\u30e1\u30fc\u30bf<\/th>\n\u8aac\u660e<\/th>\n<\/tr>\n<\/thead>\n
\u30db\u30b9\u30c8<\/span><\/td>\n\u74b0\u5883URL\uff08\u4f8b\uff09 https:\/\/bots.kore.ai<\/code><\/span><\/td>\n<\/tr>\n
tableName<\/span><\/td>\n\u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u633f\u5165\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u540d\u524d<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>
<\/div><\/div>

<\/span>\u672c\u6587\u30d1\u30e9\u30e1\u30fc\u30bf<\/span><\/h3>\n\n\n\n\n\n
\u30d1\u30e9\u30e1\u30fc\u30bf<\/th>\n\u8aac\u660e<\/th>\n<\/tr>\n<\/thead>\n
\u65e5\u4ed8<\/td>\ncolumn_name: value pairing\u3092\u542b\u3080\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u914d\u5217<\/p>\n
"data": [ { "<col1_name>": "<value1>", "<col2_name>": "<value2>", }, { "<col1_name>": "<value1>", "<col2_name>": "<value2>", } ]<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div><\/div>
<\/div><\/div>
<\/span>\u8a8d\u8a3c<\/span><\/h3>\n
\u4ee5\u4e0b\u306e\u69cb\u6587\u3092\u4f7f\u7528\u3057\u3066\u3001JWT\u3092\u30d8\u30c3\u30c0\u30fc\u306b\u542b\u3080API\u3092\u547c\u3073\u51fa\u3057\u307e\u3059\u3002 auth: {{JWT}}<\/code><\/p>\n<\/div><\/div>
<\/div><\/div>
<\/span>\u5fdc\u7b54\u306e\u30b3\u30f3\u30c6\u30f3\u30c4\u30bf\u30a4\u30d7<\/span><\/h3>\n
application\/json<\/code><\/p>\n<\/div><\/div>
<\/div><\/div>
<\/span>\u30b5\u30f3\u30d7\u30eb\u30ea\u30af\u30a8\u30b9\u30c8<\/span><\/h3>\n
curl -X POST \\ http:\/\/{{host}}\/api\/public\/tables\/{{tableName}} \\ -H 'auth: {{YOUR_JWT_ACCESS_TOKEN}}<\/em>' \\ -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 } ] }'<\/pre>\n<\/div><\/div>
<\/div><\/div>
<\/span>\u30b5\u30f3\u30d7\u30eb\u5fdc\u7b54<\/span><\/h3>\n
{ "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" }, { "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" } ] }<\/pre>\n<\/div><\/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 \u30af\u30a8\u30ea\u30d1\u30e9\u30e1\u30fc\u30bf \u30d1\u30e9\u30e1\u30fc\u30bf \u8aac\u660e \u30db\u30b9\u30c8 \u74b0\u5883URL\uff08\u4f8b\uff09 https:\/\/bots.kore.ai tableName \u5927\u91cf\u306e\u30c7\u30fc\u30bf\u3092\u633f\u5165\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u540d\u524d \u672c\u6587\u30d1\u30e9\u30e1\u30fc\u30bf \u30d1\u30e9\u30e1\u30fc\u30bf \u8aac\u660e \u65e5\u4ed8 column_name: value pairing\u3092\u542b\u3080\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u914d\u5217 "data": [ { "<col1_name>":...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[79],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts\/30469"}],"collection":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/comments?post=30469"}],"version-history":[{"count":3,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts\/30469\/revisions"}],"predecessor-version":[{"id":30675,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/posts\/30469\/revisions\/30675"}],"wp:attachment":[{"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/media?parent=30469"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/categories?post=30469"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/multisite.korebots.com\/v9-0\/wp-json\/wp\/v2\/tags?post=30469"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}