Designing and Running Pipelines

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

Resolved! Need to change JSON response

Hello Community, I want to 9know how can I get below JSON response { “pvProjectID”: “2427827wj”, “p6ActivityList”: [ { “pvPprojectID”: “smhcvxsn,x”, “pvActivityId”: “mxcxzvcb”, “imo_Vorgangskategorie”: null, “okz_Komponentenstruktur”: “01”, “imo_Proz...

Need to create sftp path

Hi Guys, I have to load a file into sftp location. I got hostname,portname,username and password. I can see the directories in winscp. But i have to access it through snaplogic. I created binary>Basic Auth sftp account with username nd password. I do...

Get input file name from CSV parser

Hi, I have a set of CSV files that I read from using a CSV Parser. Is there a way the CSV Parser can also output the name of the file. I have already thought of putting the CSVParser in a child pipeline and feed the name of the pipeline as a paramete...

Get a list of scheduled tasks (name and scheduling details)

Hi All, I’m looking for a Snap or API that will return a list of scheduled tasks with the task name and its scheduled time. I tried SnapLogic List snap which returns the task name but not the scheduled time. Is there any API I can use for this? Ultim...

SnapLogic - Integration Nation

Forum Posts

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

Resolved! Need to change JSON response

Need to create sftp path

Get input file name from CSV parser

Get a list of scheduled tasks (name and scheduling details)

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