Endpoint Get Conversations

Name

get_conversations

Description

No description available

Related Tables

Conversations

Parameters

Output Columns

Input Columns

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 Conversations table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Zoho SalesIQ

Read and write Zoho SalesIQ data effortlessly. Integrate, manage, and automate chats and visits — almost no coding required.

Zoho SalesIQ

Conversations

Optional Parameters
Status
OperatorIds
DepartmentId
AppId
Email
StartTime
EndTime
VisitorType
UpdatedTimeStart
UpdatedTimeEnd
SortBy

API Destination

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

API Destination - Zoho SalesIQ

Read and write Zoho SalesIQ data effortlessly. Integrate, manage, and automate chats and visits — almost no coding required.

Zoho SalesIQ

Conversations

Select

Optional Parameters
Status
OperatorIds
DepartmentId
AppId
Email
StartTime
EndTime
VisitorType
UpdatedTimeStart
UpdatedTimeEnd
SortBy

ODBC application

Use these SQL queries in your ODBC application data source:

Read conversations

<p>Reads all chat conversations between visitors and operators. This includes message content, timestamps, and visitor details for auditing and analysis.</p> <p>Use the <code>Conversations</code> table to retrieve full chat transcripts and session metadata.</p>

SELECT * FROM Conversations

Read feedback summary by operator

<p>Reads a summary of feedback ratings grouped by operator for the previous year. This aggregation is useful for performance reviews and identifying top-performing agents.</p> <p>This query aggregates data from the <code>Conversations</code> table, grouping by <code>OwnerEmail</code> and <code>RatingString</code> to provide a count of each rating type per operator.</p>

SELECT
 OwnerEmail,
 OwnerId, 
 RatingString,
 COUNT(Id) Total
FROM Conversations
GROUP BY OwnerEmail, OwnerId, RatingString
ORDER BY OwnerEmail, RatingString
WITH(
    --OperatorIds='81565000003048017,81565000002408043' --You can supply Operator Ids to filter result for those Operators only
    StartTime='yearstart-1y'
  , EndTime='yearstart-1d'
)

SQL Server

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

Read conversations

<p>Reads all chat conversations between visitors and operators. This includes message content, timestamps, and visitor details for auditing and analysis.</p> <p>Use the <code>Conversations</code> table to retrieve full chat transcripts and session metadata.</p>

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

EXEC (@MyQuery) AT [LS_TO_ZOHO_SALESIQ_IN_GATEWAY];

Read feedback summary by operator

<p>Reads a summary of feedback ratings grouped by operator for the previous year. This aggregation is useful for performance reviews and identifying top-performing agents.</p> <p>This query aggregates data from the <code>Conversations</code> table, grouping by <code>OwnerEmail</code> and <code>RatingString</code> to provide a count of each rating type per operator.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT
 OwnerEmail,
 OwnerId, 
 RatingString,
 COUNT(Id) Total
FROM Conversations
GROUP BY OwnerEmail, OwnerId, RatingString
ORDER BY OwnerEmail, RatingString
WITH(
    --OperatorIds=''81565000003048017,81565000002408043'' --You can supply Operator Ids to filter result for those Operators only
    StartTime=''yearstart-1y''
  , EndTime=''yearstart-1d''
)';

EXEC (@MyQuery) AT [LS_TO_ZOHO_SALESIQ_IN_GATEWAY];