Data Update API

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 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
}