Updating a single object

Important

This operation updates a single object in the database. To update more than one object, use the bulkUpdate operation documented in the Updating multiple objects chapter of this guide.

To add this operation to a Unit Of Work request, use the following operation in the request payload:

{
  "isolationLevelEnum" : "REPEATABLE_READ" | "READ_COMMITTED" | "READ_UNCOMMITTED" | "SERIALZABLE",
  "operations": [
    {
      "operationType": "UPDATE",
      "table": "TABLENAME",
      "opResultId": "OPRESULT-ID",
      "payload": {

      }
    }
  ]
}

where:

Argument	Description
"operationType"	The value must be "UPDATE", this designates the operation as "updating a single object". The object to update in the database is defined in the "payload" property.
"table"	The value must contain the name of the table where the object will be saved. The table must exist in the database before the transaction is executed.
"opResultId"	This is an optional property. If present, must contain an Id for this operation. An operation Id is a free-form string that must be unique within the transaction. If the result of this operation is to be used as an input in another operation within the same transaction, the Id will be used to reference the result.
"payload"	The value is mandatory. Must contain a JSON object which will be updated in a table identified with the "table" property. The object must have the objectId property with a valid value. The value of the objectId property can be a reference to a result from a previous operation or an explicit value. All other properties in the object will overwrite what's already in the database thus performing the update operation.