Designing and Running Pipelines

Ternary operation to handle diff date formats

The source file contains Reporting Period value in diff date format. Aug-2022 Aug-22 AUG 2022 August-2022 I am using the below ternary expression to handle the above mentioned date pattern. isNaN(Date.parse($RPT_MONTH,‘MMM-yyyy’)) || isNaN(Date.parse...

Resolved! Date Issue in Pipeline Parameter

Hi All, I have a requirement to pass date in YYYY-MM-DD format and I am using the expression “Date.now().toLocaleDateString()” but I have the below issue. When I use it in pipeline parameter “Effective_Date” then use _Effective_Date in the pipeline ...

Setting content-length in REST PUT snap for SharePoint API

Hi gang, Hoping this awesome community can help me figure this out. Our team is trying to reconstruct some pipelines for uploading documents to SharePoint. Where we’re running in to a snag is after we’ve already received an OAuth 2 token and created ...

Resolved! Vlookup betwen two tables

Hi snaplogic experts, lets say i have excel(A) with 10 values in one column (branches) on left side and on the right side i have excel(B) with two columns (branches and managers). iam able to read them separately … but how can i create something like...

Can Excel Formatter Insert Data at an Offset (Column or Row)?

I have a requirement, that I insert data into a series of sheets in an Excel workbook - and the sheets are not blank. Is there a way to tell the Excel formatters (would love to use the multi-sheet formatter for this) to start inserting at a particula...

Resolved! Using sl.zipObject with Headerless CSV

Hoping someone might be able to find a solution to a challenge I have. I have a headerless csv file. I’m also reading in a header array that I wish to match up with the data in the headerless csv. I don’t want to add the header values to the CSV Pars...

Resolved! Map Values into an Array

I have a document that contains several records with key/value pairs. [ {“DOB_Date”: “1960-07-04”, “First_Name”: “Bobby”, “ID”: “99999”, “Last_Name”: “Fischer”}, {“DOB_Date”: “1970-08-24”, “First_Name”: “Wade”, “ID”: “99988”, “Last_Name”: “Boggs”}. ...

Snap aborted error

Hi , I am tryin to execute a pipeline which was already working fine. but all of suddent i see below error appeared and i am unable to get the thing resolved. Please let me know if any one has any idea on this. I am using filepollar for each fiel rea...

SnapLogic - Integration Nation

Forum Posts

Ternary operation to handle diff date formats

Resolved! Date Issue in Pipeline Parameter

Setting content-length in REST PUT snap for SharePoint API

Resolved! Vlookup betwen two tables

Can Excel Formatter Insert Data at an Offset (Column or Row)?

Resolved! Using sl.zipObject with Headerless CSV

Resolved! Map Values into an Array

Snap aborted error

String replace method where pattern is dynamic

Send Multiple HTML Tables in Email using XML Parse...

Email Sender Snap - Send data as HTML Table

Creating a pipeline involving user interaction in ...

How to add an object into an array

Writing to Pipeline Parameters within Pipeline

Email Sender Snap - HTML Table printing grouped va...

error 3 upstreams for join

How to add a snap that does nothing.

How to find if the entity exists in an array or no...