Designing and Running Pipelines

JDBC Execute Snap

Hi All, We are facing the below error message when we use the JDBC Execute Snap. Can you please help us out with the error. We are trying to capture the value in @result. It is not returning the value instead we are getting the Status as -2 and Mess...

Error View : State always captured as 'Completed'

Hi all, We are trying to use the Pipeline Monitoring API in our implementation to trace which of the service calls have failed, using e.g. ___https://elastic.snaplogic.com/api/1/rest/public/runtime/Partners?last_hours=100&state=Completed,Failed,Stop...

How to log the Raw request sent by HTTP Get snap to end point?

I have a HTTP GET snap to send requests to Zendesk API. But sporadically, it fails saying “REST API service endpoint returned error result: status code = 422, reason phrase = Unprocessable Entity, refer to the error_entity field in the error view doc...

CLI for BCP (SQL SVR) and dynamic file names

The scenario I needed to accomplish was to pull data from SQL server, group the data sets together based on different fields and then dynamically define the file name based on those groupings. Performance was the #1 consideration and competitive tool...

Allow pipeline execution on the basis of expression result of previous snap

How can I allow a pipeline to continue execute/not execute on the basis of the result of expression value of previous snap. For example: I wan to continue pipeline execution only if there are some records exists in the csv file which I read in previo...

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

SnapLogic - Integration Nation

Forum Posts

JDBC Execute Snap

Error View : State always captured as 'Completed'

How to log the Raw request sent by HTTP Get snap to end point?

CLI for BCP (SQL SVR) and dynamic file names

Allow pipeline execution on the basis of expression result of previous snap

Challenges With Slow Match Snap Levenshtein Comparisons

How to Unzip tar.gz file

Resolved! Reusable pipeline with Aggregate / Group by fields

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...