Designing and Running Pipelines

Py Script snap

I am building a pipeline which need to make recurring API call and consolidate the result. But when I call the API inside py script snap then it does not return result as the API default result. I tried to use two methods of get as get.getResponseBo...

How to Insert All Records but if there's an error then insert none

Hello, If I have 3 records that I want to insert into my database table, I use the “SQL Server - Insert” snap. However, if there’s 1 record that has an error (like let’s say one of the values has text in an int column), the 2 other records still cont...

Getting index value from an array value

Wondering if someone could answer this question for me. Given the below array, how would I get the index number of $arrayField.name ===“Alex”? I can easily get the index of true and false by respectively doing this: $arrayField.indexOf(true) and $ar...

Is there a way we can parameterize repartition snap in SnapLogic Extreme?

Hi, We’ve have Extremeplex child pipeline that runs on Iterations. Based on user inputs we want to dynamically generate the no of Output files for each iteration, rather than specifying static value in Repartition Snap. I’ve also uploaded a snapshot ...

How to Transform SQL Server Records to JSON usable format

I am querying transactions_table and batch_table using SQL Server Execute snap. The batch_table returns 1 record, and in this example the transactions_table returns 2 records. I need to be able to pull the data into a JSON-format that is compatible w...

Retrieve Filename into Mapper from Box Read

How can I catch the Filename “Box Read” Snap opened into the “Mapper” snap?

Trying to validate JMS account for IBM MQ

I’m trying to configure a JMS Producer that will communicate with a client’s WebSphere MQ, v9.1 (I think). I’ve received the jar files from the client’s lib directory, and that list of files resembles, but is not identical to, the list suggested in h...

Snaplogic integration with Azure Devops

Hi, Need to know how to integrate SnapLogic and Azure Devops to ensure that all code review goes through Azure Devops. Regards, Achyuth G.

SnapLogic - Integration Nation

Forum Posts

Py Script snap

How to Insert All Records but if there's an error then insert none

Getting index value from an array value

Is there a way we can parameterize repartition snap in SnapLogic Extreme?

How to Transform SQL Server Records to JSON usable format

Retrieve Filename into Mapper from Box Read

Trying to validate JMS account for IBM MQ

Snaplogic integration with Azure Devops

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