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

Excel formatter - "Invalid row number" error

Hello, I have a pipeline where I export data to Excel. When there are to many lines to export, I get the error : Invalid row number (1048576) outside allowable range (0…1048575) Reason: Snap failed unexpectedly and did not provide any reason It is ...

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

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

Excel formatter - "Invalid row number" error

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

optional field on mapper

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