{"id":23648,"date":"2020-07-03T15:19:17","date_gmt":"2020-07-03T14:19:17","guid":{"rendered":"https:\/\/developer.kore.ai\/v10-1\/?p=23648"},"modified":"2023-07-19T06:57:52","modified_gmt":"2023-07-19T05:57:52","slug":"data-update-api","status":"publish","type":"post","link":"https:\/\/developer.kore.ai\/v10-1\/docs\/bots\/api-guide\/data-update-api\/","title":{"rendered":"Data Update API"},"content":{"rendered":"
\r\n\t
\r\n\t\t
\r\n\t\t\t

  Used to update data into Data Table.<\/p>\n\n\n\n\n\n\n\n
Method<\/b><\/td>\nPUT<\/span><\/td>\n<\/tr>\n
Endpoint<\/b><\/td>\nhttps:\/\/{{host}}\/api\/public\/tables\/{{tableName}}<\/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

Read and 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 update 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 PUT \\\r\n  https:\/\/{{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      \"query\":{\r\n \t\"expressions\": [\r\n        \t{\"field\": \"firstName\", \"operand\": \"=\", \"value\": \"Jane\"},\r\n\t\t{\"field\": \"lastName\", \"operand\": \"=\", \"value\": \"Doe\"}\r\n\t\t],\r\n\t\t\"operator\": \"and\"\r\n\t   },\r\n      \"data\": {\r\n        \"First_Name\": \"Jane\",\r\n        \"Last_Name\": \"Smith\",\r\n        \"Number\": 3453\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\n
Parameter<\/th>\nDescription<\/th>\n<\/tr>\n<\/thead>\n
query<\/td>\n\n
Filter criteria identifying the row to be updated<\/p>\n
\u00a0\"query\":{\r\n\t\"expressions\": [\r\n\t   {\"field\": \"<col1_name>\", \"operand\": \"=\/!=\/<\/>\", \"value\": \"<value1>\"},\r\n\t   {\"field\": \"<col2_name>\", \"operand\": \"=\/!=\/<\/>\", \"value\": \"<value2>\"}\r\n\t],\r\n\t\"operator\": \"and\/or\"\r\n\t   }<\/pre>\n<\/td>\n<\/tr>\n
data<\/td>\n\n
Object with the column_name: value pairing for the columns to be updated<\/p>\n
\"data\": {\r\n        \"<col1_name>\": \"<value1>\",\r\n        \"<col2_name>\": \"<value2>\",\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   \"nModified\": 1\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 update data into Data Table. Method PUT Endpoint https:\/\/{{host}}\/api\/public\/tables\/{{tableName}} Content Type application\/json Authorization auth: {{JWT}} See How to generate the JWT Token. App Access Read and 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...","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-23648","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\/23648","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=23648"}],"version-history":[{"count":9,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/23648\/revisions"}],"predecessor-version":[{"id":57952,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/23648\/revisions\/57952"}],"wp:attachment":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/media?parent=23648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/categories?post=23648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/tags?post=23648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}