Delighted
Prerequisites
To set up the Delighted source connector, you'll need the Delighted API key.
Setting up the Delighted connector
| No | Item | Required | Example | Notes |
|---|
| 1 | Delighted API Key | Yes | | A Delighted API key. |
| 2 | Date Since | Yes | 2022-05-30T04:50:23Z
2022-05-30 04:50:23 | The date from which you'd like to replicate the data |
Tables in the Delighted connector
| No | Table Name | Columns | Primary Keys | Read Mode | Inc. Sync Keys | API Info |
|---|
| 1 | unsubscribes | 4 | person_id | Full Refresh, Incremental | unsubscribed_at | |
| 2 | bounces | 4 | person_id | Full Refresh, Incremental | bounced_at | |
| 3 | people | 8 | id | Full Refresh, Incremental | created_at | API Reference |
| 4 | survey_responses | 12 | id | Full Refresh, Incremental | updated_at | |
Table: unsubscribes
| No | Column Name | Type | Notes |
|---|
| 1 | unsubscribed_at | INTEGER | Incremental sync key |
| 2 | name | VARCHAR | |
| 3 | email | VARCHAR | |
| 4 | person_id | VARCHAR | Primary Key |
Table: bounces
| No | Column Name | Type | Notes |
|---|
| 1 | name | VARCHAR | |
| 2 | bounced_at | INTEGER | Incremental sync key |
| 3 | email | VARCHAR | |
| 4 | person_id | VARCHAR | Primary Key |
Table: people
| No | Column Name | Type | Notes |
|---|
| 1 | last_sent_at | INTEGER | |
| 2 | last_responded_at | INTEGER | |
| 3 | name | VARCHAR | |
| 4 | created_at | INTEGER | Incremental sync key |
| 5 | phone_number | VARCHAR | |
| 6 | id | VARCHAR | Primary Key |
| 7 | next_survey_scheduled_at | INTEGER | |
| 8 | email | VARCHAR | |
Table: survey_responses
| No | Column Name | Type | Notes |
|---|
| 1 | score | INTEGER | |
| 2 | notes | VARCHAR | |
| 3 | updated_at | INTEGER | Incremental sync key |
| 4 | person | VARCHAR | |
| 5 | person_properties | VARCHAR | |
| 6 | created_at | INTEGER | |
| 7 | comment | VARCHAR | |
| 8 | id | VARCHAR | Primary Key |
| 9 | permalink | VARCHAR | |
| 10 | survey_type | VARCHAR | |
| 11 | additional_answers | VARCHAR | |
| 12 | tags | 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.