Designing and Running Pipelines

Timestamp format while reading Parquet file

Hello Team, we have a requirement to read file from S3 Bucket and there we are getting source file as ‘Parquet’ file, As Parquet file stores data in Binary format so when i converted those files with the help of Online Parquet reader file then gettin...

Conditional Execution of Snaps

I’ve got a pipeline where I would like to execute a series of snaps based on the results of a Router snap evaluation. One of the steps in that part of the pipeline is to compare the id fields of both the source and target data sources to see which r...

How to pass mapper column in Rest API filter condition

Hi, I have a requiremnet, where i need to pass the mapper Date column (which i read from oracle table) in REST API filter condition. i tried with below syntax, but it is giving error. please someone can advice here. Created gt datetime’" + $CREATED +...

Auto login to OKTA when refreshing the token

Hi guys, we have implemented secutiry in our api with okta using a token and works fine but when the token expires it won’t refresh the token automatically (even though Auto-refresh token is checked) so we have to enter to the Account(REST OAuth2 Acc...

Resolved! How to stream a binary PDF file to a file using Snaplogic

I am trying to stream a binary PDF file to a file using Snaplogic. The equivalent would be to the following command: curl “http://www.pdf995.com/samples/pdf.pdf” --output …/out/pdf.pdf Is this possible? Note the output doesn’t seem to be amenable to...

Unzip file issue

Hi everyone, I am struggling to uncompress a ZIP file. I have used ZipRead and tried to apply a Binary to Document and plugged a For Each so that I can write in a different location each uncompressed files. However, I seem not able to write the files...

Escaping Single Quotes in Error Pipeline - Issue

Fairly new SL user here. I am in the process of creating an error pipeline to handle system generated errors that may occur in our pipelines. In this error pipeline we capture the error, error reason, error resolution, snap name, and the original rec...

Detecting schema change

Here are two pipelines that everyone can relate to. Detecting schema change in an upstream data source (SQL Server in this example) and identifying the exact nature of change. Also check out our blog post on this topic. SchemaChange_SaveOriginal.slp ...

SnapLogic - Integration Nation

Forum Posts

Timestamp format while reading Parquet file

Conditional Execution of Snaps

How to pass mapper column in Rest API filter condition

Auto login to OKTA when refreshing the token

Resolved! How to stream a binary PDF file to a file using Snaplogic

Unzip file issue

Escaping Single Quotes in Error Pipeline - Issue

Detecting schema change

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

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...