Get current JSON document being inserted

[Mark]

I have a pipeline with a oracle insert snap and a error pipeline. Everything works. When something in the pipeline fails I am passing variables to the error pipeline and storing in a table. I want to pass the current JSON document that failed? What variable do I use to get the current JSON document that failed without having to concatenate all the values into a string myself? I want to pass the json document that failed to insert actually? I know its $.something but what?

[SpiroTaleski]

@Mark

You can find the data that failed under the original object.

ex: $original

Regards
Spiro Taleski

[Mark]

I put $original as the expression populating a error pipeline parameter in the pipeline properties of the pipeline. When I run the pipeline the pipeline complains “Reason: Value referenced in the sub-expression ‘$original’ is null”. ?

[SpiroTaleski]

@Mark

That will not work.

The main pipeline will propagate the error message(containing the error details along with original data) to the linked error pipeline.

In the error pipeline using Mapper Snap you can access all the fields from the error message.

Add Mapper Snap at error pipeline level and try to access the $original object.

If that will not work, please share the sample pipelines.

Regards,
Spiro Taleski

[Mark]

I have a mapper in the erorr pipeline. Let me try that.