Designing and Running Pipelines

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?

Convert json to xml

Hello, I would like to know the best way to convert json list of accounts to an xml repeating element like below- “accounts”:[ “10”, “9”, “8”, “7”, “6”, “5”, “4”, “3”, “2”, “1” ] to ns1:AccountIds ns2:long10</ns2:long> ns2:long9</ns2:long> ns2:long8<...

SnapLogic - Integration Nation

Forum Posts

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

Convert json to xml

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