Designing and Running Pipelines

How to Split using Regex expression

Hi, I need some help on spliting the user name on basis of Regex expression.My user Name is an combination of mutliple users and i cant use comma to split them. so, i tried regular expression and which is working good on DB level and planned to imple...

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

SnapLogic - Integration Nation

Forum Posts

How to Split using Regex expression

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

What account should be used for API with query par...

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