Designing and Running Pipelines

Insert data in a table, then perform an insert in another table using a lookup from the previous table

Hello all, I’m just beginning with SnapLogic, and wanted to see if my current pipelines could be simplified. What I have is source data that looks like this: I want to normalise this data, so that folder details go into one table, and file details g...

Update specific excel column of a sheet

I need to update specific column (and cell if possible) of excel sheet once all operations completed into the pipeline. e.g. Read Excel sheet1 → excel parser → mapper → REST POST–> need to update sheet1 column c with status “Completed” Please sugges...

Snaplogic Pipeline Exposed as API

When we create a Task for any Pipeline then it creates a task URL which is an API. If we give that URL to any third party application to run our pipeline from their application, How they will be able to trigger that API through external application. ...

Resolved! Migrate Pipelines

Hi Community, I’m trying to build a pipeline that migrate pipelines, accounts, tasks from one Org to another. I constantly receive an error message for the SnapLogic Create snap, while creating the pipeline in an folder. Could you please help me on t...

Resolved! Json Path, when some objects don't contain the path

Hello, i have a pipeline that is extracting values from an array using JSON path. This is how it works… Extract the status and effective data from the array where the “activity” = x I use this expression… jsonPath($, “$regulatedActivities[?(@.Activi...

How does a Diff snap determine modified vs inserted?

I’m currently using a Diff snap as part of a pipeline that inserts data into a SQL server for reporting purposes. I’m using a diff snap so that I can determine if a record needs to be updated or inserted, the problem I’m having is that 2 of the reco...

About the Testing, Deployment, and Automation category

Use this section to discuss best practices for Testing, Deployment, and Automation.

Resolved! I have a use case where I have to invoke the one library function with another library function with in same expression library

I have created an expression library as below: { ‘DEPT’: { “EG” : “Engineering”, “HR” : “Human Resource”, “FIN” : “FInance” }, AddDescription : element => (element.filter(x=>x.sector==‘USA’).map(x=> x.extend({‘Description’:this.DEPT.get(x.deptId)}))....

SnapLogic - Integration Nation

Forum Posts

Insert data in a table, then perform an insert in another table using a lookup from the previous table

Update specific excel column of a sheet

Snaplogic Pipeline Exposed as API

Resolved! Migrate Pipelines

Resolved! Json Path, when some objects don't contain the path

How does a Diff snap determine modified vs inserted?

About the Testing, Deployment, and Automation category

Resolved! I have a use case where I have to invoke the one library function with another library function with in same expression library

Change all Keys in JSON structure to lowercase

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