Designing and Running Pipelines

How to encode (base64 format) a zip file?

Hello Everyone! We are planning to build a pipeline to achieve the following scenario. Extract Oracle Data → Create a CSV File → Zip CSV file → Convert Zip file to Base64 Format. We build the pipeline as following. We were able to do all activities t...

Resolved! Connecting to shared Mailbox Error

Hello, I am trying to connect to the mailbox and it keep giving me this error. I can connect to the mailbox using outlook without any issues. Any help will be appreciated.

Unable to find proper resource to which can help import external libraries in script snap

Using Script Snap to fetch file document of attachments from JIRA and to encode it, we are unable to add external third party libraries like “request” for python in the directory mentioned as /opt/snaplogic/:- Below is the script:- import requests im...

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

SnapLogic - Integration Nation

Forum Posts

How to encode (base64 format) a zip file?

Resolved! Connecting to shared Mailbox Error

Unable to find proper resource to which can help import external libraries in script snap

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

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