Table Feedbacks
Description
No description available
Parameters
Parameter | Label | Required | Options | Description | Help | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are no parameters |
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

Read/write to Feedbacks table using API Destination

ODBC application
Use these SQL queries in your ODBC application data source:
Get Feedbacks (i.e. ratings)
List all feedbacks (ratings)
SELECT * FROM Feedbacks
Get Feedbacks (more than 99 rows)
Get Feedbacks (more than 99 rows). Pagination is not supported so this example shows how to workaround this issue to fetch more rows (assuming each month has less than 99 rows).
SELECT * into #t1 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-01-01', EndTime='2023-02-01');
SELECT * into #t2 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-02-01', EndTime='2023-03-01');
SELECT * into #t3 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-03-01', EndTime='2023-04-01');
SELECT * into #t4 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-04-01', EndTime='2023-05-01');
SELECT * into #t5 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-05-01', EndTime='2023-06-01');
SELECT * into #t6 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-06-01', EndTime='2023-07-01');
SELECT * into #t7 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-07-01', EndTime='2023-08-01');
SELECT * into #t8 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-08-01', EndTime='2023-09-01');
SELECT * into #t9 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-09-01', EndTime='2023-10-01');
SELECT * into #t10 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-10-01', EndTime='2023-11-01');
SELECT * into #t11 FROM Feedbacks WITH(OperatorId='81565000003048017', StartTime='2023-11-01', EndTime='2023-12-01');
SELECT * into #t12 FROM Feedbacks WITH(OperatorId='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:
Get Feedbacks (i.e. ratings)
List all feedbacks (ratings)
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Feedbacks';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_ZOHO_SALESIQ_IN_DATA_GATEWAY];
Get Feedbacks (more than 99 rows)
Get Feedbacks (more than 99 rows). Pagination is not supported so this example shows how to workaround this issue to fetch more rows (assuming each month has less than 99 rows).
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * into #t1 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-01-01'', EndTime=''2023-02-01'');
SELECT * into #t2 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-02-01'', EndTime=''2023-03-01'');
SELECT * into #t3 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-03-01'', EndTime=''2023-04-01'');
SELECT * into #t4 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-04-01'', EndTime=''2023-05-01'');
SELECT * into #t5 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-05-01'', EndTime=''2023-06-01'');
SELECT * into #t6 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-06-01'', EndTime=''2023-07-01'');
SELECT * into #t7 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-07-01'', EndTime=''2023-08-01'');
SELECT * into #t8 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-08-01'', EndTime=''2023-09-01'');
SELECT * into #t9 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-09-01'', EndTime=''2023-10-01'');
SELECT * into #t10 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-10-01'', EndTime=''2023-11-01'');
SELECT * into #t11 FROM Feedbacks WITH(OperatorId=''81565000003048017'', StartTime=''2023-11-01'', EndTime=''2023-12-01'');
SELECT * into #t12 FROM Feedbacks WITH(OperatorId=''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 [LINKED_SERVER_TO_ZOHO_SALESIQ_IN_DATA_GATEWAY];