Designing and Running Pipelines

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.

DIFF SNAP issue

When i compare txt type files, everything works well with the DIFF snap but when i try to compare excel files, sometimes the column formats look different and it appears as a MODIFIED row on the report. Is there a trick to that? For example, a money ...

Integrating Snaplogic with VBA

Hi, I need to take data from 3 sources and consolidate them in the sheet post that I need to activate the VBA code which completes the work. For the first half, I employ snap to complete the task and after there are some pivoting logic needs to be ha...

SnapLogic - Integration Nation

Forum Posts

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

DIFF SNAP issue

Integrating Snaplogic with VBA

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

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...