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 Zoho CRM.

• Bulk create accounts using SQL Server data
• Bulk upsert accounts using SQL Server data
• Create a deal with lookup fields
• Create an account
• Create an account (with output)
• Delete accounts in bulk
• Delete an account
• Read accounts
• Read accounts modified after date
• Read accounts modified after date (filtered)
• Read an account by ID
• Read data using COQL (Native SQL)
• Search accounts by criteria
• Update a lead
• Update a lead (legacy)
• Update deal account or contact
• Update record owner
• Update tags
• Upsert a lead
• Upsert an account