Delighted

Delighted is a cloud-based customer experience (CX) management solution intended to help small to large-sized enterprises gather and analyze feedback 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.

Establishing Connection

To create a connection to Delighted, you need to specify your API Key — an automatically generated REST API key used for connecting to Delighted.

Obtaining Credentials

The API Key is displayed in the Delighted API documentation in the Introduction topic if you are signed in to Delighted.

Delighted API Key

Creating Connection

Paste the obtained API key to the API Key field in the connection editor.

Connection Editor window

Connector Specifics

Object Peculiarities

Responses

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:

{"Customer ID":"1234567","Location":"USA"}

People

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 set Channel to Email, you must map the Email field.

  • If you set Channel to SMS, you must map the PhoneNumber field.

Metrics Objects

Metrics* objects return aggregated information from survey responses as a single row. The set of metrics differs depending on the survey type. Therefore, a separate Metrics object with its own columns has been added for each type of survey. You need to use the Metrics object that matches the survey type in your account.

The following Metrics* objects are supported in Skyvia: Metrics_5StarRating, Metrics_CES, Metrics_CSAT, Metrics_NPS, Metrics_ENPS, Metrics_PMF, Metrics_Smileys, Metrics_Thumbs.

Incremental Replication and Synchronization

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 although such objects as SMSAutopilotConfiguration and EmailAutopilotConfiguration have CreatedDate/UpdatedDate fields, they are read-only. According to the Delighted documentation, they do not support 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, and EmailAutopilotConfiguration have both CreatedDate and UpdatedDate fields; thus, they can be fully replicated with incremental updates. The People object contains only CreatedDate, so Skyvia detects only new records in it.

DML Operations Support

Operation Object
INSERT, UPDATE, DELETE EmailAutopilotPeople, SMSAutopilotPeople
INSERT, DELETE People
INSERT Responses, UnsubscribedPeople

Supported Actions

Skyvia supports all the common actions for Delighted.

On This Page