Designing and Running Pipelines

Resolved! Appending DateTime stamp with the filename in FileWriter snap

I am reading file and finally wanted to load data to new file with file name contains name of output file along with the datetime stamp. Using below expression to achieve the same but getting error. Please help.

Challenges With Slow Match Snap Levenshtein Comparisons

We are using the Match Snap to do fuzzy-comparisons and match Customer records without a unique primary key. This particular Snap is in the ML Data Preparation Snap pack. We traced a bottleneck to uses of the Match Snap that are using the Levenshtei...

How to Unzip tar.gz file

How to unzip tar.gz file? Zip File Read snap is not working for tar.gz files. I am trying decompress snap but I am not sure how to get individual files from the output of Decompress.

Resolved! Reusable pipeline with Aggregate / Group by fields

Is it possible (and how) to build reusable pipelines with Aggregate / Group by fields, where the “group by” clauses are dynamic (and the number of clauses is provided as a list in the document). I’ve been trying this with something as follows, but it...

Getting error in csv parser when connected to Decompress snap

Hi, I am trying to read multiple zip files from S3 location using Directory browser-> S3 File reader → Decompress → csv Parser. Currently I have 2 zip files in the location which I could see till decompress preview. But csv parser is failing with bel...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Appending DateTime stamp with the filename in FileWriter snap

Challenges With Slow Match Snap Levenshtein Comparisons

How to Unzip tar.gz file

Resolved! Reusable pipeline with Aggregate / Group by fields

Getting error in csv parser when connected to Decompress snap

Resolved! Expression for Router

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

Decompressing and reading WINDOWS zip files

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