SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Zendesk.

• Bulk create tickets using raw JSON
• Bulk create tickets using SQL Server data
• Bulk delete tickets using ID list
• Bulk delete tickets using IDs from SQL Server
• Bulk update tickets using SQL Server data
• Bulk upsert users/organizations using SQL Server data
• Create a ticket
• Create a ticket on behalf of user
• Create a ticket using raw JSON
• Create a user
• Create an organization
• Delete a ticket
• Delete a user
• Delete an organization
• Read a ticket by ID
• Read organizations
• Read organizations (incremental)
• Read organizations by IDs
• Read ticket attachments
• Read tickets
• Read tickets (incremental)
• Read tickets assigned to user
• Read tickets by IDs
• Read tickets CCed to user
• Read tickets count
• Read tickets count for organization
• Read tickets for organization
• Read tickets requested by user
• Read users
• Read users (incremental)
• Read users by IDs
• Search for user by email
• Search records using query
• Update a ticket
• Update a ticket using raw JSON
• Update a user
• Update an organization
• Update ticket tags
• Update ticket with HTML comment
• Update ticket with private comment
• Upsert a user
• Upsert an organization