SSIS Components for Twilio

Build 21.0.7871

CallEvents

The call events resource provides programmatic access to call progress and SDK events for a provided call SID.

Table Specific Information

The call events resource provides metadata on SDK events for specific user over a call.

Select

Twilio allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison.
Note: CallSid is required in order to query CallEvents.

SELECT * FROM CallEvents where CallSid='CH7040b87e3664410aa4c241a3d6c85f0b'

SELECT * FROM Callevents where CallSid='CH7040b87e3664410aa4c241a3d6c85f0b' and Edge='sdk_edge'

Columns

Name Type References Description
CallSid String

Calls.Sid

Call SID for the call the events are associated with
AccountSid String The account SID this call belongs to
CarrierEdge String Represents the connection between Twilio and our immediate carrier partners.
ClientEdgeMetadataEdgeLocation String Represents the edge location value for Twilio media gateway for Client calls.
ClientEdgeMetadataRegion String Represents the edge location value for Twilio media gateway for Client calls.
Edge String The edge reporting the event
Group String Event group
Level String Detail level
Name String Event name
SdkEdgeMetadataClientName String The Voice SDK client name running locally in the browser or in the application.
SdkEdgeMetadataCountryCode String The Voice SDK country_code running locally in the browser or in the application.
SdkEdgeMetadataIpAddress String The Voice SDK ip_address running locally in the browser or in the application.
SdkEdgeMetadataLocationLat Double The Voice SDK lattitude of location running locally in the browser or in the application.
SdkEdgeMetadataLocationLon Double The Voice SDK longitude value of location client running locally in the browser or in the application.
SdkEdgeMetadataSdkDeviceArch String The Voice SDK device arch of client running locally in the browser or in the application.
SdkEdgeMetadataSdkDeviceModel String The Voice SDK device model of client running locally in the browser or in the application.
SdkEdgeMetadataSdkDeviceType String The Voice SDK device type of client running locally in the browser or in the application.
SdkEdgeMetadataSdkDeviceVendor String The Voice SDK device vendor of client running locally in the browser or in the application.
SdkEdgeMetadataSdkEdgeLocation String The Voice SDK edge_location running locally in the browser or in the application.
SdkEdgeMetadataSdkOSName String The Voice SDK OS name running locally in the browser or in the application.
SdkEdgeMetadataSdkOSVersion String The Voice SDK OS version running locally in the browser or in the application.
SdkEdgeMetadataSdkPlatform String The Voice SDK platform of the application.
SdkEdgeMetadataSdkSelectedRegion String The Voice SDK selected_region of client in the application.
SdkEdgeMetadataSdkType String The Voice SDK of the application.
SdkEdgeMetadataSdkVersion String The Voice SDK version of the application.
SipEdge String Represents the Twilio media gateway for SIP interface and SIP trunking calls.
Timestamp Datetime Event time

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7871