Windsor brings all your Survey Sparrow data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Survey Sparrow Field Reference

Available Options

ID	Type	Name	Description	Options
region	SELECT_SINGLE	Region	Specify the API region to use (EU or Non-EU).	eu-api; api;

Fields

ID	Type	Name	Description	Report
contact_lists__created_at	TEXT	contact_lists.created_at	contact_lists.created_at	contact_lists
contact_lists__description	TEXT	contact_lists.description	contact_lists.description	contact_lists
contact_lists__id	NUMERIC	contact_lists.id	contact_lists.id	contact_lists
contact_lists__name	TEXT	contact_lists.name	contact_lists.name	contact_lists
contacts__active	BOOLEAN	contacts.active	contacts.active	contacts
contacts__createddate	TEXT	contacts.createddate	contacts.createddate	contacts
contacts__email	TEXT	contacts.email	contacts.email	contacts
contacts__first_name	TEXT	contacts.first_name	contacts.first_name	contacts
contacts__id	NUMERIC	contacts.id	contacts.id	contacts
contacts__job_title	TEXT	contacts.job_title	contacts.job_title	contacts
contacts__last_name	TEXT	contacts.last_name	contacts.last_name	contacts
contacts__mobile	TEXT	contacts.mobile	contacts.mobile	contacts
contacts__name	TEXT	contacts.name	contacts.name	contacts
contacts__unsubscribed	BOOLEAN	contacts.unsubscribed	contacts.unsubscribed	contacts
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
questions__annotations	OBJECT	questions.annotations	questions.annotations	questions
questions__choices	OBJECT	questions.choices	questions.choices	questions
questions__created_at	TEXT	questions.created_at	questions.created_at	questions
questions__id	NUMERIC	questions.id	questions.id	questions
questions__is_required	BOOLEAN	questions.is_required	questions.is_required	questions
questions__multiple_answers	BOOLEAN	questions.multiple_answers	questions.multiple_answers	questions
questions__parent_question_id	NUMERIC	questions.parent_question_id	questions.parent_question_id	questions
questions__position	TEXT	questions.position	questions.position	questions
questions__properties	OBJECT	questions.properties	questions.properties	questions
questions__rtxt	TEXT	questions.rtxt	questions.rtxt	questions
questions__scale_points	OBJECT	questions.scale_points	questions.scale_points	questions
questions__section	OBJECT	questions.section	questions.section	questions
questions__tags	OBJECT	questions.tags	questions.tags	questions
questions__type	TEXT	questions.type	questions.type	questions
questions__updated_at	TEXT	questions.updated_at	questions.updated_at	questions
responses__answers	OBJECT	responses.answers	responses.answers	responses
responses__channel	OBJECT	responses.channel	responses.channel	responses
responses__channel_id	NUMERIC	responses.channel_id	responses.channel_id	responses
responses__completed_time	TEXT	responses.completed_time	responses.completed_time	responses
responses__contact	TEXT	responses.contact	responses.contact	responses
responses__expressions	OBJECT	responses.expressions	responses.expressions	responses
responses__id	NUMERIC	responses.id	responses.id	responses
responses__language	TEXT	responses.language	responses.language	responses
responses__start_time	TEXT	responses.start_time	responses.start_time	responses
responses__state	TEXT	responses.state	responses.state	responses
responses__survey_id	NUMERIC	responses.survey_id	responses.survey_id	responses
responses__variables	OBJECT	responses.variables	responses.variables	responses
roles__account_id	NUMERIC	roles.account_id	roles.account_id	roles
roles__created_at	TEXT	roles.created_at	roles.created_at	roles
roles__deleted_at	TEXT	roles.deleted_at	roles.deleted_at	roles
roles__description	TEXT	roles.description	roles.description	roles
roles__id	NUMERIC	roles.id	roles.id	roles
roles__label	TEXT	roles.label	roles.label	roles
roles__name	TEXT	roles.name	roles.name	roles
roles__updated_at	TEXT	roles.updated_at	roles.updated_at	roles
source	TEXT	Source	The name of the Windsor connector returning the row
survey_folders__auto_created	BOOLEAN	survey_folders.auto_created	survey_folders.auto_created	survey_folders
survey_folders__created_at	TEXT	survey_folders.created_at	survey_folders.created_at	survey_folders
survey_folders__description	TEXT	survey_folders.description	survey_folders.description	survey_folders
survey_folders__id	NUMERIC	survey_folders.id	survey_folders.id	survey_folders
survey_folders__name	TEXT	survey_folders.name	survey_folders.name	survey_folders
survey_folders__visibility	TEXT	survey_folders.visibility	survey_folders.visibility	survey_folders
surveys__archived	BOOLEAN	surveys.archived	surveys.archived	surveys
surveys__created_at	TEXT	surveys.created_at	surveys.created_at	surveys
surveys__id	NUMERIC	surveys.id	surveys.id	surveys
surveys__name	TEXT	surveys.name	surveys.name	surveys
surveys__survey_type	TEXT	surveys.survey_type	surveys.survey_type	surveys
today	DATE	Today	Today's date
users__admin	BOOLEAN	users.admin	users.admin	users
users__agency_owner	BOOLEAN	users.agency_owner	users.agency_owner	users
users__created_at	TEXT	users.created_at	users.created_at	users
users__email	TEXT	users.email	users.email	users
users__id	NUMERIC	users.id	users.id	users
users__name	TEXT	users.name	users.name	users
users__owner	BOOLEAN	users.owner	users.owner	users
users__phone	TEXT	users.phone	users.phone	users
users__role_id	NUMERIC	users.role_id	users.role_id	users
users__verified	BOOLEAN	users.verified	users.verified	users