Designing and Running Pipelines

Jdbc insert snap account as auto commit is enabled

Hi, The pipeline sends the record to JDBC INSERT snap, under JDBC INSERT Snap account has auto commit is enabled and batch size is 60. if 180 records are streamed into JDBC INSERT Snap and there was an error in 140th record, how many records JDBC IN...

How to insert the NULL in place of no data in CSV input fields having no data?

hi team, the input file having csv data with empty rows in some fields, how to insert the NULL in place of no data in the row. thanks

Resolved! Create TrustStore & KeyStore Files From Certificate?

I’ve been provided a PEM certificate in a .cer file format for connecting to an API by a third-party, and I’m trying to convert it to the correctly formatted truststore and keystore .jks files so that I can create a REST SSL account. Does anyone have...

Inserting a line break while writing an excel file

Hi Team, I’m planning to write an excel file with statistics listed on it and I’ve been successful to record the counts from my previous snaps however at the end, the entire data comes as a long text which I would want to break it up. For instance, I...

JSON array from external to snaaplogic using triggered task

Hi, I am creating pipeline with triggered task and Json as input below. How to get this data into pipeline and use in mapper when postman is used to send request in body. I used ‘$’ in mapping, but no data is coming from postman. “Input”: { “item”: [...

Return the status of executed Pipelines for the specified time within the Org

I am new to snaplogic so please bear with me! I am trying to build a pipeline to extract the pipeline execution history for specified time range using GET REST snap. I could see below Query in the documentation: GET https://elastic.snaplogic.com/api/...

Pipeline not going to error view when SFDC update snap fails

I did not map Id field on the mapper while updating sfdc record. which should technically fail the update Snap. I added an error view to the salesforce update snap but it is not going to the error view. I tried logging the output after SFDC updated. ...

How can I throw a custom error if the filter snap lets through no records?

My pipe has a filter snap. I want to design it in a way that it throws a custom error when the filter snap does not let through any records.

SnapLogic - Integration Nation

Forum Posts

Jdbc insert snap account as auto commit is enabled

How to insert the NULL in place of no data in CSV input fields having no data?

Resolved! Create TrustStore & KeyStore Files From Certificate?

Inserting a line break while writing an excel file

JSON array from external to snaaplogic using triggered task

Return the status of executed Pipelines for the specified time within the Org

Pipeline not going to error view when SFDC update snap fails

How can I throw a custom error if the filter snap lets through no records?

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

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?