Designing and Running Pipelines

Using a File Poller to a File Reader

Hello, I am trying to figure out how to use a File Poller to make a file name a variable and then to use that variable as the file to use in a File Reader? I am not sure on how to get it to work. Also, how does the File Poller truly work if I have mu...

Extract in-line image from HTML format email

We are reading emails from a IMAP mail box where ppl sometimes send HTML format email. Sometimes in the email, ppl contains images as part of html. For example, here’s what we have got from an email reader How can I extract the image from the email...

How to flatten hierarchial JSON structure?

Hi Forum, I have hierarchical JSON structure coming as input and need to flatten(and transformation) the document as output. Below is the simple example showing input and output structure. I tried doing this with Mapper, Strcuture and JSON Splitter s...

MySQL Insert Can't Insert Special Characters

Is there any way to encode strings or perform a MySQL insert on a special character like ł or Ł. I can’t get it working, but it works just fine using another ETL process. In my specific use case I’m trying to insert names that include special charact...

Converting String to Bigint

Good day SnapLogic Community Is there a function that accepts a string and converts it to a BigInt? An equivalent SQL statement is below, CAST(DRIVERPERMIT AS BIGINT) = 0 Thank you very much in advance, Andre

Mermory Utilization of Specific pipeline

I have a requirement of calculating total memory that it consumed by a specific pipeline during it’s run time. Can we use Public API with RuntimeId of that pipeline to figure out the utilization of total memory for a specific pipeline. Thanks!!

Resolved! Dynamic records generation

Hi, I want to generate dynamically n records, based on column value. Lets say based Number_Streams , I want to create n records having same values for other columns, except the name. In name column I want to append alphabets dynamically. Sample Input...

Is there a way to extract data from db which is accessible over telent?

Is there a way to extract data from some old db which is accessible over telent?

SnapLogic - Integration Nation

Forum Posts

Using a File Poller to a File Reader

Extract in-line image from HTML format email

How to flatten hierarchial JSON structure?

MySQL Insert Can't Insert Special Characters

Converting String to Bigint

Mermory Utilization of Specific pipeline

Resolved! Dynamic records generation

Is there a way to extract data from db which is accessible over telent?

Get MIN (oldest) or MAX (most recent) date from ar...

Line Break in Mapper

how to filter out spaces

Expression to extract values in nested JSON object...

groupby field and count

IF Statement in Expressions Library file

Create Expression Library from Excel data

Can't paginate using Post HTTP CLIENT Snap

How to formulate expresssion

Creating unique ID's and repeating