Designing and Running Pipelines

ORG to ORG Project Migration Pipeline

Please find attached pipeline to Migrate Account, Pipelines, Tasks from one ORG to another in the same pod. Configurations Change the source and destination org in the pipeline parameterChange the source and destination project name. Note : All the v...

Working with Ultra Input/Output Headers, Content, Parameters, and Status Codes

For ultra, this is all you need to work with headers, content, and url parameters. Accessing a URL parameter from an Input request. All url parameters passed on the call in must be accessed in the incoming document and not like a traditional trigger....

Using the Salesforce Attachment Snap to download and insert into MySQL

Attached is a sample pipeline that connects to a Salesforce Object, downloads an attachment and inserts it into MySQL. Since the object already exists in Salesforce there is no need for a create script, but there is a script to create a sample table ...

Identifying when a Control Break occurs in a pipeline

Have you ever needed to identify when a control break occurs in your incoming data? Having this ability can save you considerable processing resources in cases where your incoming data is sorted on last names and you only need to perform calculations...

Complex XML Processing & HR Onboarding/Off-Boarding with Workday

This pipeline illustrates two of our commonly encountered customer scenarios: a) An example of complex XML processing, and b) A real world example of what HR On-Boarding/Off-boarding might look like with Workday data I have used variants of this pipe...

Useful Third Party Utilities

None of these tools are “official” or truly supported. If it breaks, you get to keep the pieces. Disclaimer aside: I need help writing JSON Path Expressions First, re-evaluate why you are writing a JSON Path Expression. Try using a mapper, or severa...

Connect to local database to test Snaplogic pipelines

This example uses MySQL installed on developer’s laptop Install MySql DB on you local machineLogin to you ISP’s routerEnable port forwarding fro the specific port - (the default for MySQL is 3306)Login to SnaplogicCreate a MySQL account and Fill in ...

Aggregation of IDs for IN clause in a Delete DB Snap

When a Database Delete (Example: SQL Server Delete) snap is used, the snap goes through each of the entries in the incoming document and makes one roundtrip to the database to delete the pertinent record. Whilst it could be argued that this is not th...

SnapLogic - Integration Nation

Forum Posts

ORG to ORG Project Migration Pipeline

Working with Ultra Input/Output Headers, Content, Parameters, and Status Codes

Using the Salesforce Attachment Snap to download and insert into MySQL

Identifying when a Control Break occurs in a pipeline

Complex XML Processing & HR Onboarding/Off-Boarding with Workday

Useful Third Party Utilities

Connect to local database to test Snaplogic pipelines

Aggregation of IDs for IN clause in a Delete DB Snap

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects

String replace method where pattern is dynamic