Designing and Running Pipelines

How to fail a Snap for Invalid json as i/p doc(Duplicate keys)

Hi Team, I am sending a invalid json payload from the postman to my pipeline. The pipeline has first snap as Copy, when i checked the output of copy it has removed duplicated keys from the invalid json payload. My expectation was that it will throw e...

Fetching worklogs From Tempo(Jira Plugin) in Loop

Hello All, I am trying to fetch the work logs from Tempo which is a Jira Plugin to record the time of the resources. The challenge that I am facing is, Tempo has a limit of the number of records that are being returned in 1 API call which is 1000 and...

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

SnapLogic - Integration Nation

Forum Posts

How to fail a Snap for Invalid json as i/p doc(Duplicate keys)

Fetching worklogs From Tempo(Jira Plugin) in Loop

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

Error pipelines and pipeline execute

records to json file

Combine CSV document into a new file

Only execute child pipeline if BigQuery result is ...

Create a date range by hour

SOAP execute snap vs REST post/Http client snap

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

Change all Keys in JSON structure to lowercase

How to read .xlsb file