Designing and Running Pipelines

Global or Public variable

Hello, I have a requirement of sharing a value in captured in one Snap to the other Snap but not to an immediate following Snap. Ex: Rest GET Snap (getting token)–> Mapper → …other SQL snaps … —> REST PUT snap (I need token here to call PUT) How to ...

Get latest file from sftp and process one at a time

I want to get all files from yesterday’s date from ftp and process them one by one. There can be only one file and can be multiple files but they need to be processed one at a time. I tried using mapper , to get yesterday value “Date.now().toLocaleD...

Pipeline Execute - Prepare on Neighbor Failed

Anyone have an idea what the culpret might be with this “prepare on neighbor” error with the Pipeline Execute snap, excuting a child pipeline on my groundplex? I get these sometimes, seemingly randomly… Most annoying part is that even though I have...

Load sql query data to csv file and send this file in email as an attachment

Load sql query data to csv file and send this file in email as an attachment. I tried using snowflake execute snap to get sql data and then use csv parser and write to file writer.The data is not shown in file writer. Can you help me on solving thi...

Parameterizing Pipeline Names in Orchestration Tools

Does anyone have any examples or success with parameterizing pipeline label names and passing them in via execution of Orchestration tools outside of SnapLogic ? Is there a best practice or design pattern out here for doing so? Any help, ideas app...

Resolved! Is there a way to insert a row number while mapping an object array?

I am creating an integration that will take JSON from our CRM and create invoices in our ERP. One of the required fields is line number for each of the invoice lines. I am trying to generate this in the mapper snap, and I cannot figure out a way. ...

Removing [] from JSON array

Hey Everyone, I’m currently receiving data from an API and inserting the data into a MySQL database. Here’s an example of one of the columns that are coming over: [“5bb1614c4fd80200018e33c4”,“5ca500003aaf6000014dbc98”,“5b5f558add2f28000151e88d”] Is t...

Resolved! Splitting Json value

My requirement is whenever I pass a filename, the relevant node_id should be displayed for example: when the file name " 82755-6-012019-55.pdf" is passed node id 1021953 should be filter out.

SnapLogic - Integration Nation

Forum Posts

Global or Public variable

Get latest file from sftp and process one at a time

Pipeline Execute - Prepare on Neighbor Failed

Load sql query data to csv file and send this file in email as an attachment

Parameterizing Pipeline Names in Orchestration Tools

Resolved! Is there a way to insert a row number while mapping an object array?

Removing [] from JSON array

Resolved! Splitting Json value

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