Designing and Running Pipelines

Error pipeline STOPPED - WAITING on java.util.concurrent.locks.AbstractQueuedSynchronizer

Hi SL gurus, I designed an async pipeline, see picture. I created an error pipeline and defined it in my async pipeline properties. I created a triggered task for my async pipeline. Now, to simulate an error, I put some trash into JSON Formatter. Whe...

"Sort path" based on dynamic columns // sort & diff

Hi, i’m having the following challenge: I’m pulling data from a REST API as well as SQL tables. Before grabbing the actual objects, i’m grabbing “Object Types” from the REST API to know which tables to grab from the SQL DB. The tables each have diffe...

"Pipeline execution failed or was aborted" - proper design of async interface(?)

Hi SL gurus, I designed an async pipeline, see picture. I created an error pipeline and defined it in my async pipeline properties. I created a triggered task for my async pipeline. Now, to simulate an error, I put some trash into JSON Formatter. Whe...

Rest Get Pagination Issue

Hello, I am having issues with the Rest GET Pagination mechanism. The Pagination works fine in the validate mode, but doesn’t traverse after 1st page when i actually run the pipeline. This is so weird that i am able to see the pagination working fine...

Selecting only certain columns from CSV using Mapper

Hey All, Having a little bit of trouble with this. So I currently have a csv file Ive pulled from s3 loaded into snaplogic via the S3 file reader. I’ve used a CSV parser to look at the file and it looks good. What I need to do from here is only pull ...

Need help on XML file convert to CSV

i have book.xml file with book.XSD file and trying convert into csv file but book.xml missing some element in the xml file. In CSV file required and present and missing element information should visible with blank value with header. I have tried xm...

Need a null check or exists check for this Mutiple vs single typeof

[image] I think I need another check to see if this node actually exists in the json or payload. I have tried hasOwnProperty() and hasPath() Any other suggestions? typeof $[‘wd:Submit_Published_Course_Section_Request’][‘wd:Published_Course_Section_D...

Table creation when sending mail

Hello, I was designing a pipeline which includes salesforce upsert and deletion . Obviously error view will be captured for the upsert and deletion operation and while sending the mail along with sending the file we decided to incorporate the values ...

SnapLogic - Integration Nation

Forum Posts

Error pipeline STOPPED - WAITING on java.util.concurrent.locks.AbstractQueuedSynchronizer

"Sort path" based on dynamic columns // sort & diff

"Pipeline execution failed or was aborted" - proper design of async interface(?)

Rest Get Pagination Issue

Selecting only certain columns from CSV using Mapper

Need help on XML file convert to CSV

Need a null check or exists check for this Mutiple vs single typeof

Table creation when sending mail

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