Reference

Endpoint Get Feedbacks

Name

get_feedbacks

Description

No description available

Related Tables

Feedbacks

Parameters

Parameter Required Options
Name: Ratings

Label: Ratings
Option Value
happy happy
neutral neutral
sad sad
Name: OperatorIds

Label: OperatorIds
Name: DepartmentIds

Label: DepartmentIds
Name: AppIds

Label: AppIds
Name: StartTime

Label: StartTime

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)
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
Name: EndTime

Label: EndTime

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)
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
Name: TimezoneOffset

Label: TimezoneOffset
Name: VisitorEmail

Label: VisitorEmail
Name: PageSize

Label: PageSize

Output Columns

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

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Feedbacks table, therefore it is better to use it, instead of accessing the endpoint directly:

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
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Feedbacks table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get feedbacks:

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
SSIS API Destination - Access table operation

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;

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 (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).