ListSurveys
Returns all surveys for a 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 | 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. |