Twilio taskrouter
Prerequisites
Twilio Taskroute HTTP requests to the REST API are protected with HTTP Basic authentication. You will use your Twilio Account SID as the username and your Auth Token as the password for HTTP Basic authentication. You will also have to use your Workspace ID as the sid if you wish to access a particular workspace or it's subresources.
You can find your Account SID and Auth Token on your dashboard by scrolling down the console once you have created a Twilio account. You can find Taskrouter in the Explore Products page under Solutions in the list. Click on it to expand a panel in the sidebar and click on Workspaces to be taken to your created workspaces. Each workspace has it's unique ID as SID with which you can access the streams.
See docs for more details.
Tables in the Twilio taskrouter connector
| No | Table Name | Columns | Primary Keys | Read Mode | Inc. Sync Keys | API Info |
|---|---|---|---|---|---|---|
| 1 | workspaces | 14 | Full Refresh | API Reference | ||
| 2 | workers | 13 | Full Refresh | API Reference |
Table: workspaces
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | events_filter | VARCHAR | |
| 2 | friendly_name | VARCHAR | |
| 3 | date_updated | VARCHAR | |
| 4 | timeout_activity_sid | VARCHAR | |
| 5 | date_created | VARCHAR | |
| 6 | multi_task_enabled | BOOLEAN | |
| 7 | event_callback_url | VARCHAR | |
| 8 | url | VARCHAR | |
| 9 | sid | VARCHAR | |
| 10 | timeout_actvity_name | VARCHAR | |
| 11 | account_sid | VARCHAR | |
| 12 | links | VARCHAR | |
| 13 | default_activity_sid | VARCHAR | |
| 14 | default_acitvity_name | VARCHAR |
Table: workers
| No | Column Name | Type | Notes |
|---|---|---|---|
| 1 | friendly_name | VARCHAR | |
| 2 | date_updated | VARCHAR | |
| 3 | activity_sid | VARCHAR | |
| 4 | date_created | VARCHAR | |
| 5 | workspace_sid | VARCHAR | |
| 6 | available | BOOLEAN | |
| 7 | actvity_name | VARCHAR | |
| 8 | url | VARCHAR | |
| 9 | sid | VARCHAR | |
| 10 | account_sid | VARCHAR | |
| 11 | date_status_changed | VARCHAR | |
| 12 | attributes | VARCHAR | |
| 13 | links | 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.