List of incoming call sessions (ClickHouse)

Same contract as /statistics/cis/incoming/sessions, served from ClickHouse (a two-step read: the page from the company-keyed cis_call_by_company rollup, the late columns from cis_call_aggregated by that page's call ids) instead of Postgres. Since 2026-07-30 the dialog (messages/messagesAsString, from the CallFinished event) and the per-segment durations and main/ai/robot/transfer cost decomposition (from CallUpdated.partsAgg) are served for real, together with the authoritative totalCost and macCallCost/labelCallCost. A call with no conversation (NOANSWER/BUSY/ CONGESTION) returns null for the dialog, and so does a call that has been depersonalized (depersonalized = 1) — the source deletes its replies, so the copy stops serving them too. Dialog data only exists from 2026-07-16 (the raw layer's retention horizon). Still returned as the literal '0', exactly as in the legacy endpoint: mainCallDiscount, robotCallDiscount, transferCallDiscount and the autoCall* family — there is no source for them. When both from and to are set, the date window must not exceed the server cap (CIS_SESSIONS_MAX_WINDOW_DAYS, default 31 days); a wider window returns 400. Note on status and duration: both are DISPLAYED from the freshest data, while the row SELECTION and the duration sort still run on the company-keyed rollup, which lags for ~1.4-2.2% of calls (the final status and duration arrive in a Kafka block that carries no companyId and is therefore dropped there). A row may consequently be shown with a status it was not selected by — including OUTGOING_EXPIRED, which this endpoint otherwise excludes — and a sort=-duration page may look mis-ordered by a few rows. Displayed values are the correct ones.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Query Params
companyIds
array of integers

Array of companies.

companyIds
string
^[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\+[0-9]{2}:[0-9]{2}$

The start date (for example, 2018-05-27T21:30:54+00:00). (For get request need encode url)

string
^[0-9]{4}-[0-9]{2}-[0-9]{2}T[0-9]{2}:[0-9]{2}:[0-9]{2}\+[0-9]{2}:[0-9]{2}$

The end date (for example, 2018-05-27T21:30:54+00:00). (For get request need encode url)

string

Comma-separated list of a record's fields to be fetched. example - callId,startedAt,number,callingNumber,regionName,timezone,duration,totalCost,recordPath,messagesAsString,resultsString,emotion,robotCallDuration,robotCallTotalCost,hungUpBy,gender,nps,isAssistantRequest,markers,externalId,additional,currentStatusName,mainCallCost,mainCallDiscount,mainCallDuration,mainCallTotalCost,aiCallDuration,aiCallTotalCost,aiCallCost,aiCallLlmTotalCost,aiCallTtsTotalCost,aiCallSttTotalCost,autoCallCost,autoCallDiscount,autoCallDuration,autoCallTotalCost,robotCallCost,robotCallDiscount,transferCallCost,transferCallDiscount,transferCallDuration,transferCallTotalCost,transferredToOperator,companyId,allResults,depersonalized

integer
Defaults to 10

Maxium number of returning records.

integer

Starting point to return records from a result set.

integer

Page number, used to paginate over all records.

boolean

Determines whether the zip archive should be returned.

string
enum

Determines the output format. CSV_EXCEL format includes UTF-8 BOM and semicolon delimiter for better Excel compatibility.

Allowed:
string

Base filename (without extension) to be downloaded.

string

UUID call session.

boolean

Return call session list filtred total price > 0.

boolean

Include non-incoming calls (skip the is_incoming = 1 filter).

string

Comma-separated list of fields to sort by. Each sort field can have special prefix indicating a desirable sort order: + (ascending order, default) or - (descending order). The available sort fields: createdAt, updatedAt, startedAt, duration, lastEventAt.

string

Field for filtering by from and to. The available fields: createdAt,updatedAt,startedAt,finishedAt,billedAt. Default - createdAt

boolean

Return links in a new format

Responses

400

Invalid input parameters

401

User is not authenticated

403

Invalid user permissions

Language
Credentials
Bearer
JWT
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json