ListSurveys
Returns all survey configurations associated with a specific audience list.
Table Specific Information
Select
The connector 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 connector.
- ListId supports the '=' operator.
- Id supports the '=' operator.
SELECT * FROM ListSurveys where ListId='545578' and Id='092ec96'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier of the survey within the Mailchimp account. |
| ListId | String | The unique identifier of the Mailchimp list (audience) associated with the survey. |
| Title | String | The title of the survey, as displayed to recipients. |
| Status | String | The current status of the survey, such as 'draft', 'published', or 'closed'. |
| CreatedAt | Datetime | The date and time when the survey was initially created. |
| UpdatedAt | Datetime | The date and time when the survey was last modified. |
| PublishedAt | Datetime | The date and time when the survey was published and made available to respondents. |
| HostedUrl | String | The public URL where the survey is hosted and can be accessed by participants. |
| WebId | String | The unique web identifier used to reference the survey in the Mailchimp web application. |
| IsPipedToInbox | Boolean | Indicates whether survey responses are automatically delivered to the user's Mailchimp inbox for review. |
| QuestionCount | Integer | The total number of questions included in the survey. |
| Questions | String | A structured list or array containing the individual questions that make up the survey. |
| ResponseCount | Integer | The total number of responses collected for the survey. |