Designing and Running Pipelines

Resolved! Expression for Router

I have a Router snap which evaluates whether an ID exists for records returned in a Salesforce Read Snap. Some of these have an ID, others do not. Right now in the Router snap I have an expression for those that does, '$Id != null, but I can’t work o...

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 - Integration Nation

Forum Posts

Resolved! Expression for Router

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

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file