Twilio

Adding the Data Source

1) Log in to your Twilio account with a user that has administrator permissions;

2) On the left side menu, click on Dashboard > Settings > General;

3) Look for the “API Credentials” > “LIVE Credentials” section and copy the “Account SID” and “Auth Token” values;

4) On the Kondado platform, go to the add new sources page and select the Twilio data source;

5) In “Name” give a name for your data source and in “Account SID” and “Auth Token” copy the values obtained in step (3);

Now just click on SAVE and start creating pipelines to replicate data from Twilio to your Data Warehouse or Data Lake.

Pipelines

Relationship chart

Click here to see the relationship chart for this data source

Messages

Field	Type
sid	text	[en] The unique string that that we created to identify the Message resource.
account_sid	text	[en] The SID of the Account that sent the message that created the resource.
body	text	[en] (Available for up to 30 DAYS) The message text. Can be up to 1,600 characters long.
date_created	timestamp	[en] The date and time in GMT that the resource was created
date_sent	timestamp	[en] The date and time in GMT that the resource was sent. For outgoing messages, this is when we sent the message. For incoming messages, this is when we made the HTTP request to your application.
date_updated	timestamp	[en] The date and time in GMT that the resource was last updated
direction	text	[en] The direction of the message. Can be: inbound for incoming messages, outbound-api for messages initiated by a REST API, outbound-call for messages initiated during a call, or outbound-reply for messages initiated in response to an incoming message.
error_code	text	[en] The error code returned if your message status is failed or undelivered . The error_code provides more information about the failure. If the message was successful, this value is null.
error_message	text	[en] The description of the error_code if your message status is failed or undelivered . If the message was successful, this value is null.
from	text	[en] (Available for up to 120 DAYS) The phone number (in E.164 format), alphanumeric sender ID , or Wireless SIM that initiated the message. For incoming messages, this will be the number of the sending phone. For outgoing messages, this value will be one of your Twilio phone numbers or the alphanumeric sender ID used.
messaging_service_sid	text	[en] The SID of the Messaging Service used with the message. The value is null if a Messaging Service was not used.
num_media	float	[en] The number of media files associated with the message. A message can send up to 10 media files.
num_segments	float	[en] The number of segments that make up the complete message. A message body that is too large to be sent in a single SMS message is segmented and charged as multiple messages. Inbound messages over 160 characters are reassembled when the message is received. Note: When using a Messaging Service to send messages, num_segments will always be 0 in Twilio’s response to your API request.
price	float	[en] The amount billed for the message, in the currency specified by price_unit . Note that your account is charged for each segment we send to the handset. Populated after the message has been sent. May not be immediately available.
price_unit	text	[en] The currency in which price is measured, in ISO 4127 format (e.g. usd , eur , jpy ).
status	text	[en] The status of the message. Can be: accepted , scheduled (Pilot only), queued , sending , sent , failed , delivered , undelivered , receiving , received , or read (WhatsApp only). For more information, See https://www.twilio.com/docs/sms/api/message-resource#message-status-values
to	text	[en] (Available for up to 120 DAYS) The phone number in E.164 format that received the message. For incoming messages, this will be one of your Twilio phone numbers. For outgoing messages, this will be the sending phone.