Designing and Running Pipelines

Resolved! Expression using isArray?

Does snaplogic support the use if isArray (or similar function)? We are hitting multiple issues across pipelines where the inbound data is sometimes simply a value and sometimes an array. Would like to be able to check this, and create the array if ...

How do I debug a python script in the script snap

I am using a script snap to use SSH to call a procedure on another server. The pipeline completes without error, but it’s not calling the procedure–and it’s not giving me any error messages, so I don’t know what is failing. Is there a way to view t...

Add 2 parameters in WHERE CLAUSE in Oracle Select

Hi, I’m trying to put 2 parameters in Where Clause in Oracle Select with “and” Below is my pipeline parameters. I put some values between ’ ’ (I don’t have to put it) Below is my pipeline and Mapper settings Below is my Oracle Select settings I cr...

How to obtain the error reason,resolution,original by the runtime ID of the pipeline

Hi, I need to send all the failures related data(reason,resolution,stacktrace…) for tracking purpose to other system. The job needs to run daily and push the error related data to other systems.But I don’t want to use error view or error pipeline. I ...

MongoDB find snap

Hi All, In one project I am using MongoDB find snap query:([{$fisrstQuery},{$second}]). i am getting $firstQuery as string instead of value it’s hold i need like this ([{“topic”:“test”},{“msgBody.title”:“MongoDB Overview”}]) plz anyone help me to re...

Resolved! Publish and subscribe

How we can implement event driven architecture with the help of snaplogic. do snaplogic have some inbuilt messaging server in place.

Append data to csv file with out repeating the header row

hi there, i am trying to append all the records for the day to that days CSV file which has date in the file name. all works fine, if it doesnt fnds the file for the day it creates the file. if it finds the files then it appends the data to the file....

How to check if a sheet exist in the excel

hi there, trying to find a solution on how to find a sheet exists in an excel file. Goal is if the sheet doesnt exist, then it will create the sheet in the excel else it should append to the existing sheet. Any help is greatly appreciated. Thanks Man...

SnapLogic - Integration Nation

Forum Posts

Resolved! Expression using isArray?

How do I debug a python script in the script snap

Add 2 parameters in WHERE CLAUSE in Oracle Select

How to obtain the error reason,resolution,original by the runtime ID of the pipeline

MongoDB find snap

Resolved! Publish and subscribe

Append data to csv file with out repeating the header row

How to check if a sheet exist in the excel

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

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...