I’m converting CSV files to JSON and I want to extract only desired records from the files based on the first column.

 

I used ConvertCSVtoAvro and then ConvertAvroToJSON that that gave me JSON output that looks good.

 

[{"field1": "rtapushevq", "field2": "CONFCOAT_SIDE2", "field3": "PVA4", "field4": "ata", "field5": "NO", "field6": "151030.000027", "field7": "1", "field8": "28364681B620RR1519501012427601", "field9": "GFE_POWER", "field10": "GM"},{"field1": "rtapushevq", "field2": "SELSOLDERINSP", "field3": "SELSOLDERINSP1", "field4": "ata", "field5": "NO", "field6": "151030.000040", "field7": "1", "field8": "533052945601", "field9": "CHARGER_LVL", "field10": "BMW"},{"field1": "rtapushevq", "field2": "LVL_ASSY11", "field3": "LVL_STA11", "field4": "ata", "field5": "NO",

 

However, when I try to extract the value of field1 into an attribute using EvaluateJSONPath (looking at $.field1) it doesn’t appear to give me what I want. I suspect that is because the JSON is formatted as an array rather than one JSON object per input record.

 

Can you suggest a way to process the JSON output record-by-record?