PstnCalls
Retrieves a list of PSTN Calls
Table Specific Information
Select
Custom App and Client Credentials should be used. See Creating a Custom OAuth Application The add-in 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 add-in.
- 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 |