Forum Discussion

Mark's avatar
Mark
New Contributor II
4 years ago
Solved

Get current JSON document being inserted

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 wan...
  • Mark's avatar
    Mark
    4 years ago

    I had to do this JSON.stringify($original), but that worked. Using $original caused insertion problems into a varchar2 or clob because it wasnt the same datatype. But, your recommendation to put it in the mapper snap of the error pipeline worked out great because I only had to change the one error pipeline and not all 20 or so pipelines that call the error pipeline. Thanks

Mark's avatar
Mark
New Contributor II
4 years ago

I had to do this JSON.stringify($original), but that worked. Using $original caused insertion problems into a varchar2 or clob because it wasnt the same datatype. But, your recommendation to put it in the mapper snap of the error pipeline worked out great because I only had to change the one error pipeline and not all 20 or so pipelines that call the error pipeline. Thanks