Designing and Running Pipelines

Using Oracle Execute to run complicated SQL Select not returning any data

I’m new to SnapLogic and was told by one of our senior SL developers that instead of using the Oracle Select snap, I could use the Oracle Execute snap to run a complex SQL select statement. When I try to do that though, I get no data and I can’t fig...

How to write an empty CSV file

I am looking for solution on how to write an empty data with headers csv file. I have a Oracle snap that execute a query then output to a csv file. I still want the csv file to be produced even the query returns zero record. Here is my pipeline

Create project based on a JSON snaplogic file and replace path

Hi all, I’m currently trying to build a pipeline which read .txt project file then replace a path based on a mapping table. exampe: Read project file - > based on project name find a specific path and replace with target path - > create project with ...

Cache Issue & In memory issues in Ultra

Hi, Below is the requirement Accept input JSONFetch Credentials from credential store (Centrify)Run POST API to connect to DocuSign and create Envelope. We have built 2 approaches to solve our requirement and We are facing cache issue while running t...

How to write current date - 1 expression

in standard process, Current date -1

Error Pipeline: How to get Snap name causing error in Main Pipeline

I am using Error Pipeline parameters in the main pipeline to get the pipeline name and snap name which causes error. When I tried to use snap.label, it’s throwing below error. "Failed to evaluate expression for pipeline parameter: snap – snap is unde...

How do you keep only one record of duplicated records?

My pipeline is a simple pipeline that execute an Oracle query then parse the data to a CSV file. The result of the query gives some of the duplicate records (Same ID), that because the database has those duplicates. However, I just want to keep only...

Session Start / End Alert Notification Email

Hi Team, We have set the Session start and Session end alerts in the Snaplogic UI and we started receiving notifications like below. We would like to know what is this IP address means and when is this email getting triggered. Is this email triggered...

SnapLogic - Integration Nation

Forum Posts

Using Oracle Execute to run complicated SQL Select not returning any data

How to write an empty CSV file

Create project based on a JSON snaplogic file and replace path

Cache Issue & In memory issues in Ultra

How to write current date - 1 expression

Error Pipeline: How to get Snap name causing error in Main Pipeline

How do you keep only one record of duplicated records?

Session Start / End Alert Notification Email

What account should be used for API with query par...

How to dynamically update an account?

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