Designing and Running Pipelines

How to use if else condition in xml generator snap

Hello Team how we can use if else condition in xml generator snap here is my query here either Expt have value or Sco have value not in both (Expt,Sco) i want to display case 1)if vatPer = 0.0 and if Expt tab have value then display Expt tab expe...

Resolved! Get minimum date from set of column values

Hi, I have a typical requirement, where i need to find the Min ETL run time from below set of data. I tried to convert rows into columns but there is no common field to do group by. i tried different options but nothing worked for me The desired ou...

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

SnapLogic - Integration Nation

Forum Posts

How to use if else condition in xml generator snap

Resolved! Get minimum date from set of column values

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

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings