Designing and Running Pipelines

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

Read and process several CSV with different structure

Hello everyone.Please can you help me with this requirement.I need to read a folder with several CSVs, but they have different structure and data type.I got all the CSVs with plugin: "Multiple File Reader" but when I try to parse them, I only got one...

SnapLogic - Integration Nation

Forum Posts

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

Read and process several CSV with different structure

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