Designing and Running Pipelines

Join the data of multiple sheets in an excel

Hi Team, I have a excel file from the source where it has one lakh number of records. And that excel file has multiple sheets of data and is related with each other from a primary key. I need to join the data of multiple sheets to have the related in...

How to read and store a excel file uploaded from Ultra task POST API

Hi All, I am creating a pipeline which stores a file uploaded from ultra task POST API and stores it to snaplex file storage. I have tried out many things but none of the examples worked. there is no proper solution in internet.

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...

SnapLogic - Integration Nation

Forum Posts

Join the data of multiple sheets in an excel

How to read and store a excel file uploaded from Ultra task POST API

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

optional field on mapper

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper