Delete and query connections between phones and Twilio.
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'
Twilio does not allow Calls to be added.
Twilio does not allow Calls to be updated.
The Id of the call.
The creation date of the call.
The modification date of the call.
The Id of the parent call.
The Id of the account that created the call.
The phone number, SIP address, or client identifier that is called.
The formatted phone number, SIP address, or client identifier that is called.
The phone number, SIP address, or client identiifer that has made the call.
The formatted number, SIP address, or client identifier that has made the call.
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.
The status of the call. One of the following values: queued, ringing, in-progress, canceled, completed, failed, busy, or no-answer.
The allowed values are queued, ringing, in-progress, canceled, completed, failed, busy, no-answer.
The start time of the call. Empty if the call has not yet been dialed.
The end time of the call. Empty if the call did not complete successfully.
The duration of the call. Empty for busy, failed, unanswered, or ongoing calls.
The price of the call after the call is completed.
The direction of the call. One of the following values: inbound, outbound-api, or outbound-dial.
The allowed values are inbound, outbound-api, outbound-dial.
One of the following values if the call was initiated with answering machine detection: human or machine. Empty otherwise.
The API version of the call.
The phone number that forwarded an incoming call. Note that the carrier must support forwarding.
The caller name to a phone number that has Caller Id Lookup enabled.
The URI for the call.