Designing and Running Pipelines

Time stamp on an end of a file

Hello, I am trying to figure out the time stamp features, and I can’t seem to get it to work. I have on my file writer: “XXXXXXX_” + Date.now() + .txt But that doesn’t work, Can someone inform me on what I need to do to correct this and get this to w...

Milliseconds to Date

Hi , I want to convert Milliseconds to Date. For instance If I give 1540456849550 then it should give me the date like Thu 25 October 2018 14:10:49 Thanks, Gaurav Sandil

File Listener Functionality

Does snapLogic provide any sort of file listener functionality to start a pipeline?

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

SnapLogic - Integration Nation

Forum Posts

Time stamp on an end of a file

Milliseconds to Date

File Listener Functionality

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

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder