Designing and Running Pipelines

Failure: Related External ID: Cannot lookup a property on a null value, Reason: Value referenced in the sub-expression

Hi all, I am trying to conduct an upsert operation on a child record in Salesforce. I have defined the External ID for the record and the related object but keep receiving this message: Failure: Related External ID: Cannot lookup a property on a null...

Unable to do error view writing as the error record is not showing in preview

Hi All, I am trying to process millions of records even sometimes in billions. While validation, I am not seeing preview coming up for error view as we have 2000 limitation in preview. When I execute the pipeline, I am getting failure saying few inco...

How to generate p12 certificate for snaplogic triggered task

Hello Experts, Can we generate p12 certificate for snaplogic triggered task ? Regards, Ajay

JDBC Execute Snap

Hi All, We are facing the below error message when we use the JDBC Execute Snap. Can you please help us out with the error. We are trying to capture the value in @result. It is not returning the value instead we are getting the Status as -2 and Mess...

Error View : State always captured as 'Completed'

Hi all, We are trying to use the Pipeline Monitoring API in our implementation to trace which of the service calls have failed, using e.g. ___https://elastic.snaplogic.com/api/1/rest/public/runtime/Partners?last_hours=100&state=Completed,Failed,Stop...

How to log the Raw request sent by HTTP Get snap to end point?

I have a HTTP GET snap to send requests to Zendesk API. But sporadically, it fails saying “REST API service endpoint returned error result: status code = 422, reason phrase = Unprocessable Entity, refer to the error_entity field in the error view doc...

CLI for BCP (SQL SVR) and dynamic file names

The scenario I needed to accomplish was to pull data from SQL server, group the data sets together based on different fields and then dynamically define the file name based on those groupings. Performance was the #1 consideration and competitive tool...

Allow pipeline execution on the basis of expression result of previous snap

How can I allow a pipeline to continue execute/not execute on the basis of the result of expression value of previous snap. For example: I wan to continue pipeline execution only if there are some records exists in the csv file which I read in previo...

SnapLogic - Integration Nation

Forum Posts

Failure: Related External ID: Cannot lookup a property on a null value, Reason: Value referenced in the sub-expression

Unable to do error view writing as the error record is not showing in preview

How to generate p12 certificate for snaplogic triggered task

JDBC Execute Snap

Error View : State always captured as 'Completed'

How to log the Raw request sent by HTTP Get snap to end point?

CLI for BCP (SQL SVR) and dynamic file names

Allow pipeline execution on the basis of expression result of previous snap

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