Designing and Running Pipelines

Resolved! Add single quotes in comma separated string

Hello, I have a scenario where the location name will come in 2 different scenarios from an API as mentioned below. LOC1LOC1, LOC2, LOC3 The expected output should be ‘LOC1’‘LOC1’, ‘LOC2’, ‘LOC3’ I tried using the split and replace function but in va...

Pipeline Search in Dashboard

Hi everyone, Does anyone know how to search for pipelines, in Dashboard/Health, based on exclusion. For example, if it is easy to only show pipelines containing in the name “pipelineXYZ”, how can we show all runs of pipeline excluding “pipelineXYZ”? ...

Is there a way to selectively exclude fields output from a mapper snap?

I have a case where many fields may have to be excluded from mapper output, as if they never existed, selectively during a run. I am going to a cloud instance of a routine that will take null values in, and display them, or may delete wanted values,...

Converting an array to a denormalized table

This seems like it should be simple but I’m still relatively new to snaplogic and just can’t figure it out. The json coming into my Mapper snap is formatted like this: {"record1": {"id" : "1", "subject":{ "subject...

Need to chunk files and hit the api for each record

Need to chunk files and hit the api for each record. Restriction on api to hit only 1000 records per request. The input has millions of records. how to handle this in same pipeline

Resolved! Converting value of input schema to distinct columns

Hi Team, I’m reading a text file and wanted to fetch DISTINCT columns out of the data itself, screenshot below for your reference. .txt file: When I read the above data in snaplogic, the format is: Tried with $.merge(), GroupByN, CSV parse (contain...

Resolved! Formatting variable JSON

I am working on an integration between two endpoints that deal with values in very different ways and I’m struggling to convert between them. The source I’m getting data from sends out data with mutliple values all on the same element so my input d...

Copybook parse

How to use this Snap, Copybook parser. I didn’t find a proper documentation in SnapLogic on this snap.

SnapLogic - Integration Nation

Forum Posts

Resolved! Add single quotes in comma separated string

Pipeline Search in Dashboard

Is there a way to selectively exclude fields output from a mapper snap?

Converting an array to a denormalized table

Need to chunk files and hit the api for each record

Resolved! Converting value of input schema to distinct columns

Resolved! Formatting variable JSON

Copybook parse

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?