SSIS Components for Mailchimp

Build 24.0.9060

CampaignFeedback

A summary of the comment feedback for a specific campaign.

Table Specific Information

SELECT, INSERT, UPDATE, and DELTE are supported for CampaignFeedback.

Select


SELECT * FROM CampaignFeedback

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060