ReportAbuse
A list of abuse complaints for a specific list.
Table Specific Information
SELECT is supported for ReportAbuse.
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.
- CampaignId supports the '=' operator.
SELECT * FROM ReportAdvice WHERE CampaignId = 'abc' and Id = '556'
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique id for the abuse report. |
| CampaignId [KEY] | String | The campaign id for the abuse report |
| ListId [KEY] | String | The list id for the abuse report. |
| EmailId [KEY] | String | The list-specific ID for the given email address |
| EmailAddress | String | Email address for a subscriber |
| Date | String | Date for the abuse report |
| MergeFields | String | A dictionary of merge fields where the keys are the merge tags. See the Merge Fields documentation for more about the structure. |
| VIP | Boolean | VIP status for subscriber. |
| ListIsActive | Boolean | The status of the list used, namely if it's deleted or disabled. |