Designing and Running Pipelines

Refresh Materialised view

Hi, I am trying to refresh Oracle Materialised view in SnapLogic. Please did someone suggest some snap. I am trying to execute below script begin DBMS_SNAPSHOT.REFRESH(xxx,‘C’); end; Thanks, Anil

File upload through rest post snap

Hi team, Could any one help in suggesting how to upload file using rest post snap.

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

SnapLogic - Integration Nation

Forum Posts

Refresh Materialised view

File upload through rest post snap

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

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings