Designing and Running Pipelines

How to read Multiple Sheets from an excel dynamically using Snaplogic

Hi , I have requirement to read a single sheet at a time and load the data in to a table from the same excel file which contains more than 40+ of sheets. Is it possible to do this through Snaplogic. Can some one suggest. Thank You, Mallikarjun

Upload file to sharepoint document library subfolder

I have a pipeline that uses the SharePoint Online - Upload File snap and it works fine. It uploads the file to a Document Library, “Reports” in this case. I have subfolders in that document library and want to be able to upload the file to one of t...

REST GET snap Pagination issue

I am using REST Get snap and pagination is not working. Sample output “entity” : { “@odata.context” : “https://test-odata.com/at.odata/v2.0/$metadata_65687877”, “value” : , “@odata.nextLink”“https://test-odata.com/at.odata/latest/&%24top=20000&$ski...

Resolved! Uniformize document schema

Hello! I am trying to uniformize document schema, I was not able to achieve it using a mapper or a JSon formatter snap. For instance, if I have this input (using JSonGenerator) [ { "num" : 1 }, { "msg" : "Hello, World", "...

Finding Duplicate data existing in Database

I have 2 fields called Product_ID and Partner Product_ID where lets say product ID is P-001 and Partner product ID is P-P-0001 which is already existing in database with this combination and again if i try to insert same combination , it should throw...

I am trying to perform a lookup and extend the object using the expression library

I wanted to perform a extend by performing a lookup using the expression library and it is giving me “this.comparator is undefined” error. Below is my expression Library Content: { embedbusinessUnit: x => x.extend({"Demo":this.comparator[0]}), embe...

Pipeline expression building

Hi In Database i have field called “Product_ID” i need to update the field with ‘P-00001’ when i execute the first time and Second time when i execute the field should be updated with ‘P-00002’ please give me an solution how to implement using which ...

How we can find created SAP IDoc number based on the TID response at SAP IDoc Write snap?

Hello there, Is there a way to find the created SAP IDoc number based on the TID response while using SAP IDoc Write snap? @ptaylor any idea here? Thank You.

SnapLogic - Integration Nation

Forum Posts

How to read Multiple Sheets from an excel dynamically using Snaplogic

Upload file to sharepoint document library subfolder

REST GET snap Pagination issue

Resolved! Uniformize document schema

Finding Duplicate data existing in Database

I am trying to perform a lookup and extend the object using the expression library

Pipeline expression building

How we can find created SAP IDoc number based on the TID response at SAP IDoc Write snap?

What account should be used for API with query par...

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...