Arguments

Name	Description	Default
sid R	A specific call identifier to retrieve

SQL Call

exec bsc.Twilio.ListCall 'CA123456789'
select * from Twilio.Call where callSid = 'CA123456789'

Http Call

/bsc/twilio/listcall

Output Columns

String Sid	Twilio call unique identifier
String ParentCallSid	Twilio call that created this leg
DateTime DateCreated	The date/time in UTC that this resource was created
DateTime DateUpdated	The date/time in UTC that this resource was last updated
String AccountSid	The unique id of the Account responsible for creating this call
String To	The phone number, SIP address or Client identifier that received this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String From	The phone number, SIP address or Client identifier that made this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String PhoneNumberSid	If the call was inbound, this is the Sid of the IncomingPhoneNumber that received the call. If the call was outbound, it is the Sid of the OutgoingCallerId from which the call was placed.
String Status	A string representing the status of the call. May be queued, ringing, in-progress, canceled, completed, failed, busy or no-answer.
DateTime StartTime	The start time in UTC of the call. Empty if the call has not yet been dialed.
DateTime EndTime	The end time in UTC of the call. Empty if the call did not complete successfully.
Int32 Duration	The length of the call in seconds. This value is empty for busy, failed, unanswered or ongoing calls.
Decimal Price	The charge for this call, in the currency associated with the account. Populated after the call is completed. May not be immediately available.
String Direction	A string describing the direction of the call. inbound for inbound calls, outbound-api for calls initiated via the REST API or outbound-dial for calls initiated by a verb.
String AnsweredBy	If this call was initiated with answering machine detection, either human or machine. Empty otherwise.
String ForwardedFrom	If this call was an incoming call forwarded from another number, the forwarding phone number (depends on carrier supporting forwarding). Empty otherwise.
String CallerName	If this call was an incoming call to a phone number with Caller ID Lookup enabled, the caller's name. Empty otherwise.
String Uri	The URI for this resource, relative to https://api.twilio.com

Arguments

Name	Description	Default
startTime	Only show calls that started from this date/time. Default is UTC midnight today.
endTime	Only show calls that ended by this date/time
fromPhone	Only show calls from this phone number
toPhone	Only show calls to this phone number
status	Only show calls currently in this status
parentCallSid	Only show calls that belong to this parent call (e.g. Dial legs)
maxRows	Maximum number of rows to return. Use TOP N if using SELECT.

SQL Call

exec bsc.Twilio.ListCalls
select top 100 * from Twilio.Calls

Http Call

/bsc/twilio/listcalls

Output Columns

String Sid	Twilio call unique identifier
String ParentCallSid	Twilio call that created this leg
DateTime DateCreated	The date/time in UTC that this resource was created
DateTime DateUpdated	The date/time in UTC that this resource was last updated
String AccountSid	The unique id of the Account responsible for creating this call
String ToPhone	The phone number, SIP address or Client identifier that received this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String FromPhone	The phone number, SIP address or Client identifier that made this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String PhoneNumberSid	If the call was inbound, this is the Sid of the IncomingPhoneNumber that received the call. If the call was outbound, it is the Sid of the OutgoingCallerId from which the call was placed.
String Status	A string representing the status of the call. May be queued, ringing, in-progress, canceled, completed, failed, busy or no-answer.
DateTime StartTime	The start time in UTC of the call. Empty if the call has not yet been dialed.
DateTime EndTime	The end time in UTC of the call. Empty if the call did not complete successfully.
Int32 Duration	The length of the call in seconds. This value is empty for busy, failed, unanswered or ongoing calls.
Decimal Price	The charge for this call, in the currency associated with the account. Populated after the call is completed. May not be immediately available.
String Direction	A string describing the direction of the call. inbound for inbound calls, outbound-api for calls initiated via the REST API or outbound-dial for calls initiated by a verb.
String AnsweredBy	If this call was initiated with answering machine detection, either human or machine. Empty otherwise.
String ForwardedFrom	If this call was an incoming call forwarded from another number, the forwarding phone number (depends on carrier supporting forwarding). Empty otherwise.
String CallerName	If this call was an incoming call to a phone number with Caller ID Lookup enabled, the caller's name. Empty otherwise.
String Uri	The URI for this resource, relative to https://api.twilio.com

Arguments

Name	Description	Default
sid R	A specific message identifier to retrieve

SQL Call

exec bsc.Twilio.ListMessage 'CA123456789'
select * from Twilio.Message where callSid = 'CA123456789'

Http Call

/bsc/twilio/listmessage

Output Columns

String Sid	Twilio message unique identifier
DateTime DateCreated	The date/time in UTC that this resource was created
DateTime DateUpdated	The date/time in UTC that this resource was last updated
String AccountSid	The unique id of the Account responsible for creating this call
String To	The phone number, SIP address or Client identifier that received this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String From	The phone number, SIP address or Client identifier that made this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String Status	A string representing the status of the call. May be queued, ringing, in-progress, canceled, completed, failed, busy or no-answer.
String NumSegments	The number of body segments associated with this message. For example, an message of 180 characters will be split into one message of 160 characters and another of 20, where NumSegments will be 2.
DateTime DateSent	The date in UTC of the call. Empty if the call has not yet been dialed.
Decimal Price	The charge for this call, in the currency associated with the account. Populated after the call is completed. May not be immediately available.
String Direction	A string describing the direction of the call. inbound for inbound calls, outbound-api for calls initiated via the REST API or outbound-dial for calls initiated by a verb.
String Uri	The URI for this resource, relative to https://api.twilio.com
String ErrorCode	Resulting error code
String ErrorMessage	Resulting error message

Arguments

Name	Description	Default
dateSent	Only show messages sent beginning on this date/time. Default is UTC midnight today.
fromPhone	Only show calls from this phone number
toPhone	Only show calls to this phone number
maxRows	Maximum nuber of rows to return. Use TOP N if using SELECT.

SQL Call

exec bsc.Twilio.ListMessages
select top 100 * from Twilio.Messages

Http Call

/bsc/twilio/listmessages

Output Columns

String Sid	Twilio message unique identifier
DateTime DateCreated	The date/time in UTC that this resource was created
DateTime DateUpdated	The date/time in UTC that this resource was last updated
String AccountSid	The unique id of the Account responsible for creating this call
String To	The phone number, SIP address or Client identifier that received this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String From	The phone number, SIP address or Client identifier that made this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String Status	A string representing the status of the call. May be queued, ringing, in-progress, canceled, completed, failed, busy or no-answer.
String NumSegments	The number of body segments associated with this message. For example, an message of 180 characters will be split into one message of 160 characters and another of 20, where NumSegments will be 2.
DateTime DateSent	The date in UTC of the call. Empty if the call has not yet been dialed.
Decimal Price	The charge for this call, in the currency associated with the account. Populated after the call is completed. May not be immediately available.
String Direction	A string describing the direction of the call. inbound for inbound calls, outbound-api for calls initiated via the REST API or outbound-dial for calls initiated by a verb.
String Uri	The URI for this resource, relative to https://api.twilio.com
String ErrorCode	Resulting error code
String ErrorMessage	Resulting error message

Arguments

Name	Description	Default
category	Category of usage
startDate	Only include usage that has occurred on or after this date
endDate	Only include usage that has occurred on or before this date.

SQL Call

exec bsc.Twilio.ListUsage 'test'
select * from Twilio.ListUsage

Http Call

/bsc/twilio/listusage

Output Columns

String Category	The category of usage. See Usage Categories below.
String Description	A human-readable description of the usage category.
String AccountSid	The Account that accrued the usage.
DateTime StartDate	The first date for which usage is included in this UsageRecord, formatted as YYYY-MM-DD. All dates are in GMT.
DateTime EndDate	The last date for which usage is included in this UsageRecord, formatted as YYYY-MM-DD. All dates are in GMT.
Int32 Usage	The amount of usage (e.g. the number of call minutes). This is frequently the same as Count, but may be different for certain usage categories like calls, where Count represents the number of calls and Usage represents the number of minutes.
String UsageUnit	The units in which Usage is measured. For example minutes for calls, messages for SMS.
Int32 Count	The number of usage events (e.g. the number of calls).
String CountUnit	The units in which Count is measured. For example calls for calls, messages for SMS.
Decimal Price	The total price of the usage, in the currency associated with the account.
String PriceUnit	The currency in which Price is measured, in ISO 4127 format (e.g. usd, eur, jpy).
String Uri	The URI that returns only this UsageRecord, relative to https://api.twilio.com.

Arguments

Name	Description	Default
phones R	One or more phone numbers to call separated by semi-colons (";").
message R	The text of the message you want to send, limited to 160 characters.
mimeType R	image/gif, image/png, image/jpeg, etc. mime-types
mimeFilespec R	File to send. If initiating via REST, do not add argument as a header, but instead attach as a file to the POST request specifying a Content-Type of 'multipart/form-data'.

SQL Call

exec Twilio.SendNms '5611234567', 'Hello, world.'
insert Twilio.Mms (phonesToCall, message ) values ( '5611234567', 'Hello, world.')

Http Call

/bsc/twilio/sendmms

Output Columns

