ListSurveys
Returns all survey configurations associated with a specific audience list.
Table Specific Information
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.
- 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. |