Designing and Running Pipelines

Converting JSON to HTML Table for Email Snap

Hello. Let’s say I have JSON like the following: [ { “OwnerName”: “Mike Waltz”, “OwnerEmail”: “mwaltz@testcompany.com”, “LeadName”: “John Doe”, “LastModifiedDate”: “2017-10-05T13:43:39.000+0000” }, { “OwnerName”: “Mike Waltz”, “OwnerEmail”: “mwaltz@t...

Resolved! Converting Datetime with AM/PM to 24Hr date format

Hi, I have a requirement where from the source file. I am getting date as string value ‘10/21/2019 6:16:54 PM’, I want the date to be converted into yyyy-mm-dd hh:mm:ss format. In the example given above the output should be ‘2019-10-21 18:16:54’. 8/...

Task Execute Timing out

Hi, We are using the cloudplex version of Snaplogic. We have a pipeline built that downloads a very large weather data set. We had to build the pipeline to execute in “batches” using the Task Execute snap because the 100mm row+ download files up th...

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

SnapLogic - Integration Nation

Forum Posts

Converting JSON to HTML Table for Email Snap

Resolved! Converting Datetime with AM/PM to 24Hr date format

Task Execute Timing out

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

Converting a string to JSON doesn't work