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
Zoho SalesIQ Connector can be used to integrate Zoho SalesIQ API in your App / BI Tools. You can exchange data on Chats, Visits and more.
Zoho SalesIQ
Feedbacks
| Optional Parameters | |
|---|---|
| Ratings | |
| OperatorIds | |
| DepartmentIds | |
| AppIds | |
| StartTime | |
| EndTime | |
| TimezoneOffset | |
| VisitorEmail | |
Read/write to Feedbacks table using API Destination
API Destination - Zoho SalesIQ
Zoho SalesIQ Connector can be used to integrate Zoho SalesIQ API in your App / BI Tools. You can exchange data on Chats, Visits and more.
Zoho SalesIQ
Feedbacks
Select
| Optional Parameters | |
|---|---|
| Ratings | |
| OperatorIds | |
| DepartmentIds | |
| AppIds | |
| StartTime | |
| EndTime | |
| TimezoneOffset | |
| VisitorEmail | |
ODBC application
Use these SQL queries in your ODBC application data source:
Get Feedbacks (i.e. ratings)
List all feedbacks (ratings)
SELECT * FROM FeedbacksGet 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 [LS_TO_ZOHO_SALESIQ_IN_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 [LS_TO_ZOHO_SALESIQ_IN_GATEWAY];