I have been messing around with the JSONPath expressions but have not been able to get it to work.

JSON structure sample:


{
    "type": "Actors",
    "detail": [
        {
            "firstname": "Kevin",
            "lastname": "Smith",
            "movies": [
                {
                    "moviename": "Clerks",
                    "release": "1994",
                    "rating": "8",
                    "role": "Silent Bob"
                },
                {
                    "name": "Jay and Silent Strike Back",
                    "release": "2001",
                    "rating": "7",
                    "role": "Silent Bob"
                }
            ]
        },
        {
            "firstname": "Jason",
            "lastname": "Mewes",
            "movies": [
                {
                    "moviename": "Clerks",
                    "release": "1994",
                    "rating": "8",
                    "role": "Jay"
                },
                {
                    "name": "Jay and Silent Strike Back",
                    "release": "2001",
                    "rating": "7",
                    "role": "Jay"
                }
            ]
        }
    ]
}

I want my output to look like:
Actors|Kevin Smith | Clerks | 1994 |8| Silent Bob
Actors|Kevin Smith | Jay and Silent Strike Back |2001 | 7|Silent Bob
Actors|Jason Mewes | Clerks | 1994 |8| Jay
Actors|Jason Mewes | Jay and Silent Strike Back | 2001 |7| Jay

But right now I get an output more like this:
Actors|Kevin Smith | Clerks | 1994 |8| Silent Bob
|| Jay and Silent Strike Back | 2001 |7| Silent Bob
|| Clerks | 1994 |8| Jay
|| Jay and Silent Strike Back | 2001 |7| Jay


Also, even though my JSON is valid per lint, I sometimes get an error message: "The Json resource datas maybe have some problems, please make sure the data structure with the same fields."

Thanks,
Ben