Designing and Running Pipelines

How to combine 2 fixed format documents into one document

Hi , I have a requirement to create a flat file from the XML. The Flat file is having Header and Details section(Both Header and Details sections are of fixed format). So i am using one fixed formatter for header and another one for the details, But...

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.

SnapLogic - Integration Nation

Forum Posts

How to combine 2 fixed format documents into one document

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

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