Designing and Running Pipelines

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

Snowflake Bulk Upsert

Hi Snap Gurus, Good day, is there a way to set Snowflake Bulk Upsert “Key Columns” property dynamically? An array of string or comma-delimited maybe? Thanks, M

Snowflake Bulk Load is giving error =Table does not exist in the database

Snowflake Bulk Load is giving error Cannot find table : “schemaname”.“tablename”, reason=Table does not exist in the database, resolution=Ensure the provided table exists in the database. If I change use Snowflake Insert Snap in place of Snowflake Bu...

SnapLogic - Integration Nation

Forum Posts

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

Snowflake Bulk Upsert

Snowflake Bulk Load is giving error =Table does not exist in the database

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