JSON Object Diff
Is there a way to easily show what key values do not match between two JSON objects? If I have two objects with the same keys, can I output just the keys and values that do not match between the two ...
Forum Discussion
Hi alex_panganiban ,
You need to accesses to the memberId element of each object.
You can try with the following:
#foreach($memberIds in $members)
<b:guid>$memberIds.memberId</b:guid>
#end
BR.
Ivica
Hey Y'all, thank. you so much for your responses. I made a discovery of something that I wasn't aware of before asking this question. When the CSV Parser detects an error, one of the fields that is outputted in the error view is $original.record. Now that I know about this field, I can leverage it to determine which errors need to be reported and which errors may be ignored. Initially I had wanted to handle my error condition before the CSV Parser, but now I can handle it just as effectively post CSV Parser.
Again, thanks so much for your support. I really love this facility as I know I can always count on the community to help me solve any challenge.
Hey alex_panganiban,
You can trim the record to fit the headers, which will result in additional record with the hidden character as a value for the first column, in this case "employee_id".
From here, use Filter snap to exclude the records that doesn't have a "first_name" for example:
!$.hasPath('first_name')
Let me know if this works for you.
Regards,
Bojan
alex_panganiban - you can also use the "When errors occur" property in the Views tab of the CSV Parser snap to ignore errors during parsing or even route bad records to an error view and handle them more gracefully.
Hope this helps!
