Survey Sparrow Connector Reference

The Survey Sparrow connector exposes 75 fields (13 metrics, 62 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Survey Sparrow Fields

Survey Sparrow contact_lists fields

The contact_lists report of the Survey Sparrow connector includes 4 fields.

ID	Type	Name	Description
contact_lists__created_at	TEXT	contact_lists.created_at	contact_lists.created_at
contact_lists__description	TEXT	contact_lists.description	contact_lists.description
contact_lists__id	NUMERIC	contact_lists.id	contact_lists.id
contact_lists__name	TEXT	contact_lists.name	contact_lists.name

Survey Sparrow contacts fields

The contacts report of the Survey Sparrow connector includes 10 fields.

ID	Type	Name	Description
contacts__active	BOOLEAN	contacts.active	contacts.active
contacts__createddate	TEXT	contacts.createddate	contacts.createddate
contacts__email	TEXT	contacts.email	contacts.email
contacts__first_name	TEXT	contacts.first_name	contacts.first_name
contacts__id	NUMERIC	contacts.id	contacts.id
contacts__job_title	TEXT	contacts.job_title	contacts.job_title
contacts__last_name	TEXT	contacts.last_name	contacts.last_name
contacts__mobile	TEXT	contacts.mobile	contacts.mobile
contacts__name	TEXT	contacts.name	contacts.name
contacts__unsubscribed	BOOLEAN	contacts.unsubscribed	contacts.unsubscribed

Survey Sparrow questions fields

The questions report of the Survey Sparrow connector includes 15 fields.

ID	Type	Name	Description
questions__annotations	OBJECT	questions.annotations	questions.annotations
questions__choices	OBJECT	questions.choices	questions.choices
questions__created_at	TEXT	questions.created_at	questions.created_at
questions__id	NUMERIC	questions.id	questions.id
questions__is_required	BOOLEAN	questions.is_required	questions.is_required
questions__multiple_answers	BOOLEAN	questions.multiple_answers	questions.multiple_answers
questions__parent_question_id	NUMERIC	questions.parent_question_id	questions.parent_question_id
questions__position	TEXT	questions.position	questions.position
questions__properties	OBJECT	questions.properties	questions.properties
questions__rtxt	TEXT	questions.rtxt	questions.rtxt
questions__scale_points	OBJECT	questions.scale_points	questions.scale_points
questions__section	OBJECT	questions.section	questions.section
questions__tags	OBJECT	questions.tags	questions.tags
questions__type	TEXT	questions.type	questions.type
questions__updated_at	TEXT	questions.updated_at	questions.updated_at

Survey Sparrow responses fields

The responses report of the Survey Sparrow connector includes 12 fields.

ID	Type	Name	Description
responses__answers	OBJECT	responses.answers	responses.answers
responses__channel	OBJECT	responses.channel	responses.channel
responses__channel_id	NUMERIC	responses.channel_id	responses.channel_id
responses__completed_time	TEXT	responses.completed_time	responses.completed_time
responses__contact	TEXT	responses.contact	responses.contact
responses__expressions	OBJECT	responses.expressions	responses.expressions
responses__id	NUMERIC	responses.id	responses.id
responses__language	TEXT	responses.language	responses.language
responses__start_time	TEXT	responses.start_time	responses.start_time
responses__state	TEXT	responses.state	responses.state
responses__survey_id	NUMERIC	responses.survey_id	responses.survey_id
responses__variables	OBJECT	responses.variables	responses.variables

Survey Sparrow roles fields

The roles report of the Survey Sparrow connector includes 8 fields.

ID	Type	Name	Description
roles__account_id	NUMERIC	roles.account_id	roles.account_id
roles__created_at	TEXT	roles.created_at	roles.created_at
roles__deleted_at	TEXT	roles.deleted_at	roles.deleted_at
roles__description	TEXT	roles.description	roles.description
roles__id	NUMERIC	roles.id	roles.id
roles__label	TEXT	roles.label	roles.label
roles__name	TEXT	roles.name	roles.name
roles__updated_at	TEXT	roles.updated_at	roles.updated_at

Survey Sparrow survey_folders fields

The survey_folders report of the Survey Sparrow connector includes 6 fields.

ID	Type	Name	Description
survey_folders__auto_created	BOOLEAN	survey_folders.auto_created	survey_folders.auto_created
survey_folders__created_at	TEXT	survey_folders.created_at	survey_folders.created_at
survey_folders__description	TEXT	survey_folders.description	survey_folders.description
survey_folders__id	NUMERIC	survey_folders.id	survey_folders.id
survey_folders__name	TEXT	survey_folders.name	survey_folders.name
survey_folders__visibility	TEXT	survey_folders.visibility	survey_folders.visibility

Survey Sparrow surveys fields

The surveys report of the Survey Sparrow connector includes 5 fields.

ID	Type	Name	Description
surveys__archived	BOOLEAN	surveys.archived	surveys.archived
surveys__created_at	TEXT	surveys.created_at	surveys.created_at
surveys__id	NUMERIC	surveys.id	surveys.id
surveys__name	TEXT	surveys.name	surveys.name
surveys__survey_type	TEXT	surveys.survey_type	surveys.survey_type

Survey Sparrow users fields

The users report of the Survey Sparrow connector includes 10 fields.

ID	Type	Name	Description
users__admin	BOOLEAN	users.admin	users.admin
users__agency_owner	BOOLEAN	users.agency_owner	users.agency_owner
users__created_at	TEXT	users.created_at	users.created_at
users__email	TEXT	users.email	users.email
users__id	NUMERIC	users.id	users.id
users__name	TEXT	users.name	users.name
users__owner	BOOLEAN	users.owner	users.owner
users__phone	TEXT	users.phone	users.phone
users__role_id	NUMERIC	users.role_id	users.role_id
users__verified	BOOLEAN	users.verified	users.verified

Survey Sparrow other fields

The Survey Sparrow 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	Report
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