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

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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