1. Home
  2. Docs
  3. Virtual Assistants
  4. API Guide
  5. Data Update API

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
}

 

Menu