Designing and Running Pipelines

Insert Header and Footer Rows to the CSV/TXT file

Greetings to the community ! @koryknick I have a requirement to build the txt file which has the format of Header,Body,Footer rows as shown in below screenshot. I can able to build the body rows reading from SQL DB and formatting with CSV formatter....

Workday call returns error "Problem writing SAAJ model to stream: Output operation aborted"

Hello Team, Recently we started getting an error when we are trying to post data to Workday using the “Workday write” snap. It was working fine earlier but now its failing intermittently with the error “Problem writing SAAJ model to stream: Output op...

Resolved! Get certain values of strings in array

Hi all, I am trying to get the value between the ‘()’ of every record inside the array. [ { “betroffene IT Systeme”:[ “Ardoq·(431)” “SnapLogic·(580)” ] } ] So that I get an array: [ { “betroffene IT Systeme”:[ “431” “580” ] } ] My expressions languag...

Distinct results while saving/validating pipeline vs executing pipeline

Hi Team, Lately, I observed distinct results getting generated during compile time (i.e. saving a pipeline) vs run time (i.e. executing a pipeline). Has anyone observed this behavior? For instance, consider a simple example of reading a flat file, do...

Passing Timezone to Triggered Task

I know there is a way to pass timezone using schedule task but is there a way to pass timezone for a triggered task?

Resolved! Improper result after Copy/Mapper output

Hi, Can anyone pls help me why the values after copy snap getting changed without any transofrmation as shown in below pics. In place of copy snap i used mapper also. Then also showing incorrect values for the Order quantity and Order value. Below ...

Write file to US-ASCII file format

Hello Experts , I’m trying to write file in US-ASCII file format. i have used mapper–>binary copy–>transcoder–>file writer snap. Mapper has input string and binary output. Binary copy snap to make copy of result of mapper. transcoder snap with settin...

Elegant way for String interpolation

Hello, I’m wondering if there is any elegant way in the Snaplogic Expression Language to achieve String interpolation? E.g. similar to f-strings in Python? f"This is a test string including a {variable}" The method I’m using at the moment is string ...

SnapLogic - Integration Nation

Forum Posts

Insert Header and Footer Rows to the CSV/TXT file

Workday call returns error "Problem writing SAAJ model to stream: Output operation aborted"

Resolved! Get certain values of strings in array

Distinct results while saving/validating pipeline vs executing pipeline

Passing Timezone to Triggered Task

Resolved! Improper result after Copy/Mapper output

Write file to US-ASCII file format

Elegant way for String interpolation

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

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error