GuardianCallsQuality
Query call quality metrics from the previous 30 days via the Guardian API.
Select
The connector uses the Talkdesk API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the connector.
| Column | Supported Operators |
| CallId | =, IN, IS, IS_NOT |
| UserId | =, IN, IS, IS_NOT |
| InteractionId | =, IN, IS, IS_NOT |
| Timestamp | =, IS, IS_NOT |
| AffectedCall | =, IN, IS, IS_NOT |
| PacketsLossPercentage | all standard comparison operators |
For example, the following query is processed server-side:
SELECT * FROM GuardianCallsQuality WHERE CallId = 'value'
The connector pushes the ORDER BY clause to the Talkdesk API for the following columns. Sorting on any other column is performed client-side within the connector.
- Timestamp supports the following sort directions: ASC, DESC.
For example, the following query is sorted server-side:
SELECT * FROM GuardianCallsQuality ORDER BY Timestamp ASC
Columns
| Name | Type | References | Description |
| CallId [KEY] | String | The unique identifier of the call. | |
| UserId | String |
Users.Id | The identifier of the user. |
| InteractionId | String |
CallsReport.InteractionId | The unique identifier of the interaction. |
| Timestamp | Datetime | The timestamp of the call. | |
| AffectedCall | Boolean | Whether the call was affected by quality issues. | |
| PacketsLossPercentage | Double | The percentage of packets lost during the call. | |
| JitterAvg | Double | The average jitter during the call. | |
| JitterMax | Double | The maximum jitter during the call. | |
| MosAvg | Double | The average Mean Opinion Score (MOS) during the call. | |
| MosMax | Double | The maximum Mean Opinion Score (MOS) during the call. | |
| MosMin | Double | The minimum Mean Opinion Score (MOS) during the call. | |
| RttAvg | Double | The average round-trip time (RTT) in ms. | |
| RttMax | Double | The maximum round-trip time (RTT) in ms. | |
| RttMin | Double | The minimum round-trip time (RTT) in ms. |