Designing and Running Pipelines

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

Extract data from oracle table

I am trying to create a pipeline where I used the oracle stored procedure to insert data into a table and then link it in resultset output view and use the oracle select to read the data from that table and create a csv file.But so far, I am getting ...

SnapLogic - Integration Nation

Forum Posts

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

Extract data from oracle table

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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