String Sid	Twilio message unique identifier
DateTime DateCreated	The date/time in UTC that this resource was created
DateTime DateUpdated	The date/time in UTC that this resource was last updated
String AccountSid	The unique id of the Account responsible for creating this call
String To	The phone number, SIP address or Client identifier that received this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String From	The phone number, SIP address or Client identifier that made this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String Status	A string representing the status of the call. May be queued, ringing, in-progress, canceled, completed, failed, busy or no-answer.
String NumSegments	The number of body segments associated with this message. For example, an message of 180 characters will be split into one message of 160 characters and another of 20, where NumSegments will be 2.
DateTime DateSent	The date in UTC of the call. Empty if the call has not yet been dialed.
Decimal Price	The charge for this call, in the currency associated with the account. Populated after the call is completed. May not be immediately available.
String Direction	A string describing the direction of the call. inbound for inbound calls, outbound-api for calls initiated via the REST API or outbound-dial for calls initiated by a verb.
String Uri	The URI for this resource, relative to https://api.twilio.com
String ErrorCode	Resulting error code
String ErrorMessage	Resulting error message

Arguments

Name	Description	Default
phones R	One or more phone numbers to call separated by semi-colons (";").
message R	The text of the message you want to send, limited to 1600 characters.

SQL Call

exec Twilio.SendSms '5611234567', 'Hello, world.'
insert Twilio.Sms (phonesToCall, message ) values ( '5611234567', 'Hello, world.')

Http Call

/bsc/twilio/sendsms

Output Columns

String Sid	Twilio message unique identifier
DateTime DateCreated	The date/time in UTC that this resource was created
DateTime DateUpdated	The date/time in UTC that this resource was last updated
String AccountSid	The unique id of the Account responsible for creating this call
String To	The phone number, SIP address or Client identifier that received this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String From	The phone number, SIP address or Client identifier that made this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String Status	A string representing the status of the call. May be queued, ringing, in-progress, canceled, completed, failed, busy or no-answer.
String NumSegments	The number of body segments associated with this message. For example, an message of 180 characters will be split into one message of 160 characters and another of 20, where NumSegments will be 2.
DateTime DateSent	The date in UTC of the call. Empty if the call has not yet been dialed.
Decimal Price	The charge for this call, in the currency associated with the account. Populated after the call is completed. May not be immediately available.
String Direction	A string describing the direction of the call. inbound for inbound calls, outbound-api for calls initiated via the REST API or outbound-dial for calls initiated by a verb.
String Uri	The URI for this resource, relative to https://api.twilio.com
String ErrorCode	Resulting error code
String ErrorMessage	Resulting error message

Arguments

Name	Description	Default
phones R	One or more phone numbers to call separated by semi-colons (";"). In addition to the phone number, three additional parameters may be specified with a number: hangupIfMachine, sendDigits, and timeout. For example, "2120000000,1,ww123,15;4150000000,,,30" would call 2120000000 and hang up phone if an answering machine is detected, send two pauses followed by the numbers 1, 2, and 3, and hangup if no one answers after 15 seconds. 4150000000 would wait 30 seconds before haning up if no one answers. Details: hangupIfMachine will hangup the call if an answering machine is detected. sendDigits is a string of keys to dial after connecting to the number. Valid digits in the string include: any digit (0-9), '#', '*' and 'w' (to insert a half second pause). For example, if you connected to a company phone number, and wanted to pause for one second, dial extension 1234 and then the pound key, use SendDigits=ww1234#. imeout is an integer number of seconds that Twilio should allow the phone to ring before assuming there is no answer. Default is 60 seconds, the maximum is 999 seconds. Note, you could set this to a low value, such as 15, to hangup before reaching an answering machine or voicemail.
twiml R	Twilio TwiML script
record	Set this parameter to 'true' to record the entirety of a phone call.	False
from	The phone number or client identifier to use as the caller id. If using a phone number, it must be a Twilio number or a Verified outgoing caller id for your account.

SQL Call

exec Twilio.SendVoiceMsg '5611234567', 'Hello, world.'
insert Twilio.SendVoiceMsg (phonesToCall, twiml ) values ( '5611234567', 'Hello, world.')

Http Call

/bsc/twilio/sendvoicemsg

Output Columns

String From	The phone number or client identifier to use as the caller id. If using a phone number, it must be a Twilio number or a Verified outgoing caller id for your account.
String To	The phone number, SIP address or Client identifier that received this call. Phone numbers are in E.164 format (e.g. +16175551212). SIP addresses are formated as name@company.com. Client identifiers are formatted client:name.
String Status	A string representing the status of the call. May be queued, ringing, in-progress, canceled, completed, failed, busy or no-answer.
DateTime StartTime	Time call was initiated
DateTime EndTime	Time call completed
String Duration	Length of call in seconds
String AnsweredBy	Whether answered by human or machine.
String AccountSid	The unique id of the Account responsible for creating this call
String Sid	Twilio call unique identifier