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
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 |
Last updated