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. The allowed values are 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. The allowed values are 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. |