Twilio

Adicionando o conector

1) Faça login na sua conta do Twilio com um usuário que tenha permissões de administrador

2) No menu lateral esquerdo, clique em Dashboard > Settings > General

3) Procure pela seção “API Credentials” > “LIVE Credentials” e copie os valores “Account SID” e “Auth Token”

4) Faça login na Kondado, vá para a seção de adicionar conectores e selecione o conector do Twilio

5) No conector, em “Nome” dê um nome para o seu conector e, em “Account SID” e “Auth Token” copie os valores obtidos no passo (3)

Agora basta clicar em SALVAR e para começar a receber dados do Twilio no Data Warehouse ou Data Lake

Integrações

Gráfico de relacionamento entre tabelas

Messages

Campo	Tipo
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.