Designing and Running Pipelines

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

Restaurants bill software

This is an experiment pipeline to generate the Restaurant’s bill according to the ordered items vs menu. Here’s the image of the pipeline and attached is the pipeline. Restaurants bill software_2017_02_18.slp (16.7 KB)

SnapLogic - Integration Nation

Forum Posts

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

Restaurants bill software

Nest the document under another document

optional field on mapper

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...