Designing and Running Pipelines

Resolved! Add incoming document to new file row

We want the ability to write a document to a new row within a CSV file. This is only if the document meets certain requirements Is this possible? This article from a few years back suggests not and wondered if there has been any advancements

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Add incoming document to new file row

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)

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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?