Designing and Running Pipelines

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

Need to know email address validation logic

Hi, I need to setup a logic to filter out only valid email address, might use that logic in filters, conditional or mappers. logic should able decide which email address valid. For ex : test@test687 is invalid and test@test687.com or test@test687.edu...

SnapLogic - Integration Nation

Forum Posts

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

Need to know email address validation logic

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