DirectRoutingCalls
Displays direct routing call records in Microsoft Teams for telephony integration analysis.
Table Specific Information
Select
Custom App and Client Credentials should be used. See Creating an Entra ID (Azure AD) Application The connector will use the Microsoft Teams API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- FromDate supports '=' operator.
- ToDate supports '=' operator.
Following is an example query:
SELECT * FROM DirectRoutingCalls WHERE FromDate = '2021-01-01' SELECT * FROM DirectRoutingCalls WHERE FromDate = '2021-01-01' AND ToDate = '2021-02-09'
Note: FromDate and ToDate are required parameters , if they are not specified default dates will be taken with a date range of 90 days.
Columns
| Name | Type | Description |
| Id | String | Unique identifier for the direct routing call in Microsoft Teams. |
| CorrelationId | String | Correlation identifier used to track related call and session data. |
| UserId | String | Unique identifier of the user associated with the call. |
| UserPrincipalName | String | User Principal Name (UPN) of the user who participated in the call. |
| UserDisplayName | String | Display name of the user who participated in the call. |
| StartDateTime | Edm.DateTimeOffset | Timestamp indicating when the call started. |
| InviteDateTime | Edm.DateTimeOffset | Timestamp indicating when the call invitation was sent. |
| FailureDateTime | Edm.DateTimeOffset | Timestamp indicating when the call failed, if applicable. |
| EndDateTime | Edm.DateTimeOffset | Timestamp indicating when the call ended. |
| Duration | Integer | Duration of the call in seconds. |
| CallType | String | Type of call, such as inbound or outbound. |
| SuccessfulCall | String | Indicates whether the call was successfully completed. |
| CallerNumber | String | Phone number of the caller. |
| CalleeNumber | String | Phone number of the callee. |
| MediaPathLocation | String | Location of the media path used during the call. |
| SignalingLocation | String | Location of the signaling server handling the call. |
| FinalSipCode | Integer | Final SIP (Session Initiation Protocol) response code for the call. |
| CallEndSubReason | Integer | Detailed subreason code explaining why the call ended. |
| FinalSipCodePhrase | String | Description of the final SIP code. |
| MediaBypassEnabled | Boolean | Indicates whether Media Bypass was enabled for the call. |
| FromDate | Edm.Date | Start date for filtering calls to retrieve. |
| ToDate | Edm.Date | End date for filtering calls to retrieve. |