Connecting to Delighted
Delighted is a cloud-based customer experience (CX) management solution intended to help small to large-sized enterprises gather and analyze feedbacks from customers and target audiences by conducting surveys across a variety of platforms.
Data integration: Skyvia supports importing data to and from Delighted, exporting Delighted data to CSV files, replicating Delighted data to relational databases, and synchronizing Delighted data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Delighted.
Query: Skyvia Query supports Delighted.
Delighted-Specific Features and Limitations
Skyvia has the following limitations for Delighted:
In the Data Integration product, Delighted connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Delighted in your package.
Skyvia supports the following import (DML) operations for Delighted objects:
INSERT, UPDATE, DELETE: EmailAutopilotPeople, SMSAutopilotPeople.
INSERT, DELETE: People.
INSERT: Responses, UnsubscribedPeople.
Skyvia supports Synchronization for objects that contain the CreatedDate and UpdatedDate fields. Thus, only such objects as EmailAutopilotPeople and SMSAutopilotPeople can be fully synchronized.
Please note that despite the fact that such objects as SMSAutopilotConfiguration and EmailAutopilotConfiguration have CreatedDate/UpdatedDate fields, they are read-only. According to the Delighted documentation, they do not involve data inserting/updating.
Skyvia supports Replication with Incremental Updates for objects that contain either the CreatedDate or UpdatedDate fields. Such objects as Responses, EmailAutopilotPeople, SMSAutopilotPeople, SMSAutopilotConfiguration, EmailAutopilotConfiguration have both CreatedDate and UpdatedDate fields, thus, they can be fully relicated with incremental updates. The People object contains only CreatedDate, thus Skyvia detects only new records.
When importing data to the Responses object, the value for the PersonProperties field should be provided as a JSON array of objects, like the following:
When importing data to the People object, the required fields are not defined in the mapping since they depend on the selected Channel type.
If you need to set an Email_value for the _Channel field, click the Column list and select Email value from the drop-down Column mapping list.
If you need to set an SMS value for the Channel field, click the Column list, select Constant, and then a constant value — SMS. Below specify the required phone number in the PhoneNumber field.
The Metrics object returns aggregated information from survey responses as a single row. The set of metrics differs depending on the survey type. Therefore, for each type of survey, a separate Metrics object with its own columns has been added. You need to use the Metrics object that matches the survey type in your account.
The following objects are supported in Skyvia: Metrics_5StarRating, Metrics_CES, Metrics_CSAT, Metrics_NPS, Metrics_ENPS, Metrics_PMF, Metrics_Smileys, Metrics_Thumbs.
To create a connection to Delighted, you need to specify your API Key. To start, follow the below steps:
- Click +NEW in the top menu.
- Click Connection in the menu on the left to open the Select Connector page.
- In the opened page, select Delighted.
- In the Connection Editor page, specify a connection name that will be used to identify the connection.
Enter your API Key.
- Click Create Connection.
- API Key — an automatically generated REST API key used for connecting to Delighted. Check the following link in the Delighted documentation to know how to get an API Key.
Supported Actions and Actions Specifics
Delighted connector supports the following actions: