Used to update data into Data Table.
Method | PUT |
Endpoint | https://{{host}}/api/public/tables/{{tableName}} |
Content Type | application/json |
Authorization |
|
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 Data as a Service articles. |
Path Parameters
Parameter | Description |
---|---|
host | Environment URL, for example, https://bots.kore.ai |
tableName | Name of the table to update data |
Sample Request
curl -X PUT \ https://{{host}}/api/public/tables/{{tableName}} \ -H 'auth: {{YOUR_JWT_ACCESS_TOKEN}}' \ -H 'content-type: application/json' \ -d '{ "query":{ "expressions": [ {"field": "firstName", "operand": "=", "value": "Jane"}, {"field": "lastName", "operand": "=", "value": "Doe"} ], "operator": "and" }, "data": { "First_Name": "Jane", "Last_Name": "Smith", "Number": 3453 } }'
Body Parameters
Parameter | Description |
---|---|
query |
Filter criteria identifying the row to be updated  "query":{ "expressions": [ {"field": "<col1_name>", "operand": "=/!=/</>", "value": "<value1>"}, {"field": "<col2_name>", "operand": "=/!=/</>", "value": "<value2>"} ], "operator": "and/or" } |
data |
Object with the column_name: value pairing for the columns to be updated "data": { "<col1_name>": "<value1>", "<col2_name>": "<value2>", } |
Sample Response
{ "nModified": 1 }