Designing and Running Pipelines

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

Same column names in dat file

Hi, I have pipe limited dat file. I am using csv parser to get columns. The dat file has same column name(description) more than once but value is different eg- id name company cd description job description department description orgunit description...

Writing data into splunk

how to write data to splunk?

SnapLogic - Integration Nation

Forum Posts

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

Same column names in dat file

Writing data into splunk

Only execute child pipeline if BigQuery result is ...

Create a date range by hour

SOAP execute snap vs REST post/Http client snap

Transpose columns(Dynamic) into rows.

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