Designing and Running Pipelines

JDBC Thin Client: Wallet

Hi, I have a question regarding Oracle Thin Dynamic Account. How could I connect to Oracle ATP with a wallet? Oracle says, the the wallet needs to extracted in a directory. Then I can use the Custom JDBC URL with jdbc:oracle:thin:@dbname_high?TNS_ADM...

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

SnapLogic - Integration Nation

Forum Posts

JDBC Thin Client: Wallet

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

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...