Zoho SalesIQ Connector
Documentation
Version: 2
Documentation
Endpoint

Get Feedbacks

Name

get_feedbacks

Description

No description available

Related Tables

Feedbacks

Parameters

Parameter Label Required Options Description
Ratings Ratings NO
Option Value
happy happy
neutral neutral
sad sad
OperatorIds OperatorIds NO
DepartmentIds DepartmentIds NO
AppIds AppIds NO
StartTime StartTime NO
Option Value
2023-12-31T00:00:00 2023-12-31T00:00:00
now now
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
The date for which to retrieve the report in YYYYMMDD format. Supported functions now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
EndTime EndTime NO
Option Value
2023-12-31T00:00:00 2023-12-31T00:00:00
now now
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
The date for which to retrieve the report in YYYYMMDD format. Supported functions now|today|yesterday|weekstart|weekend|monthstart|monthend|yearstart|yearend and supported intervals for add/subtract are ms|s|sec|min|h|hour|y|year|d|day|m|month|y|year. Example monthstart-3d (subtract 3days from month start)
TimezoneOffset TimezoneOffset NO
VisitorEmail VisitorEmail NO
PageSize PageSize NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
ReferenceId DT_WSTR nvarchar(50) 50 False
Question DT_WSTR nvarchar(4000) 4000 False
CreatedTime DT_DBTIMESTAMP datetime False
AttenderEmail DT_WSTR nvarchar(500) 500 False
RatingType DT_WSTR nvarchar(100) 100 False
RatingValue DT_WSTR nvarchar(100) 100 False
Feedback DT_WSTR nvarchar(1280) 1280 False
VisitorPhone DT_WSTR nvarchar(500) 500 False
VisitorEmail DT_WSTR nvarchar(500) 500 False
VisitorName DT_WSTR nvarchar(500) 500 False
VisitorSupportedOperations DT_WSTR nvarchar(50) 50 False
VisitorIp DT_WSTR nvarchar(500) 500 False
SupportTicketId DT_WSTR nvarchar(100) 100 False
AttenderId DT_WSTR nvarchar(500) 500 False
AttenderDisplayName DT_WSTR nvarchar(500) 500 False
AttenderType DT_WSTR nvarchar(100) 100 False
AttenderImageUrl DT_WSTR nvarchar(1000) 1000 False
NotesAvailable DT_BOOL bit False
ConversationReferenceId DT_WSTR nvarchar(50) 50 False
ConversationMode DT_WSTR nvarchar(50) 50 False
ConversationId DT_WSTR nvarchar(500) 500 False
DepartmentId DT_WSTR nvarchar(500) 500 False
StartTime DT_DBTIMESTAMP datetime False
EndTime DT_DBTIMESTAMP datetime False
If the column you are looking for is missing, consider customizing Zoho SalesIQ Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

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 Destination

This Endpoint belongs to Feedbacks table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Zoho SalesIQ
Feedbacks
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get feedbacks 

SELECT * FROM get_feedbacks

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;

get_feedbacks endpoint belongs to Feedbacks table(s), and can therefore be used via those table(s).

SQL Server

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

Get feedbacks 

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

EXEC (@MyQuery) AT [LS_TO_ZOHO_SALESIQ_IN_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];

get_feedbacks endpoint belongs to Feedbacks table(s), and can therefore be used via those table(s).