Designing and Running Pipelines

Capture of Unix Execute Output

Hi Team, I’m executing below command in one Unix Execute snap. cd /OUT | ls -tr | tail -1 The output is a file name, say - ABC_0822.txt This output file name I want to capture inside a mapper. How to do, please help. Thanks & Regards, Subhasree

Unable to pass dynamic schema in parquet writer

Hi, I am trying to copy data from oracle database to AWS S3 location in parquet format. And I want parquet schema to be dynamic while writing the data into S3 location. So as per SnapLogic documentation I have added one more input snap and using “DE...

Resolved! SnapLogic and Azure Repos Integration

Hi All, Looking out for help in integrating the SnapLogic and Azure Repos. Is there any way to Integrate the Azure Respos and SnapLogic for CI/CD in order to perform the repository operation like Commit, Checkout, pull, etc like we do with the GitHub...

Resolved! Help with adding a field in JSON output

I have a JSON output like this: { "Choices": { "1": { "Display":"Generating standard, automated reports (e.g. ERP, reporting tools)?" } "2": { "Display":"Generating non-standard / custom reports (e.g. spreadsheets)?" } "3": { "Display":"Responding to...

Arrow Function Parameters

I’m trying to understand the documentation for the Array function toObject. It uses [‘zero’, ‘one’, ‘two’].toObject((x, index) => index, x => x.contains(‘two’)) as an example, which returns {“0”: false, “1”: false, “2”: true}. What does the (x, index...

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

SnapLogic - Integration Nation

Forum Posts

Capture of Unix Execute Output

Unable to pass dynamic schema in parquet writer

Resolved! SnapLogic and Azure Repos Integration

Resolved! Help with adding a field in JSON output

Arrow Function Parameters

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

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

Problem with nested mappings