Designing and Running Pipelines

Change Data Capture from Workday

This is often a requirement from a variety of Workday customers to extract data within a time range i.e. extract data that was changed 7 days ago or 2 days back or even within the last day. Classic examples are: Terminations within last 90 days or 3...

ServiceNow - Outbound REST with a Business Rule

Using ServiceNow (SNOW) Outbound REST and Business Rules with SnapLogic. This document defines the steps required to create a Business Rule and REST Endpoint in ServiceNow that will call a SnapLogic pipeline. Business rules allow the user to define c...

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...

SnapLogic - Integration Nation

Forum Posts

Change Data Capture from Workday

ServiceNow - Outbound REST with a Business Rule

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

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

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...