Designing and Running Pipelines

"Cannot drop here" while trying to put multiple "Router" snaps as "Diff"'s outputs

While trying to arrange several snaps with multiple inputs (e.g. Router) as outputs for a snap with multiple outputs (e.g. Diff), I get the following message and cannot continue. “Cannot drop here Drop in another blank area. Snaps cannot be dropped ...

Oracle Insert Snap - BatchUpdateException: ORA-01438

We’re using Oracle Insert Snap with an Oracle Thin Account. We have the Fetch Size and Batch Size properties of the account set to 5000. We’ve been successfully using the account with this configuration to load millions of rows to different target ta...

Resolved! Rest Post multipart/form-data

Hi there, I am trying to upload a file to a REST post web service. From the developer guide here is a code sample: and the parameters. I have tried passing an encoded base64 string using binary to document, but looking at the code sample, the web s...

How to return all pipelines and their status under one project space

Just wondering if there is an API call I can make that would return all of the pipelines and their last run status under a give project space. I’ve changed the names below for confidentiality reasons. Yes, I have used Craig’s project to return all p...

Ultra lineage

I’m confused about the concept of maintaining lineage in an ultra pipeline. Specifically what’s needed to maintain lineage? And, what types of actions will break lineage? Is there any documentation that better explains this? I’ve created a simple ult...

Designing a pipeline to route depending if there is or is not data in an initial query

Hi, I am trying to design a pipeline where it initially will pull in a query result set. I am trying to create a route that identifies whether the query result set returned records or did not return records. Any idea on how to design this pipeline?

How to create zip with multiple xml file

Hello Experts, I’m trying to create zip file which will have 2-3 xml file. for eg abc.zip zip file will contain a.xml,b.xml,c.xml. b.xml,c.xml are constants file that i have to add to abc.zip file. a.xml is created through snaplogic pipeline. Regards...

Filter and Edit a JSON with a touch of data manipulation

Hi, I need to amend some data for a specific table flowing through one of my pipelines This specific json contains multiple values for example: L_TYPE “A” L_TYPE “A” L_TYPE “A” L_TYPE “B” L_TYPE “B” L_TYPE “B” L_TYPE “C” L_TYPE “C” L_TYPE “C” L_TYPE ...

SnapLogic - Integration Nation

Forum Posts

"Cannot drop here" while trying to put multiple "Router" snaps as "Diff"'s outputs

Oracle Insert Snap - BatchUpdateException: ORA-01438

Resolved! Rest Post multipart/form-data

How to return all pipelines and their status under one project space

Ultra lineage

Designing a pipeline to route depending if there is or is not data in an initial query

How to create zip with multiple xml file

Filter and Edit a JSON with a touch of data manipulation

What account should be used for API with query par...

How to dynamically update an account?

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