Designing and Running Pipelines

How to unzip a password protected zip files in S3 bucket

Hi Team - Can someone guide me to unzip a password protected zip file on the S3 location or have a sample pipeline to achieve this functionality ? I am trying to use the ZipFile Read snap but it is not working as it doesn’t have any option to provide...

Read jpeg files in batch from sftp server

Team, Can I read jpeg files in batch from the sftp server in Snaplogic and write the same to target sftp location in batch after doing file name renaming. For Example, my sftp source location has 5000 files, but I need to read 1000 files rename the f...

Resolved! Convert xml attribute to xml element in Snaplogic

Team, I am looking for a solution in snaplogic to convert the xml attribute to xml element. My xml looks like this, Bloodroot Columbine Thanks, Dhivya Aroma

Array element assignment from one segment to other when length of array is dynamic

Here is the sample challenge, below is input and expected output. items can increase dynamically, but the “WORK” field of REFILL should get assigned under NAME field of TOTLITEM. input payload : [ { “REFILL”:{ “item”:[ { “ITEM”:“1”, “TEXT”:“first”, “...

Is Jolt Json and JSON Velocity Transformer similar or different?

Hi, I need to do some very complex transformation on dynamic JSON payload via snaplogic prior to posting at the endpoint. can similar to JSON jolt, such operations are done through velocity? or it’s different? (through velocity supported snap such as...

Resolved! Populate Aggregate snap with Pipeline Parameter

So I’d like to use the value of a pipeline parameter as the field in the Aggregate snap. Can this be done, and if so, how?

Resolved! Joining hierarchical data

Hi, I have an excel with the data in the below format Rows at level 1 is a parent to the next subsequent rows at Level 2. For ex: Development (row 2) is parent to Java, dotnet, php (rows 3,4,5) Testing (Row 6)i s parent to Manual, Automation, Load...

Architecture: Pipeline Execution Mechanism - Some Questions

How does the SnapLogic Control Plane identify a specific node in a Snaplex for executing a pipeline? How does it identify if a node is busy? Is it only checking one time for the node’s availability? This is a continuous process: When a node is fired ...

SnapLogic - Integration Nation

Forum Posts

How to unzip a password protected zip files in S3 bucket

Read jpeg files in batch from sftp server

Resolved! Convert xml attribute to xml element in Snaplogic

Array element assignment from one segment to other when length of array is dynamic

Is Jolt Json and JSON Velocity Transformer similar or different?

Resolved! Populate Aggregate snap with Pipeline Parameter

Resolved! Joining hierarchical data

Architecture: Pipeline Execution Mechanism - Some Questions

Trim and convert string into Date

How to output the SQL statement that was executed ...

How to identify if there are no files in the sourc...

Decode column name that has @ as a prefix

Cannot call parameter in the error pipeline

Formatting CSV data for XML output

Get MIN (oldest) or MAX (most recent) date from ar...

Line Break in Mapper

how to filter out spaces

Expression to extract values in nested JSON object...