Reference

Table Operators

Description

No description available

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_operators
INSERT
UPDATE
UPSERT
DELETE
LOOKUP

Examples

SSIS

Use Zoho SalesIQ Connector in API Source component to read data or in API Destination component to read/write data:

Read from Operators table using API Source

API Source - Zoho SalesIQ
Read and write Zoho SalesIQ data effortlessly. Integrate, manage, and automate chats and visits — almost no coding required.
Zoho SalesIQ
Operators
Optional Parameters
LastSyncTime
SSIS API Source - Read from table or endpoint

Read/write to Operators table using API Destination

API Destination - Zoho SalesIQ
Read and write Zoho SalesIQ data effortlessly. Integrate, manage, and automate chats and visits — almost no coding required.
Zoho SalesIQ
Operators
Select
Optional Parameters
LastSyncTime
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read operators

<p>Reads all operators (agents) associated with the account. This includes their profile details, availability status, and associated departments.</p> <p>Query the <code>Operators</code> table to manage agent accounts and monitor their current status.</p> 

SELECT * FROM Operators

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Read operators

<p>Reads all operators (agents) associated with the account. This includes their profile details, availability status, and associated departments.</p> <p>Query the <code>Operators</code> table to manage agent accounts and monitor their current status.</p> 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Operators';

EXEC (@MyQuery) AT [LS_TO_ZOHO_SALESIQ_IN_GATEWAY];