Designing and Running Pipelines

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

File Operation snap question

I want to do the file compare (DIFF) on two files but the name changes every day with a new date. On my File Reader snap, I have put the file names in like this “smb://xxxxxx.com/us_data/Shared/MM365/Clients/Small Market/Reporting/Non-Standard_Report...

SnapLogic - Integration Nation

Forum Posts

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

File Operation snap question

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling