Designing and Running Pipelines

Is_number() equivalent

i am getting the input value from the flat file. i am reading all the column values and have to load in the target table only if it is a number. Can i know is there any built-in function to validate or handle this.

Error : Linkage error for Snap[com.snaplogic.snaps.rest.Get]: Bad type on operand stack

Intermittent error while executing REST Get snap Failure: Unable to initialize snap, Reason: Linkage error for Snap[com.snaplogic.snaps.rest.Get]: Bad type on operand stack Exception Details: Location: com/snaplogic/snap/api/xml/XmlUtilsImpl.getMappe...

SOAP Session Token Create - How to send encrypted Credentials

I am using SOAP Execute to call a SOAP webservice Operation which generates a session token to be used in subsequent calls. The webservice requests Username, password and APIKey - I can setup a mapper and pass these parameters as clear text, but I am...

Write file to active node on hadoop server

I have a pipeline with file reader snap writing to hadoop server. The pipeline is aborting with below error: reason=Possible reasons can be failure in URL connection or file access denial, detail: Operation category READ is not supported in state sta...

Pipeline/snap to load swagger of foreign apis

Looking for one to use with rest snap

How to send output data as JSON from script snap

Hi, I am doing some transformation in script snap and some of the objects I want to send as is to downstream to store them as json in redshift, but when they are loading in redshift they are storing like {abc:234,pqr:[1,2,3]} i.e. they are not proper...

How to make a Pipeline wait during execution

This can be achieved using Python script for making a pipeline to wait in the flow during execution. Change the value in line number 22 in the script time.sleep(120) Here 120 is the seconds which defined to make the pipeline wait. Note: The value n...

Where clause in Oracle Merge Snap

Hello all, Is it possible to add a where clause the an oracle merge snap? Thank you! Jenny Nguyen

SnapLogic - Integration Nation

Forum Posts

Is_number() equivalent

Error : Linkage error for Snap[com.snaplogic.snaps.rest.Get]: Bad type on operand stack

SOAP Session Token Create - How to send encrypted Credentials

Write file to active node on hadoop server

Pipeline/snap to load swagger of foreign apis

How to send output data as JSON from script snap

How to make a Pipeline wait during execution

Where clause in Oracle Merge Snap

Trim and convert string into Date

How to output the SQL statement that was executed ...

How to identify if there are no files in the sourc...

Decode column name that has @ as a prefix

Cannot call parameter in the error pipeline

Formatting CSV data for XML output

Get MIN (oldest) or MAX (most recent) date from ar...

Line Break in Mapper

how to filter out spaces

Expression to extract values in nested JSON object...