Designing and Running Pipelines

Resolved! Detect XML attribute xsi:nil and apply null value

I am using a SOAP Execute to retrieve information from an API. The payload is being converted to JSON. The problem is any field that is null returns with an attribute of @xsi:nil:“true”. This is just an example subset. There are actually more tha...

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

SnapLogic - Integration Nation

Forum Posts

Resolved! Detect XML attribute xsi:nil and apply null value

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

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

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...