Reference

Table Feedbacks

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_feedbacks
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 Feedbacks 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

Feedbacks

Optional Parameters
Ratings
OperatorIds
DepartmentIds
AppIds
StartTime
EndTime
TimezoneOffset
VisitorEmail

SSIS API Source - Read from table or endpoint

Read/write to Feedbacks 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

Feedbacks

Select

Optional Parameters
Ratings
OperatorIds
DepartmentIds
AppIds
StartTime
EndTime
TimezoneOffset
VisitorEmail

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read feedbacks

Reads visitor feedback and ratings submitted after chat sessions. This data helps in evaluating operator performance and customer satisfaction. The <code>Feedbacks</code> table contains ratings and comments provided by visitors.

SELECT * FROM Feedbacks

Read feedbacks with manual pagination

Reads feedback records in batches to overcome API pagination limits. This example demonstrates how to retrieve data month-by-month and combine the results using <code>UNION</code> to get a complete dataset for a longer period. This approach is necessary when the total number of records exceeds the API's single-request limit, ensuring all data is captured by iterating through date ranges.

SELECT * INTO #t1 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-01-01', EndTime='2023-02-01');
SELECT * INTO #t2 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-02-01', EndTime='2023-03-01');
SELECT * INTO #t3 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-03-01', EndTime='2023-04-01');
SELECT * INTO #t4 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-04-01', EndTime='2023-05-01');
SELECT * INTO #t5 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-05-01', EndTime='2023-06-01');
SELECT * INTO #t6 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-06-01', EndTime='2023-07-01');
SELECT * INTO #t7 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-07-01', EndTime='2023-08-01');
SELECT * INTO #t8 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-08-01', EndTime='2023-09-01');
SELECT * INTO #t9 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-09-01', EndTime='2023-10-01');
SELECT * INTO #t10 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-10-01', EndTime='2023-11-01');
SELECT * INTO #t11 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-11-01', EndTime='2023-12-01');
SELECT * INTO #t12 FROM Feedbacks WITH(OperatorIds='81565000003048017', StartTime='2023-12-01', EndTime='2024-01-01');

SELECT * FROM #t1 UNION 
SELECT * FROM #t2 UNION 
SELECT * FROM #t3 UNION 
SELECT * FROM #t4 UNION 
SELECT * FROM #t5 UNION 
SELECT * FROM #t6 UNION 
SELECT * FROM #t7 UNION 
SELECT * FROM #t8 UNION 
SELECT * FROM #t9 UNION 
SELECT * FROM #t10 UNION 
SELECT * FROM #t11 UNION 
SELECT * FROM #t12;

SQL Server

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

Read feedbacks

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

EXEC (@MyQuery) AT [LS_TO_ZOHO_SALESIQ_IN_GATEWAY];

Read feedbacks with manual pagination

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * INTO #t1 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-01-01'', EndTime=''2023-02-01'');
SELECT * INTO #t2 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-02-01'', EndTime=''2023-03-01'');
SELECT * INTO #t3 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-03-01'', EndTime=''2023-04-01'');
SELECT * INTO #t4 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-04-01'', EndTime=''2023-05-01'');
SELECT * INTO #t5 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-05-01'', EndTime=''2023-06-01'');
SELECT * INTO #t6 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-06-01'', EndTime=''2023-07-01'');
SELECT * INTO #t7 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-07-01'', EndTime=''2023-08-01'');
SELECT * INTO #t8 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-08-01'', EndTime=''2023-09-01'');
SELECT * INTO #t9 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-09-01'', EndTime=''2023-10-01'');
SELECT * INTO #t10 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-10-01'', EndTime=''2023-11-01'');
SELECT * INTO #t11 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-11-01'', EndTime=''2023-12-01'');
SELECT * INTO #t12 FROM Feedbacks WITH(OperatorIds=''81565000003048017'', StartTime=''2023-12-01'', EndTime=''2024-01-01'');

SELECT * FROM #t1 UNION 
SELECT * FROM #t2 UNION 
SELECT * FROM #t3 UNION 
SELECT * FROM #t4 UNION 
SELECT * FROM #t5 UNION 
SELECT * FROM #t6 UNION 
SELECT * FROM #t7 UNION 
SELECT * FROM #t8 UNION 
SELECT * FROM #t9 UNION 
SELECT * FROM #t10 UNION 
SELECT * FROM #t11 UNION 
SELECT * FROM #t12;';

EXEC (@MyQuery) AT [LS_TO_ZOHO_SALESIQ_IN_GATEWAY];