Designing and Running Pipelines

How are pipeline executions distributed across a Snaplex?

When a request to run a pipeline is submitted against a Snaplex,the Control Plane must decide which member node to send the request to. In making that decision,the Control Plane assumes that each node in a Snaplex is homogenous in terms of both hardw...

Strange issue - data and email results the same but email doesn't come on execute, only on preview

To keep things simple, Email snap is set with Validate & Execute so that it will fire on preview tests as well as execute. Data is simple, pulls 46 rows from a table, merges the count i.e. 46 and sends the results to an email. Email comes reliabilit...

Resolved! Router Snap Expression for checking Value

We have a Router Snap that evaluates a string and checks whether it matches one of a set of predefined values. I can’t seem to get the expressions right and think a short circuit evaluation is at play here? The logic is as follows If Status CONTAINS ...

Removing leading characters

I’m receiving data with 18 characters, which includes 7 leading 0s. Would I use the Mapper to TRIM off the leading 0s? If so how would I go about this? Thank you

How to loop thru a REST snap

Hello, I am trying to load transaction data from a REST API end point. The API has pagination as required Input parameter. I am using the REST GET to fetch the data and the Https URL should be as below. https://xxxxxx–xxx/transactions?datestart=2018-...

Can AZURE SQL database be used with ELT snappacks

Can we use azure sql as database type in ELT snappacks I am not getting option to select AZURE sql in account setup getting different options like AZure synapse,snowflake etc. Anyone please if knew the answer

Compare DateTime against a point in time (in local time zone)

Hi, I’m having a hard time trying to figure out a way to compare a DateTime property (which is stored in UTC) to a point in time i.e. Today midnight (in the current local time zone which is US/Eastern -05:00)… The closest thing came to find is Date.p...

Resolved! Get current JSON document being inserted

I have a pipeline with a oracle insert snap and a error pipeline. Everything works. When something in the pipeline fails I am passing variables to the error pipeline and storing in a table. I want to pass the current JSON document that failed? W...

SnapLogic - Integration Nation

Forum Posts

How are pipeline executions distributed across a Snaplex?

Strange issue - data and email results the same but email doesn't come on execute, only on preview

Resolved! Router Snap Expression for checking Value

Removing leading characters

How to loop thru a REST snap

Can AZURE SQL database be used with ELT snappacks

Compare DateTime against a point in time (in local time zone)

Resolved! Get current JSON document being inserted

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