POST Agents/DatabaseTable/UpdateRow

Some tooltip text!

• 1 minute to read

 • 1 minute to read

POST /api/v1/Agents/DatabaseTable/UpdateRow

Update a row in a table

Query String Parameters

Parameter Name	Type	Description
$select	string	Optional comma separated list of properties to include in the result. Other fields are then nulled out to reduce payload size: "Name,department,category". Default = show all fields.

POST /api/v1/Agents/DatabaseTable/UpdateRow?$select=name,department,category/id

Request Headers

Parameter Name	Description
Authorization	Supports 'Basic', 'SoTicket' and 'Bearer' schemes, depending on installation type.
X-XSRF-TOKEN	If not using Authorization header, you must provide XSRF value from cookie or hidden input field
Content-Type	Content-type of the request body: application/json, text/json, application/xml, text/xml, application/x-www-form-urlencoded, application/json-patch+json, application/merge-patch+json
Accept	Content-type(s) you would like the response in:
SO-AppToken	The application token that identifies the partner app. Used when calling Online WebAPI from a server.

Request Body: request

TableName, Id, Values

Property Name	Type	Description
TableName	String
Id	Integer
Values	PersonEntity

Response:

No Content

Response	Description
204	No Content

Response body: TimeZoneData

Sample request

POST /api/v1/Agents/DatabaseTable/UpdateRow
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: *
Content-Type: application/json; charset=utf-8

{
  "TableName": "Rolfson-O'Hara",
  "Id": 604,
  "Values": {
    "Values1": "nam",
    "Values2": "natus"
  }
}

Sample response

HTTP/1.1 204 No Content
Content-Type: application/json; charset=utf-8

null