Designing and Running Pipelines

How can I test for no rows back from Oracle query

I am trying to figure out how to route to a ‘no data’ path when nothing is returned from my select query. Can someone help me out? What I’ve tried is (in ‘Is there data?’ snap): $retval != null (then go to data path); otherwise, go to nodata path....

Get documents from DocuSign- envelopes give me error

I established a connection with Docusign, and want to retrieve documents from Docusign, but the below code gives me an error: looks like I need an envelope Id but I want to get the documents in bulk without specifying envelop id… $base_uri+ “/restapi...

Need to know only columns which has update

Hi Guys, If I have to load delta records through snaplogic into a target system and only those fields which has some updates. suppose we are getting 20 fields from source,Is it possible to know out of them how many fields have actually updated from t...

MongoDB Find Snap qurey only top 10 records

Hey guys: how do I read data from a Mongodb Collection using Mongodb Find snap but take only the top 10 records? Thank you!

SQL Server Stored Procedure Snap hangs when returning data

Hello, I’m working with a Stored Procedure that has no input variables and returns about 4800 rows of data. When I build out my pipeline and validate, the procedure returns the first 50 rows successfully (as expected). However, when I go for an act...

SnapLogic Errors: Return custom payload and fail pipeline

Is it possible within SnapLogic to configure a pipeline to fail via a Snap but also to return a custom output back to the user (configured via a Mapper snap, e.g.) I have reviewed the video here: Framework: Error Handling & Retry Patterns and it appe...

Loading records of object having two lookup fields on the same object(Contact)

There is one object relationship. The object has two lookup relationship both on the Contact. We are trying to load relationship record data and relate that record with both the contacts. We have external ids field created on Contacts which are being...

How to get the number of documents

after i am doing a file read snap and map the documents via mapper snap is there a way to get the total number of documents on the next snap? I basically need to perform a router and need the path/output of all the documents to go 1 way if there are ...

SnapLogic - Integration Nation

Forum Posts

How can I test for no rows back from Oracle query

Get documents from DocuSign- envelopes give me error

Need to know only columns which has update

MongoDB Find Snap qurey only top 10 records

SQL Server Stored Procedure Snap hangs when returning data

SnapLogic Errors: Return custom payload and fail pipeline

Loading records of object having two lookup fields on the same object(Contact)

How to get the number of documents

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

Rest Post for Multipart form type content type wit...