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 connector 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 connector.
- 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. |