Designing and Running Pipelines

Resolved! Map Json Structure

Currently we have json data like this : { “Test”: “1” “SerialNumbers”: { “SerialNo”: [ “123”, “456” ] } The desired output is like this: { “Test”: “1” “SerialNumbers”: [ {“SerialNo”: “123”}, {“SerialNo”: “456”} ] } Is there any function we could use ...

SIngle log file

I have a pipeline which updates records between systems. The pipeline runs on a schedule and some records are not getting updated. Hence I want to create a log file which is written to everytime the pipeline runs. The log file would hold the date/t...

Replace value according to its poition

Below is the Input [ { “@id”: “2”, “col”: [ { “@id”: “2”, “@transable”: “yes”, “$”: “Replace1” }, { “@id”: “3”, “@transable”: “no”, “$”: “Replace2” } ], “group”: [ { “A”: “A1”, “B”: “B1”, “C”: “C1”, “D”: “D1”, “E”: "E1 ", “F”: “F1”, “G”: “G1”, “H”: “...

Resolved! How to filter files from directory

Hi Snaplogic experts, iam struggling with one task - get two files from source directory and process them (everything works fine if both files are there or one of the files is in directory) My problem is - if both files are not presented, send an em...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Map Json Structure

SIngle log file

Replace value according to its poition

Resolved! How to filter files from directory

"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

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