Excel Add-In for Microsoft Teams

Build 23.0.8839

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

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