Twilio
Prerequisites
Twilio HTTP requests to the REST API are protected with HTTP Basic authentication. In short, you will use your Twilio Account SID as the username and your Auth Token as the password for HTTP Basic authentication.
You can find your Account SID and Auth Token on your dashboard.
See docs for more details.
Setting up the Twilio connector
| No | Item | Required | Example | Notes |
|---|
| 1 | Account ID | Yes | | Twilio account SID |
| 2 | Auth Token | Yes | | Twilio Auth Token. |
| 3 | Replication Start Date | Yes | 2020-10-01T00:00:00Z | UTC date and time in the format 2020-10-01T00:00:00Z. Any data before this date will not be replicated. |
| 4 | Lookback window | No | 60 | How far into the past to look for records. (in minutes) |
Tables in the Twilio connector
Table: alerts
| No | Column Name | Type | Notes |
|---|
| 1 | alert_text | VARCHAR | |
| 2 | date_updated | VARCHAR | |
| 3 | date_generated | VARCHAR | |
| 4 | resource_sid | VARCHAR | |
| 5 | date_created | VARCHAR | |
| 6 | log_level | VARCHAR | |
| 7 | more_info | VARCHAR | |
| 8 | request_method | VARCHAR | |
| 9 | api_version | VARCHAR | |
| 10 | request_url | VARCHAR | |
| 11 | url | VARCHAR | |
| 12 | sid | VARCHAR | |
| 13 | service_sid | VARCHAR | |
| 14 | account_sid | VARCHAR | |
| 15 | error_code | VARCHAR | |
Table: available_phone_numbers_toll_free
| No | Column Name | Type | Notes |
|---|
| 1 | friendly_name | VARCHAR | |
| 2 | iso_country | VARCHAR | |
| 3 | capabilities | VARCHAR | |
| 4 | latitude | VARCHAR | |
| 5 | locality | VARCHAR | |
| 6 | address_requirements | VARCHAR | |
| 7 | lata | VARCHAR | |
| 8 | rate_center | VARCHAR | |
| 9 | phone_number | VARCHAR | |
| 10 | region | VARCHAR | |
| 11 | postal_code | VARCHAR | |
| 12 | beta | BOOLEAN | |
| 13 | longitude | VARCHAR | |
Table: outgoing_caller_ids
| No | Column Name | Type | Notes |
|---|
| 1 | friendly_name | VARCHAR | |
| 2 | date_updated | VARCHAR | |
| 3 | date_created | VARCHAR | |
| 4 | account_sid | VARCHAR | |
| 5 | phone_number | VARCHAR | |
| 6 | uri | VARCHAR | |
| 7 | sid | VARCHAR | |
Table: addresses
| No | Column Name | Type | Notes |
|---|
| 1 | friendly_name | VARCHAR | |
| 2 | iso_country | VARCHAR | |
| 3 | date_updated | VARCHAR | |
| 4 | city | VARCHAR | |
| 5 | date_created | VARCHAR | |
| 6 | verified | BOOLEAN | |
| 7 | uri | VARCHAR | |
| 8 | sid | VARCHAR | |
| 9 | validated | BOOLEAN | |
| 10 | emergency_enabled | BOOLEAN | |
| 11 | street | VARCHAR | |
| 12 | account_sid | VARCHAR | |
| 13 | customer_name | VARCHAR | |
| 14 | postal_code | VARCHAR | |
| 15 | region | VARCHAR | |
| 16 | street_secondary | VARCHAR | |
Table: available_phone_numbers_mobile
| No | Column Name | Type | Notes |
|---|
| 1 | friendly_name | VARCHAR | |
| 2 | iso_country | VARCHAR | |
| 3 | capabilities | VARCHAR | |
| 4 | latitude | VARCHAR | |
| 5 | locality | VARCHAR | |
| 6 | address_requirements | VARCHAR | |
| 7 | lata | VARCHAR | |
| 8 | rate_center | VARCHAR | |
| 9 | phone_number | VARCHAR | |
| 10 | region | VARCHAR | |
| 11 | postal_code | VARCHAR | |
| 12 | beta | BOOLEAN | |
| 13 | longitude | VARCHAR | |
Table: recordings
| No | Column Name | Type | Notes || --- | ----------- | ---- | ----- |
Table: conversations
| No | Column Name | Type | Notes |
|---|
| 1 | friendly_name | VARCHAR | |
| 2 | timers | VARCHAR | |
| 3 | date_updated | VARCHAR | |
| 4 | date_created | VARCHAR | |
| 5 | bindings | VARCHAR | |
| 6 | chat_service_sid | VARCHAR | |
| 7 | url | VARCHAR | |
| 8 | sid | VARCHAR | |
| 9 | unique_name | VARCHAR | |
| 10 | messaging_service_sid | VARCHAR | |
| 11 | account_sid | VARCHAR | |
| 12 | attributes | VARCHAR | |
| 13 | state | VARCHAR | |
Table: available_phone_numbers_local
| No | Column Name | Type | Notes |
|---|
| 1 | friendly_name | VARCHAR | |
| 2 | iso_country | VARCHAR | |
| 3 | capabilities | VARCHAR | |
| 4 | latitude | VARCHAR | |
| 5 | locality | VARCHAR | |
| 6 | address_requirements | VARCHAR | |
| 7 | lata | VARCHAR | |
| 8 | rate_center | VARCHAR | |
| 9 | phone_number | VARCHAR | |
| 10 | region | VARCHAR | |
| 11 | postal_code | VARCHAR | |
| 12 | beta | BOOLEAN | |
| 13 | longitude | VARCHAR | |
External Resources
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.