Created by Chris Ward, SnapLogic
This pattern provides the ability to integrate with Pardot’s async batch APIs allowing customers to import Prospects into their Pardot instance.
Sources: SQL Server. Can be changed to another source by swapping out the SQL Server Select for another Snap
Targets: Salesforce Pardot Prospect
Note: Pipelines in this pattern use the expression library file pardot-config.json.
Pardot_Prospect_Batch_Process
Configuration
Snaps used: SQL Server Select, Mapper, Group By N, Pipeline Execute (calling the pipeline Pardot_Prospect_Orchestration)
Pardot_Prospect_Orchestration
Configuration
Snaps used: Pipeline Execute, Head
This pipeline calls a series of other pipelines:
- Pardot_Prospect_Generate_CSV
- Pardot_Prospect_Open_Batch
- Pardot_Prospect_Add_Batch_Child
- Pardot_Prospect_Update_Batch_Child
Pardot_Prospect_Generate_CSV
Configuration
Snaps used: Mapper, JSON Splitter, CSV Formatter, File Writer
Pardot_Prospect_Open_Batch
Configuration
Snaps used: JSON Generator, REST POST, Mapper
Pardot_Prospect_Add_Batch_Child
Configuration
Snaps used: REST POST, File Delete, Mapper, Union
Pardot_Prospect_Update_Batch_Child
Configuration
Snaps used: REST Patch, Mapper, JSON Formatter, File Writer, Union
Pardot_Prospect_Check_Batch_Status
Configuration
Snaps used: Directory Browser, Copy File Reader, JSON Parser, REST Get, Router, Tail, Join, File Delete, Mapper, Document to Binary, File Writer
Downloads
Pardot_Prospect_Batch_Process.slp (7.8 KB)
pardot-config.json (233 Bytes)
Pardot_Prospect_Orchestration.slp (8.8 KB)
Pardot_Prospect_Generate.slp (6.6 KB)
Pardot_Prospect_Open_Batch.slp (7.1 KB)
Pardot_Prospect_Add_Batch_Child.slp (7.9 KB)
Pardot_Prospect_Update_Batch_Child_.slp (9.1 KB)
Pardot_Prospect_Check_Batch_Status.slp (23.8 KB)
