ODBC guide

Update a ticket using raw JSON

Updates an existing ticket by supplying the raw JSON body. This example demonstrates using the _rawdoc_ column in the UPDATE statement to pass the JSON payload.

UPDATE Tickets
SET _rawdoc_ =
  '{
      "subject": "Test ticket #1",    
      "comment": {
        "body": "Test ticket #1"
      },
      "priority": "urgent"
    }'
WHERE Id=1234