Schema Information of Survicate Connector
This subtopic provides a structured reference to assist you in working with Daton's Survicate connector and the associated fields and tables.
Schema Information of Survicate Connector
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 |
