Designing and Running Pipelines

Need a null check or exists check for this Mutiple vs single typeof

[image] I think I need another check to see if this node actually exists in the json or payload. I have tried hasOwnProperty() and hasPath() Any other suggestions? typeof $[‘wd:Submit_Published_Course_Section_Request’][‘wd:Published_Course_Section_D...

Table creation when sending mail

Hello, I was designing a pipeline which includes salesforce upsert and deletion . Obviously error view will be captured for the upsert and deletion operation and while sending the mail along with sending the file we decided to incorporate the values ...

Router not routing?

I have a simple pipeline where I’m using Router to decide if an oracle procedure should be called. Even if I just set the router expression to false for the output0 view, the output0 snap (the oracle procedure), is still being executed. I’ve tried ...

Execute different pipeline depends on condition

Hi, I’m trying to build a pipeline to execute 2 different pipelines depend on their conditions. There is Conditional snap, but that only allows to executed within the same pipeline. Do you know how I can do this? Thank you

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

SnapLogic - Integration Nation

Forum Posts

Need a null check or exists check for this Mutiple vs single typeof

Table creation when sending mail

Router not routing?

Execute different pipeline depends on condition

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

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