SurveyResponses
List of survey responses.
Table Specific Information
SELECT is supported for SurveyResponses.
Select
The add-in will use the Mailchimp API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- Id supports the '=' operator.
- SurveyId supports the '=' operator.
- AnsweredQuestion supports the '=' operator.
- ChoseAnswer supports the '=' operator.
- RespondentFamiliarityIs supports the '=' operator.
SELECT * FROM SurveyResponses WHERE SurveyId = '4548' and Id = '5995' 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 | Description |
| Id [KEY] | String | The ID for 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. |
| 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 | URL for the contact's avatar or profile image. |
| IsNewContact | Boolean | If this contact was added to the Mailchimp audience via this survey. |
| SurveyId [KEY] | String | A string that uniquely identifies this survey. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are 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 | Filter survey responses by familiarity of the respondents. Possible values: 'new', 'known', or 'unknown' |