Oracle Insert Snap - BatchUpdateException: ORA-01438

@Charles,
Like Patrick, I was also thinking Velocity (VTL) as a solution, but as I tried to solution your original post, the Workday namespace convention in the property names adds some complexity. I don’t know if Velocity beats the null-safe mapper for your particular use case, but it can be good info for your tool belt in the future.

The kind of ugly solution I came up with (in a one-liner) is:

[
    {
       "output" : #set ($pd = $['wd:Project_Data']) #set ($ed = $pd['wd:End_Date']) #if (${ed}) ${ed} #else null #end
    }
]

I’m not well versed in VTL, so there’s likely something a little cleaner than the above.