Designing and Running Pipelines

Converting local UK dates in to UTC ISO formats

Hi I am looking to take a local UK format DATETIME and convert it to an ISO UTC format Currently I am parsing the date using a substring() in to LocaleDateTime.parse($inputStrings) to create a snaplocaledate value When I try to parse the value out as...

How to cite entries in an array of JSON (position of entries is not fixed)

Hi, Below is just an example JSON: { "entity": { "entries": [ { "ID": "1", "Pipeline": "Pipeline_Completed", "Numbers": "10" }, { "ID": "3...

Design Approach for Downloading SLDB saved files using smb

Hello, looking for input regarding best approach to automate the manual download of various types of files (.csv, .xlsx, .zip) which are saved in the same project folder. We want to keep them available in Snaplogic but also download to another server...

"JSON Splitter" snap truncate data!

Is there any limitation of data size that “JSON Splitter” snap can handle? I get a 36mb json as input and output less than 1mb. I noticed “JSON Splitter” simply truncates the data!!! Ideally it should not but it is happening!!! Anyone find such odd b...

Resolved! Zip file write snap creating zip file with source folder structure , how to avoid file structure

Hi Team, I am just reading the file from source location and writing the zip file in sldb, but it is creating the zip file with source structure when i unzip. source file path is : /home/data/interface/inbound/filename.txt when I unzip it, it has fol...

$ in sql statement

I have a sql statement in snowflake execute snap. “copy into table table_name from (select t.$1, t.$2, t.$3 from file x(file_format=>'csv_format)t)” I keep getting errors because of $ in the sql. Can anyone suggest how to enclose $ in the sql

How to get last 30 dates

I have to pass the last 30 dates pipeline for execution. so how i can get the last 30 dates

How to call the parameters already in the existing pipeline and their values in the rest get snap url

I have called the Client name parameter in the existing pipeline ,That you can see the snap shoot Currently, the main agenda is As I call the URL in the rest get snap I receive the username and in the same way I must receive the client name in the r...

SnapLogic - Integration Nation

Forum Posts

Converting local UK dates in to UTC ISO formats

How to cite entries in an array of JSON (position of entries is not fixed)

Design Approach for Downloading SLDB saved files using smb

"JSON Splitter" snap truncate data!

Resolved! Zip file write snap creating zip file with source folder structure , how to avoid file structure

$ in sql statement

How to get last 30 dates

How to call the parameters already in the existing pipeline and their values in the rest get snap url

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