Designing and Running Pipelines

How to check the parameters passed from parent to child pipeline

Hi, I am running into a situation where when I submit one pipeline from a parent it runs but didn’t do the desired processing however when I run it individually it runs fine. How do I get to know what parameters are passed from parent to child? and w...

How to delete extra columns in csv file which have no data in it

Hi,I want to delete the extra columns in CSV File which do not have data in it.While applying CSV Parser its showing that few extra columns are there.I want to delete those extra columns from CSV File.How to do that through help of Snap and Pipeline

Json splitter for multiple array objects

I have a Json input that contains multiple array objects within it. Json sample given below. I'm trying to flatten this data into table rows, I use two json splitter to achieve this.First Json splitter with Split path $ServiceCompanyArray and then a ...

How to ignore duplicate rows when inserting record into table

I'm developing a pipeline to request data from an API and load it into a MS SQL Server table. The first run of the pipeline loaded 50 records to the table, each with a unique 'user_name' value. The table constraints require the 'user_name' field be u...

Mapper Snap: Valid Column Names In Input Schema Give "Undefined" Error

Hi, I am experiencing an issue where I have a Mapper Snap that gives the error: $[FieldName] is undefined when I input a field name in the expression box. The fields that I am using are inside the input schema of the mapper snap (I have dragged and d...

Resolved! Splitting Json with array[0]

I have a Json data, that contains a field that could be an array as per Source definition. Json given belowIt is not always mandatory that the FeeReductionDetail will always be an array with multiple elements, sometimes it could be with just one elem...

How do we get authentication token for snaplogic instance

Hello Community,I want to access SnapLogic Assets such as pipelines, and projects on a SnapLogic instance within our organization.How do I authenticate the Public APIs from Postman?How do I get the access or authentication token?https://docs.snaplogi...

Convert Nested Json file to Excel

Hi, I’m working on a requirement to convert Nested Json file to .xls format, but facing some bottlenecks in getting required output. The output shows list of values in cells instead of breaking into multiple rows.Would someone be able to help me out ...

SnapLogic - Integration Nation

Forum Posts

How to check the parameters passed from parent to child pipeline

How to delete extra columns in csv file which have no data in it

Json splitter for multiple array objects

How to ignore duplicate rows when inserting record into table

Mapper Snap: Valid Column Names In Input Schema Give "Undefined" Error

Resolved! Splitting Json with array[0]

How do we get authentication token for snaplogic instance

Convert Nested Json file to Excel

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