Designing and Running Pipelines

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

Getting list of csv files through directory browser and parsing by date

Hey All, So I’ve been trying to develop a pipeline that reads a bunch of files from an s3 bucket, checks which ones are no more than a week old, and then sends those to be parsed and eventually uploaded into snowflake. I’ve already been able to read ...

Throttle Pipeline based on a combination threshold

Hi, We have a need to trigger a child pipeline when an input SQS message count reaches ‘N’ messages OR ‘M’ seconds have passed since the last run - whichever occurs earlier. Any thoughts on how best to write this pipeline? The goal is to try and thr...

SnapLogic - Integration Nation

Forum Posts

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

Getting list of csv files through directory browser and parsing by date

Throttle Pipeline based on a combination threshold

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

Best way to perform multiple search and replace in...

Obtain Rest API curl to run in postman directly

CSV parser cannot parse data

Parsing XML using a Python script returns an encod...

multiple array objects

String replace method where pattern is dynamic