PstnCalls
Retrieves a list of PSTN Calls
Table Specific Information
Select
Custom App and Client Credentials should be used. See Creating an 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 | The Id of of the PSTN Call |
| CallId | String | The Id of the Call |
| 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 datetime of the call when it was started |
| EndDateTime | Edm.DateTimeOffset | The datetime of the call when it was ended |
| Duration | Integer | The call duration |
| Charge | Edm.Double | The charge |
| CallType | String | The type of the call |
| Currency | String | Currency |
| CallerNumber | String | The number of the caller |
| CalleeNumber | String | The number of the callee |
| UsageCountryCode | String | The usage country code |
| TenantCountryCode | String | The tenant country code |
| ConnectionCharge | Edm.Double | The connection charge |
| DestinationName | String | The destination name |
| ConferenceId | String | The Id of the conference |
| LicenseCapability | String | The License Capability |
| InventoryType | String | The type of the inventory |
| FromDate | Edm.Date | The date from which calls to be fetched |
| ToDate | Edm.Date | the date till when calls to be fetched |