Designing and Running Pipelines

How to add data type

We have Json file as input source which some random data for that values we need to add datatypes. Sample data: { “Id”: “1076”, “jobTitle”: “Software engineer”, “firstName”: “David”, “lastName”: “villey”, “fullName”: “Davidvilley”, “email_N”: “Davidv...

Date Timestamp error while trying to use the "sql server update" snap?

Hi All, I’m trying to update the target sql server table using “sql server update” snap with the where condition “INSERTTS = $INSERTTS” (INSERTTS is the insert date timestamp) but I’m getting the error Failure: Type class org.joda.time.LocalDateTime...

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

SnapLogic - Integration Nation

Forum Posts

How to add data type

Date Timestamp error while trying to use the "sql server update" snap?

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

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

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...