Power BI Connector for Microsoft Teams

Build 23.0.8839

DirectRoutingCalls

Retrieves a list of direct routing calls

Table Specific Information

Select

Custom App and Client Credentials should be used. See Creating a Custom OAuth 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 The Id of the Direct routing call
CorrelationId String The Correlation ID
UserId String The Id of the user
UserPrincipalName String The principal name of the user
UserDisplayName String The display name of the user
StartDateTime Edm.DateTimeOffset The start date time of the call
InviteDateTime Edm.DateTimeOffset The invite date time
FailureDateTime Edm.DateTimeOffset The failure date time
EndDateTime Edm.DateTimeOffset The end date time of the call
Duration Integer The duration of the call
CallType String The type of the call
SuccessfulCall String The successful call
CallerNumber String The caller number
CalleeNumber String The callee number
MediaPathLocation String The media path location
SignalingLocation String The signaling location
FinalSipCode Integer The final SIP Code
CallEndSubReason Integer The sub reason of the call end
FinalSipCodePhrase String The final SIP code phrase
MediaBypassEnabled Boolean Whether Media Bypass is enabled or not
FromDate Edm.Date The date from which calls to be fetched
ToDate Edm.Date the date till when calls to be fetched

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839