Designing and Running Pipelines

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

Read multiple files in chronological order from S3 bucket

Hi SnapLogic team- Our requirement is to process multiple files that reside on S3 bucket. The trick is to process the files in chronological order (based on file creation date). Could you please let me know what snap we could use in order to achieve ...

Output preview not available for Inner Join

Hi Team, I’m using an Inner Join and observing that the output preview doesn’t appear. Is this an expected behaviour? I however, have access to the data I’m expecting out of Inner join (as I’m writing to an excel file) but using a mapper after Inner ...

SnapLogic - Integration Nation

Forum Posts

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

Read multiple files in chronological order from S3 bucket

Output preview not available for Inner Join

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

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap