Designing and Running Pipelines

Parameterizing Snowflake query in Snaplogic

I am trying to execute a Snowflake query to fetch some columns data in a table using Snowflake Execute snap. Select “id”, “user_name”, “user_location”, “user_email” from t_user where “user_location” = ‘Chennai’ order by “id”; Now in the above query I...

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

SnapLogic - Integration Nation

Forum Posts

Parameterizing Snowflake query in Snaplogic

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

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