Schema Information

This subtopic provides a structured reference to assist you in working with Daton's Survicate connector and the associated fields and tables.

Tables/APIs

The following is the list of tables or APIs associated with the Survicate connector:

• All_Surveys

• Retrieve_Survey

• All_Responses

• List_Questions

• Respondents_Attributes

• Respondents_Responses

All_Surveys

Fetch a list of all surveys within your workspace, including their associated metadata and configuration parameters. For more information, see Survey.

Primary Key: id - This is the unique identifier.

Fields

Field Name	Data Type
id	STRING
type	STRING
name	STRING
created_at	TIMESTAMP
enabled	BOOLEAN
responses	NUMERIC

Retrieve_Survey

Get the details and parameters of a specific survey using its unique survey ID. For more information, see Retrieve survey information.

Primary Key: id - This is the unique identifier.

Fields

Field Name	Data Type
id	STRING
type	STRING
name	STRING
created_at	TIMESTAMP
enabled	BOOLEAN
responses	NUMERIC
author	RECORD
first_response_at	TIMESTAMP
last_response_at	TIMESTAMP
attributes	STRING

All_Responses

Get the list of responses for a specific survey identified by its unique ID. For more information, see Response.

Primary Key: uuid and uuid (respondent) - These two fields together form the unique identifier.

Fields

Field Name	Data Type
uuid	STRING
url	STRING
device_type	STRING
operating_system	STRING
language	STRING
answers	RECORD
collected_at	TIMESTAMP
respondent	RECORD

List_Questions

Fetch all the questions in a specific survey, making it simple to study or analyze the survey structure. For more information, see List questions.

Primary Key: id - This is the unique identifier.

Fields

Field Name	Data Type
id	NUMERIC
type	STRING
question	STRING
introduction	STRING

Respondents_Attributes

The names and values of custom attributes associated with a given respondent and passed to Survicate via the JavaScript API, integrations, or embedded inside the survey link are returned. For more information, see List respondent's attributes.

Primary Key: id - This is the unique identifier.

Fields

Field Name	Data Type
id	NUMERIC
name	STRING
value	STRING

Respondents_Responses

Retrieves a list of survey responses provided by the respondents. For more information, see List respondent's responses.

Primary Key: id (survey) - This is the unique identifier.

Fields

Field Name	Data Type
survey	RECORD
response	RECORD