Designing and Running Pipelines

Rest Get Query parameter particular filter criteria not working

I am doing an API call by passing dynamic timestamp in Query Parameters section , here is the value I am passing “INSTALLED_SW_LAST_CHANGE_TIMESTAMP%20ge%20”+Date.now().toLocaleDateString()+“T15:00:00-05:00)”. I am getting status code error 400 But ...

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

SnapLogic - Integration Nation

Forum Posts

Rest Get Query parameter particular filter criteria not working

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

Change all Keys in JSON structure to lowercase

How to read .xlsb file

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