.png){kind=logo}
Pardot Output
-
DarkLight
Pardot Output
-
DarkLight
This article is specific to the following platforms - Snowflake.
Pardot Output
The Pardot Output component uses the Pardot API to write back the contents of a source table (or view) from their cloud data warehouse (CDW) into a table in Pardot.
Important Information
Please be aware of the following:
1. The Column Mappings property will fail to validate if the following columns are not mapped:
- campaign_id
2. Where any data is wrapped in quotation marks " ", the quotation marks will be encoded and sent to Pardot.
3. When a record is created with the columns campaign_id, email, and Salesforce_FID, you can update the record using either:
- campaign_id, email, and Salesforce_FID, OR
- campaign_id, email
4. However, when a record is created with the columns campaign_id and email, you can update the record with only the following:
- campaign_id, email
5. An error will occur if you send a blank Salesforce_FID to a record that was created using only campaign_id and email. The error message will cite "No CRM is provided".
6.The following fields (columns) are read-only, and Pardot cannot write to them:
- created_at
- crm_last_sync
- crm_url
- is_archived
- last_activity_at
- opted_out
- recent_interaction
- updated_at
Warning: this component is potentially destructive. The output operations performed by this component can delete, overwrite, and truncate target objects within Pardot, and these operations may be irreversible.
Properties
Snowflake Properties | ||
|---|---|---|
| Property | Setting | Description |
| Name | String | A human-readable name for the component. |
| OAuth | Select | Select an OAuth entry to authenticate this component. An OAuth entry must be set up in advance. For help, read Pardot Authentication Guide. |
| Business Unit Id | String | Your Pardot Business Unit ID. To learn more, read Authentication. |
| Database | Select | Select the Snowflake database. The special value, [Environment Default], will use the database defined in the Matillion ETL environment. For more information, read Databases, Tables, & Views. |
| Schema | Select | Select the Snowflake schema. The special value, [Environment Default], will use the schema defined in the Matillion ETL environment. For more information, read Database, Schema, & Share DDL. |
| Source Table | Select | Select the source table to be output to Pardot. The chosen source schema determines what tables will be available for selection. |
| Target Object | Select | The Pardot object (table) into which local data will be loaded (input). Users can choose Import API (For Prospects). |
| Output Operation | Select | Select the output operation to be performed on the target object. Users can choose Upsert. |
| Column Mappings | Source Columns | Specify the columns in the source table that will be unloaded (output). |
| Target Columns | Specify columns in the target object where the source columns will be output to. | |