ListSurveys
Returns all surveys for a list.
Table Specific Information
Select
The server 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 server.
- ListId supports the '=' operator.
- Id supports the '=' operator.
SELECT * FROM ListSurveys where ListId='545578' and Id='092ec96'
Columns
| Name | Type | Description |
| Id [KEY] | String | Unique identifier for the survey. |
| ListId | String | Identifier for the list associated with the survey. |
| Title | String | Title of the survey. |
| Status | String | Status of the survey. |
| CreatedAt | Datetime | Date and time the survey was created. |
| UpdatedAt | Datetime | Date and time the survey was last updated. |
| PublishedAt | Datetime | Date and time the survey was published. |
| HostedUrl | String | URL where the survey is hosted. |
| WebId | String | Web ID for the survey. |
| IsPipedToInbox | Boolean | Indicates if the survey is piped to inbox. |
| QuestionCount | Integer | Number of questions in the survey. |
| Questions | String | Questions included in the survey. |
| ResponseCount | Integer | Number of responses received for the survey. |