Designing and Running Pipelines

Questions on using the SQL Server – Merge snap, where is WHEN MATCHED logic?

Hello, I’m a new user to Snaplogic, so go easy. My question is on using the “SQL Server – Merge” snap: I’ve created a pipeline to import from a sftp csv-formatted source to merge (update or insert) into a table on an SQL server database. It’s partia...

Decompressing and reading WINDOWS zip files

Here is a pipeline that reads a .zip file, decompresses (unzips) it and parses it contents. Please note that our current “Decompress” Snap only supports BZIP2, GZIP and DEFLATE. Binary to Document Snap Encode or Decode property is set to NONE Mappe...

How to achieve below one : merging documents

Hi All, How to achieve this in snaplogic . I tried using different snaps like joiner,union,group by , but none is giving desired output. Input: [ { “filename”: “a1.dat”, }, "filename": "a2.dat", }, { “count”: 2, “type”: “pdf” } ] expected output is:...

Resolved! Downloading a base64 zip file using SOAP

Hi All, I am trying to use SOAP call to download a zip file. However, I cannot download and get the file I need correctly. Here is a screenshot of my pipeline. I took out the $content, which contains a string that is (at least looks like) base64 enc...

Resolved! Jsonpath - how to use parameters or variables inside a jsonpath

Using jsonpath as the expression in a mapper snap the following works: jsonPath($, “$entity.items[?(@.AssignmentNumber==‘E3163300-2’)].links[*]”).find(x=>x.name == ‘assignedPayrolls’).href I want to pass in the assignment number from a parameter but ...

Loading multiple zip files from S3 to data base

Hi, I am working on a scenario where I have multiple zip files from same S3 bucket location with file name as Upload* wildcard. I tried below snaps but it’s not working. Any tips? Multi file reader → Binary to document → Mapper → Zip file reader Dire...

Extract transaction sets from text data

HI I have the below 810 EDI formatted text data that I am needing some assistance with. Each transaction set begins with “ST” and ends with “SE”. I am need to extract each of the two transaction sets individually so I keep each “set” together for fur...

Snaplogic Generic JDBC

Hello, I’m having a small problem with the timestamp between the results coming from Snaplogic Generic JDBC and SQL Teradata SQL assistant. Main issue is that the timestamp in Snaplogic results shows a different time compared to Teradata SQL assistan...

SnapLogic - Integration Nation

Forum Posts

Questions on using the SQL Server – Merge snap, where is WHEN MATCHED logic?

Decompressing and reading WINDOWS zip files

How to achieve below one : merging documents

Resolved! Downloading a base64 zip file using SOAP

Resolved! Jsonpath - how to use parameters or variables inside a jsonpath

Loading multiple zip files from S3 to data base

Extract transaction sets from text data

Snaplogic Generic JDBC

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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