Designing and Running Pipelines

Create Key Value Pair Array

Hoping someone can help me out. I have a JSON array. It’s an array of string values and it’s called, washCare. I want to give each value in the array a property name. How would I write the correct mapping to accomplish the following? I thought I coul...

Get JIRA Attachment Content Document in Snaplogic Pipeline

Hi all, We’re trying to get the JIRA Attachment Content document and it gives the URL of the attachment as shown below:- “content”: “https://myjira-abc.atlassian.net/secure/attachment/10000/sample.txt” We are trying to get the metadata of this conten...

Scenario to achived rownumber function in sql

How can I achieve rownum() funtion in Snaplogic? I have a input data Column 1 a b c a a need output Column1 Column2 a 1 b 1 c 1 a 2 a 3 How can ...

JDBC connection pooling - when are minimum number of connections created?

If I have a Generic JDBC Account configured with a minimum pool size > 0, when does the connection pool get created and initialized with the minimum number of connections? Is it when the first pipeline that uses the Generic JDBC Account is being prep...

Match Expression stored in a Variable

I have a Pipeline using in different branches the same Mapper for one of the Field See ScreenShot I would like to use a Pipeline Variable in my Mapping Expression in order to update/maintain only once my expression my ORGANISATION Mapping expression...

Mapper issue after change in the UI

Hi Team, I am facing a huge problem in the mapper after the UI change. If the input data is in array then its not showing all the attribute when we want to select the attribute in mapper. Previously it was showing all the attribute for that we can ea...

Google Analytics Query Explorer Error

Hello, I have a “for each” snap that calls a pipeline to connect to Google Analytics query explorer and extracts the data for 20 different websites. The problem that I encounter is that when I execute the “for each” for multiple interactions, I get ...

Resolved! Sum of values in array of objects without reduce function

Hello all, I stumbled upon a situation where I have to find out a sum of a certain key in the objects residing in an array without reducing the objects? What I mean to say is, here is the input: [ { key1: value1, key2: 10 }, { key1: value2, key2: 20 ...

SnapLogic - Integration Nation

Forum Posts

Create Key Value Pair Array

Get JIRA Attachment Content Document in Snaplogic Pipeline

Scenario to achived rownumber function in sql

JDBC connection pooling - when are minimum number of connections created?

Match Expression stored in a Variable

Mapper issue after change in the UI

Google Analytics Query Explorer Error

Resolved! Sum of values in array of objects without reduce function

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...