Designing and Running Pipelines

Resolved! Sum in a loop

Hi, I have an default value for field $sum=390 and 10 input records(count may increase/decrease). Requirement :Each row should get $sum=$sum+10. if 1st row having sum=400, 2nd sum=410… Please suggest.

Retrieve the details of executing pipelines in another pipeline as an input

The purpose is to create a logging pipeline that stores the info of executing pipeline in a file format. Logging pipeline shall receive the following as inputs Executing master pipeline name (required)Executing master pipeline Id (required )Execu...

Zip File Write

Hi Team, I am trying to write a zip file with data as CSV formatted with file name as exteact.zip. I was able to write it as zip file but when i extract it i see a file inside with input0. But I don’t want this input0 to be inside the zip instead i w...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Sum in a loop

Retrieve the details of executing pipelines in another pipeline as an input

Zip File Write

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

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

Do JSON mapping in a single mapper

Problem with nested mappings