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

Nest the document under another document

optional field on mapper

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...