SurveyResponses
Returns a list of responses for a survey.
View-Specific Information
Select
The provider uses the Mailchimp API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| SurveyId | = |
| AnsweredQuestion | = |
| ChoseAnswer | = |
| RespondentFamiliarityIs | = |
SELECT * FROM SurveyResponses WHERE SurveyId = '4548' AND AnsweredQuestion = '81215a'
SELECT * FROM SurveyResponses WHERE SurveyId = '4548' AND ChoseAnswer = '81215a'
SELECT * FROM SurveyResponses WHERE SurveyId = '4548' AND RespondentFamiliarityIs = 'new'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The Id of the survey response. | |
| SubmittedAt | Datetime | The date and time when the survey response was submitted. | |
| ContactEmailId | String | The MD5 hash of the lowercase version of the list member email address. | |
| ContactId | String | The Id of this contact. | |
| ContactStatus | String | The contact's current status.
The allowed values are Subscribed, Unsubscribed, Non-Subscribed, Cleaned, Archived. | |
| ContactEmail | String | The contact's email address. | |
| ContactFullName | String | The contact's full name. | |
| ContactConsentsToOneToOneMessaging | Boolean | Indicates whether a contact consents to 1:1 messaging. | |
| ContactAvatarUrl | String | The URL for the contact's avatar or profile image. | |
| IsNewContact | Boolean | Indicates whether this contact was added to the Mailchimp audience via this survey. | |
| SurveyId [KEY] | String |
Surveys.Id | A string that uniquely identifies this survey. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| AnsweredQuestion | Integer | The Id of the question that was answered. | |
| ChoseAnswer | String | The Id of the option chosen to filter responses on. | |
| RespondentFamiliarityIs | String | Filters survey responses by the familiarity of the respondents. Possible values: 'new', 'known', or 'unknown'. |