Designing and Running Pipelines

Duplicate data using SQL offset

We are attempting to load transactional tables on a pipeline we created Issue faced - While loading data from a transactional table by leveraging the help of limit and offset in SQL SERVER select snap (partition and loading), we are getting duplica...

Can snaplogic listen to external events

Hey, there can snaplogic listen to external events?

Pipeline Details with dependency from Dashboard

Hello Everyone, I have a requirement like there are aprox 500 pipelines are running already in production environment and every pipeline is calling multiple pipelines inside it to achieve the functionality. I have to create the excel spreadsheet whic...

Decrement a dynamic value per record, move to next match if value=0

Hi all, I am looking for a way to decrement a dynamic value (number of seats per faculty member). I am using a Join to match students to a faculty member, then grabbing the first match by Grouping the values into an array and grabbing the first eleme...

Resolved! Can't apply date functions to a date column

Hello, I get “Unknown method” when applying any date-related snaplogic function to a column that is a local-date-time. I tried this with two separate clients with different schemas and data types, still same issue. Is this a bug?

To check if matching records have different value in other column

Hi there, I have 2 excels fiels, source and destination. each one has 3 columns, Id, Quantity, last modified date. I need to find if there’s a matching record by Id but has different values in Quantity, then use record that has different value to up...

Take upstream file as an input for zipfile read snap

Hello, I am getting a zip file from a rest request. I want to rename files (files we get after we extracting the zip). I don’t want to write the zip file in sldb and then read it using zipfile read. I want to directly use file coming from upstream in...

Ultra Pipeline failure: "Lost connection to feed-masters"

Hi, Recently we noticed some transient ultra pipeline execution failures… in what are normally working pipelines with the following error messages: Lost connection to feed-masters Reason: Snap failed unexpectedly and did not provide any reason Hide D...

SnapLogic - Integration Nation

Forum Posts

Duplicate data using SQL offset

Can snaplogic listen to external events

Pipeline Details with dependency from Dashboard

Decrement a dynamic value per record, move to next match if value=0

Resolved! Can't apply date functions to a date column

To check if matching records have different value in other column

Take upstream file as an input for zipfile read snap

Ultra Pipeline failure: "Lost connection to feed-masters"

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