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
}