ODBC Driver for Twilio

Build 24.0.9062

Calls

Delete and query connections between phones and Twilio.

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. The available columns for Sid are From, To, StartTime, EndTime, ParentCallSid, and Sid. StartTime and EndTime can be used with the >, >=, <, <=, or = conditions.

SELECT * FROM Calls WHERE StartTime <= '2014-10-10' AND EndTime >= '2015-10-10'

Insert

Twilio does not allow Calls to be added.

Update

Twilio does not allow Calls to be updated.

Delete


DELETE FROM Calls WHERE Sid = 'CAcdc741bdcc2ae'

Columns

Name Type ReadOnly References Description
Sid [KEY] String True

The Id of the call.

DateCreated Datetime True

The creation date of the call.

DateUpdated Datetime True

The modification date of the call.

ParentCallSid String True

The Id of the parent call.

AccountSid String True

The Id of the account that created the call.

To String True

The phone number, SIP address, or client identifier that is called.

ToFormatted String True

The formatted phone number, SIP address, or client identifier that is called.

From String True

The phone number, SIP address, or client identiifer that has made the call.

FromFormatted String True

The formatted number, SIP address, or client identifier that has made the call.

PhoneNumberSid String True

If the call was inbound, the Sid of the IncomingPhoneNumber that received the call. For an outbound call, the Sid of the OutgoingCallerId that made the call.

Status String True

The status of the call. One of the following values: queued, ringing, in-progress, canceled, completed, failed, busy, or no-answer.

使用できる値は次のとおりです。queued, ringing, in-progress, canceled, completed, failed, busy, no-answer

StartTime Datetime True

The start time of the call. Empty if the call has not yet been dialed.

EndTime Datetime True

The end time of the call. Empty if the call did not complete successfully.

Duration Integer True

The duration of the call. Empty for busy, failed, unanswered, or ongoing calls.

Price Decimal True

The price of the call after the call is completed.

Direction String True

The direction of the call. One of the following values: inbound, outbound-api, or outbound-dial.

使用できる値は次のとおりです。inbound, outbound-api, outbound-dial

AnsweredBy String True

One of the following values if the call was initiated with answering machine detection: human or machine. Empty otherwise.

ApiVersion String True

The API version of the call.

ForwardedFrom String True

The phone number that forwarded an incoming call. Note that the carrier must support forwarding.

CallerName String True

The caller name to a phone number that has Caller Id Lookup enabled.

Uri String True

The URI for the call.

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