Delighted Connector Reference

9 metrics24 dimensions

Fields

The Delighted connector exposes 33 fields (9 metrics, 24 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Delighted Fields

Delighted bounces fields

The bounces report of the Delighted connector includes 4 fields.

ID	Type	Name	Description
bounces__bounced_at	NUMERIC	bounces.bounced_at	bounces.bounced_at
bounces__email	TEXT	bounces.email	bounces.email
bounces__name	TEXT	bounces.name	bounces.name
bounces__person_id	TEXT	bounces.person_id	bounces.person_id

Delighted people fields

The people report of the Delighted connector includes 8 fields.

ID	Type	Name	Description
people__created_at	NUMERIC	people.created_at	people.created_at
people__email	TEXT	people.email	people.email
people__id	TEXT	people.id	people.id
people__last_responded_at	NUMERIC	people.last_responded_at	people.last_responded_at
people__last_sent_at	NUMERIC	people.last_sent_at	people.last_sent_at
people__name	TEXT	people.name	people.name
people__next_survey_scheduled_at	NUMERIC	people.next_survey_scheduled_at	people.next_survey_scheduled_at
people__phone_number	TEXT	people.phone_number	people.phone_number

Delighted survey_responses fields

The survey_responses report of the Delighted connector includes 12 fields.

ID	Type	Name	Description
survey_responses__additional_answers	OBJECT	survey_responses.additional_answers	survey_responses.additional_answers
survey_responses__comment	TEXT	survey_responses.comment	survey_responses.comment
survey_responses__created_at	NUMERIC	survey_responses.created_at	survey_responses.created_at
survey_responses__id	TEXT	survey_responses.id	survey_responses.id
survey_responses__notes	OBJECT	survey_responses.notes	survey_responses.notes
survey_responses__permalink	TEXT	survey_responses.permalink	survey_responses.permalink
survey_responses__person	TEXT	survey_responses.person	survey_responses.person
survey_responses__person_properties	OBJECT	survey_responses.person_properties	survey_responses.person_properties
survey_responses__score	NUMERIC	survey_responses.score	survey_responses.score
survey_responses__survey_type	TEXT	survey_responses.survey_type	survey_responses.survey_type
survey_responses__tags	OBJECT	survey_responses.tags	survey_responses.tags
survey_responses__updated_at	NUMERIC	survey_responses.updated_at	survey_responses.updated_at

Delighted unsubscribes fields

The unsubscribes report of the Delighted connector includes 4 fields.

ID	Type	Name	Description
unsubscribes__email	TEXT	unsubscribes.email	unsubscribes.email
unsubscribes__name	TEXT	unsubscribes.name	unsubscribes.name
unsubscribes__person_id	TEXT	unsubscribes.person_id	unsubscribes.person_id
unsubscribes__unsubscribed_at	NUMERIC	unsubscribes.unsubscribed_at	unsubscribes.unsubscribed_at

Delighted other fields

The Delighted connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date

API Connectors