ODBC guide

Bulk create tickets using raw JSON

Creates multiple tickets by supplying a JSON array of ticket objects. This example demonstrates using the _rawdoc_ column with the Tickets_Bulk table to insert multiple tickets at once.

INSERT INTO Tickets_Bulk(_rawdoc_) 
VALUES(
  '[
    {
      "subject": "Test ticket #1",    
      "comment": {
        "body": "Test ticket #1"
      },
      "priority": "urgent"
    },
    {
      "subject": "Test ticket #2",    
      "comment": {
        "body": "This is a comment for #2"
      },
      "priority": "normal"
    }
  ]'
)