Designing and Running Pipelines

Resolved! Attribute name change in array with mapper

Hi, Could you please help me to change attribute names from input json? Input { “title”: “students”, “items”: [ { “name”: “Tom Cruise”, “course”: “EEE” }, { “name”: “Robert Downey Jr.”, “course”: “CSC” } ] } I need to change output as { “title”: “stu...

Configuration of OpenFT to SnapLogic System

How to connect OpenFT to the SnapLogic system. What are the details that are required and how they are configured…?

Resolved! Creating Nested Json for REST API

Hello All, In my use case, I have a nested JSON as an input, I want to do some transformation before I create a nested JSON which I am going to post it in a REST API, InPut JSON: [ { “Customer”: { “Name”: Sam “City”: “Chicago”, “Email":""abc@ggg.com”...

Ultra task issue with Rest API

I am getting below error while trying to design a ultra pipeline to read JSON/XML document but when i try to POST json data from POSTMAN, getting error as below. Snap is not connected to any upstream source Reason: Snap failed unexpectedly and did no...

Resolved! To fix the pipeline to convert to array

Hi there, I have the following JSON [ { "POSEX":"00010", "E1EDPT1": [ { "E1EDPT2": [ { "@SEGMENT": "1", "TDLINE": "KIT,HIGH SPEED PINION (HSP),", "TDFORMAT": "*" }, ...

Resolved! Unique Constraint Issue in Oracle while inserting Data

In this Scenario, I have to insert data onto an Oracle DB. Before that one I’m performing a Left Outer join and separating the data (for Update and Insert) by using router. In Insert snap I have to insert all the data ,before that one Need to check w...

Error when joining a large data stream to a small one

Good day all, I’m getting an error when joining a large data stream (118M rows) with a smaller one (276 rows). The join is on a field called ‘column_name’ to ‘col’, and its an Inner join. The smaller data set contains data validation info (length, d...

Read/write data using adls gen2

I am trying to read and write data from adls gen2 account but not able to get it. Account is created and validated successfully. Can anybody give some example to achieve this.

SnapLogic - Integration Nation

Forum Posts

Resolved! Attribute name change in array with mapper

Configuration of OpenFT to SnapLogic System

Resolved! Creating Nested Json for REST API

Ultra task issue with Rest API

Resolved! To fix the pipeline to convert to array

Resolved! Unique Constraint Issue in Oracle while inserting Data

Error when joining a large data stream to a small one

Read/write data using adls gen2

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