Removing a column from JSON array
Hello. say i have the following JSON:
how can i remove one of the attributes / columns? Let’s say in the top left from the image above I want to remove the OwnerEmail value from that array… ho...
Forum Discussion
this isnt working for me!!
Could not compile expression: $group[].matchfield (Reason: Encountered extraneous input ‘[’ at line 1:6; expecting={, ‘||’, ‘&&’, ‘^’, ‘==’, ‘!=’, ‘>’, ‘<’, ‘>=’, ‘<=’, ‘+’, ‘-’, '', ‘/’, ‘%’, ‘?’, ‘instanceof’, ‘in’, ‘.’}; Resolution: Please check expression syntax)
Make sure the “Target Path” column in the mapper is cleared. Otherwise, the mapper will treat the first column as an expression, which is what it looks like is happening here. (When the Target Path is clear, the first column is treated as a JSON-Path that specifies what should be deleted in the input document).
How would you do this conditionally? Meaning, if the incoming value is NULL, remove the property?
