Designing and Running Pipelines

JSON Formatting

Hello Experts, Input :- { “column”: [ { “name”: “firstName” }, { “name”: “lastName” }, { “name”: “middleName” } ], “content”: [ [ “aa”, “bb”, “cc” ], [ “dd”, “ee”, “ff” ], [ “oo”, “pp”, “qq” ] ] } Output :- { “data”: [ { “firstName”: “aa”, “lastName”...

Unable to retrieve average duration of pipeline executions from Ultra task

I have ultra task triggered by a pipeline that executes all of the time. I want to get the average “duration” of pipeline executions from the dashboard executions for the past 7 days (1 week duration), but when I try to do that from the Rest Get I ge...

How to call oracle function in snaplogic

Inserting data into Oracle DB using UTF 8

How can we Insert data into Oracle table in UTF 8 character set . There is no option to write data in UTF8. Without UTF8, word MÉXICO is inserted as M�ICO . Can someone please help.

Insert/Update using Join Snap

Hi, I am using Join Snap, to implement the logic of Insert new record and update existing one by doing join on target table. i defined left outer join to read all input records and in router i used condition on input1_column1, the condition is workin...

How to get file size from Directory Browser Snap and use it as a filter condition

HI, Please can i know how to get file size from Directory Browser Snap and use it as a filter condition in router. i am able see below options in Snap not anything about size. Thanks in advance.

User Management

Hi Team, My requirement is to list the users and the permission they have on project spaces and projects. I’m unable to get the complete info using the Public APIs. Is there any other process available to get the list ? Or do we need to develop our o...

Resolved! How to convert linkedHashMap to list / json object

Hi Team, I have an input json in linkedHashMap in below format: [ { “Path”: “/OrgName/shared”, “subject_type”: [ “GROUP”, “GROUP”, “GROUP”, “USER” ], “subject”: [ “Operations”, “admins”, “Architects”, “xyz@xyz.com” ], “perms”: [ [ “R”, “X”, “W” ], [ ...

SnapLogic - Integration Nation

Forum Posts

JSON Formatting

Unable to retrieve average duration of pipeline executions from Ultra task

How to call oracle function in snaplogic

Inserting data into Oracle DB using UTF 8

Insert/Update using Join Snap

How to get file size from Directory Browser Snap and use it as a filter condition

User Management

Resolved! How to convert linkedHashMap to list / json object

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