Forum Discussion

tarena's avatar
tarena
New Contributor III
3 years ago
Solved

Failure: Unable to write to JSON-Path

JSON Path Test_2023_03_28.slp (6.4 KB) GOAL: Set up a mapper to write input document structure to new structure, deleting some paths, and renaming others. ERROR: “Failure: Unable to write to JSON...
mapper
  • tarena's avatar
    tarena
    3 years ago

    I figured this one out. You can’t add paths to null objects.

    Since ACHData is null for the second record, it’s impossible to add ACHData.employeeId. If I reverse the order of the rows in the mapper then the result is that ACHData is null for the record, because ACHData.employeeId is set by the first row and then everything is cleared by the second row.

    This is currently undocumented behavior.

tarena's avatar
tarena
New Contributor III
3 years ago

I figured this one out. You can’t add paths to null objects.

Since ACHData is null for the second record, it’s impossible to add ACHData.employeeId. If I reverse the order of the rows in the mapper then the result is that ACHData is null for the record, because ACHData.employeeId is set by the first row and then everything is cleared by the second row.

This is currently undocumented behavior.