PstnCalls
Displays Public Switched Telephone Network (PSTN) call records in Microsoft Teams.
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 PstnCalls WHERE FromDate = '2021-01-01' SELECT * FROM PstnCalls 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 PSTN (Public Switched Telephone Network) call record. |
| CallId | String | Identifier for the specific call within Microsoft Teams. |
| UserId | String | Unique identifier of the user associated with the call. |
| UserPrincipalName | String | User Principal Name (UPN) of the user who made or received the call. |
| UserDisplayName | String | Display name of the user involved in the call. |
| StartDateTime | Edm.DateTimeOffset | Timestamp indicating when the PSTN call started. |
| EndDateTime | Edm.DateTimeOffset | Timestamp indicating when the PSTN call ended. |
| Duration | Integer | Total duration of the call in seconds. |
| Charge | Edm.Double | Monetary charge for the PSTN call. |
| CallType | String | Type of call, such as inbound or outbound. |
| Currency | String | Currency in which the charge is calculated. |
| CallerNumber | String | Phone number of the caller. |
| CalleeNumber | String | Phone number of the callee. |
| UsageCountryCode | String | Country code representing where the PSTN usage occurred. |
| TenantCountryCode | String | Country code for the Microsoft 365 tenant associated with the call. |
| ConnectionCharge | Edm.Double | One-time connection charge for the PSTN call. |
| DestinationName | String | Name of the call destination, such as a city or region. |
| ConferenceId | String | Identifier for the conference when the call is part of a conference session. |
| LicenseCapability | String | License capability of the user at the time of the call. |
| InventoryType | String | Type of inventory resource used for the call, such as service numbers or user numbers. |
| FromDate | Edm.Date | Start date for filtering PSTN call records to retrieve. |
| ToDate | Edm.Date | End date for filtering PSTN call records to retrieve. |