MuleSoft Connector for Salesforce Marketing Cloud

Build 20.0.7654

Campaigns

Create, update, delete and query Campaigns.

Table Specific Information

Select

Select all campaigns:

SELECT * FROM Campaigns

Retrieve a specific Campaign:

SELECT * FROM Campaigns WHERE Id = '3130'

Insert

To create a campaign, you will need to specify at least the Name column.

INSERT INTO [Campaigns] (Name, Description, CampaignCode, Color, Favorite) VALUES ('Test Camp', 'Test Description', 'tst 001', '0000ff', true)

Update

Update operations are not supported for this table.

Delete

Campaigns may be deleted by providing the CampaignId of the campaign and issuing a DELETE statement.

DELETE FROM [Campaigns] WHERE Id = '5161'

Columns

Name Type ReadOnly References Filters Description
Id [KEY] Integer True =

The Id of the Campaign.

Name String False

Name of the Campaign.

CampaignCode String False

The Campaign code.

Color String False

The Campaign color.

Favorite Boolean False

True if marked as favorite Campaign.

CreatedDate Datetime False

The exact time when the Campaign was created.

ModifiedDate Datetime False

Last time the Campaign was updated.

Description String False

Description of the Campaign.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654