Designing and Running Pipelines

Resolved! How to best combine/map values from separate inputs?

I’m trying to produce output containing Value and Item ID from separate files. I have two input files for this, with different naming for the fields For example, Transaction Name=TRANSACTION First Name=FNAME LastName=LNAME In addition, one file conta...

How to do 'Not equal' in Lookup conditions section of SQL Lookup snap

How can I do below query with SQL Server Lookup snap: SELECT * FROM table where status<>‘D’

Resolved! How to get Index of Array list along with the data

Hello, I am working on API’s and while pulling the data from API and storing in the DB. The API is returning data in Arrays and while using the splitter i am able to split the data of arrays and load into the DB. But my requirement is to also store t...

Set up error pipeline

I have configured error pipeline but the error is not passing into input view. Need help to configure this. Thanks error pipe_2020_08_27.slp (2.2 KB) rest api_2020_08_27.slp (2.7 KB)

Replace "@" and "#" while converting XML to JSON

Hi All, I am converting XML file to JSON file using XML parser snap and JSON formatter. When I’m converting, prefix “@” is getting added to all the attributes. For example:- In XML → “ProviderPaxRef”: “String” In Converted JSON → “@ProviderPaxRef”: “...

Resolved! Select column based on column availability

Hi, I am reading multiple json files from source. where column names and column type are varying from file to file. For example: In one file, column name is coming as an array and in another file it is coming without array. But for my use case I don’...

Salesforce Query

Hi Good Day, I was designing an automation pipeline which brings down the manual effort . The pipeline is about to be completed but I encounter some difficulties while parsing the fileds in the SOQL snap . I get the two fields $Start_Date and $End_Da...

Resolved! How to stop snap execution

I have a pipeline which along the way checks for a presence of a particular value. If there is no value it should exit without errors but not execute the the rest of the pipelines. How do I achive that? For example: MySQL Snap reads a value from some...

SnapLogic - Integration Nation

Forum Posts

Resolved! How to best combine/map values from separate inputs?

How to do 'Not equal' in Lookup conditions section of SQL Lookup snap

Resolved! How to get Index of Array list along with the data

Set up error pipeline

Replace "@" and "#" while converting XML to JSON

Resolved! Select column based on column availability

Salesforce Query

Resolved! How to stop snap execution

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?

Remove XML duplicate key from JSON list in XML for...