Zoho SalesIQ Connector
Documentation
Version: 1
Documentation

EndPoint


Name

get_feedbacks

Description

No description available

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

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.