We were trying to get the first name and middle name parsed out of an embedded array object using the json parser, but for some reason, anytime we called name_info.name It would only return the middle name, we saw this patter on all records, if name has middle name, then middle name only would show, if no middle name, then first name would show. With the json parser, it should have returned one line for first name and one line for middle but it didnt

Solution: 

create a data stream that goes from root into name, then for the attributes in that data stream, you will use an @ as the path for the attribute. This will then give you a separate line for first and middle name. The documentation for 13 has this, but since we were working with 12.6 we went through trail and error

"name_info": n
           {
               "name": a
                      "John",
                      "A"
                     ]

            }
]

Data structure example