CampaignFeedback
A summary of the comment feedback for a specific campaign.
Table Specific Information
SELECT, INSERT, UPDATE, and DELTE are supported for CampaignFeedback.
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.
- FeedbackId supports the '=' operator.
- CampaignId supports the '=' operator.
SELECT * FROM CampaignFeedback WHERE FeedbackId = '1245' SELECT * FROM CampaignFeedback WHERE CampaignId = '1245'
Insert
The CampaignId and Message are required for INSERTs.
INSERT INTO CampaignFeedback (CampaignId, Message) VALUES ('myCampaignId', 'myMessage')
Columns
| Name | Type | ReadOnly | Description |
| FeedbackId [KEY] | Integer | True |
The individual id for the feedback item. |
| ParentId | Integer | True |
If a reply, the id of the parent feedback item. |
| BlockId | Integer | False |
The block id for the editable block that the feedback addresses. |
| Message | String | False |
The content of the feedback. |
| IsComplete | Boolean | False |
The status of feedback. |
| CreatedBy | String | True |
The login name of the user who created the feedback. |
| CreatedAt | Datetime | True |
The date and time the feedback item was created. |
| UpdatedAt | Datetime | True |
The date and time the feedback was last updated. |
| Source | String | True |
The source of the feedback ('email', 'sms', 'web', 'ios', 'android', or 'api'). |
| CampaignId [KEY] | String | False |
The unique id for the campaign. |