Pardot Prospect Import

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)