Retrieve and modify campaigns.
Table Specific Information
The provider will use the Salesforce Pardot API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the provider.
- Id supports '=', '<', '<=', '>', '>='.
- Name supports '='.
- CreatedAt supports '=', '<', '<=', '>', '>='.
- UpdatedAt supports '=', '<', '<=', '>', '>='.
For example, the following queries are processed server side:
SELECT * FROM Campaigns WHERE Id = 43 SELECT * FROM Campaigns WHERE Name = 'Website Tracking'
This table does not have any required attributes when performing an insert.
Pardot ID for this campaign.
Cost associated to the campaign.
The CRM FID associated to the campaign.
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Filter by the creation time.
Filter by the modification time.