Designing and Running Pipelines

What is the correct syntax for regular expression in Snaplogic

Hi snaplogic Experts, what is the right syntax for regular expression ^([^;]*;){6}[^;]{7}\K. if i want to use it in replace function? because this one: $myString.replace(^([^;]*;){6}[^;]{7}\K., ‘’) doesnt work are there any escape characters or s...

The 'something in $' expression

What do the expressions below mean, specifically the ‘in $’ What is $?

Unable to get all records from mysql database in Generic JDBC execute or Select snap

Hello, I am seeing a different behavior in Generic JDBC execute or Select snap when it has upstream and downstream. I have a table with 10000 records and the query used in both snaps is "select * from . where pipl id =‘1’ " and this query is giving s...

Snowfalke Execute Behaving strangely

I’ve a pipeline, at the end of which is a SnowFlake Execute snap which has an update query like below "Update table_schema.Employees set Salary = '"+ $salary + "' where EmpID = '" + $empId +"' " Now the issue is for all the employees Salary of last ...

Resolved! Accessing Data from previous snaps

Is there a way to access data in the mapper snap in my salesforce soql snap which is right after salesforce update snap

How to access Parameters passed in pipeline in the mapper snap

Hi, I am passing instanceUrl as a parameter in pipeline paremeters. But I am not going to use this in first snap of my pipeline. How can i access this parameter value in my mapper snap? I only have access to the data thats being queried in my mapper ...

Resolved! Splitting csv file into rows and then check if specified value has 10 elements

Hi snaplogic experts, how can i split csv file into rows and then check if value after 8th semicolon has 10 values? 1;2566;28.3.2023;28.3.2023;10;10;15;11;1,2,3,4,5,6,7,8,9,10;Eur;Euro;USD 2;2567;28.3.2023;28.3.2023;10;10;15;11;1,2,3,4,5,6,7;Eur;Eu...

Resolved! Failure: Unable to write to JSON-Path

JSON Path Test_2023_03_28.slp (6.4 KB) GOAL: Set up a mapper to write input document structure to new structure, deleting some paths, and renaming others. ERROR: “Failure: Unable to write to JSON-Path: $.ACHData.employeeId, Reason: Expecting object f...

SnapLogic - Integration Nation

Forum Posts

What is the correct syntax for regular expression in Snaplogic

The 'something in $' expression

Unable to get all records from mysql database in Generic JDBC execute or Select snap

Snowfalke Execute Behaving strangely

Resolved! Accessing Data from previous snaps

How to access Parameters passed in pipeline in the mapper snap

Resolved! Splitting csv file into rows and then check if specified value has 10 elements

Resolved! Failure: Unable to write to JSON-Path

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