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": "Jason",
"lastname": "Mewes",
"movies":
}
]
}
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
Hi All
For your information, we will enhance this component on v5.3.0, see
jira issue.
This modification might be available in next release, we sincerely invite you to test the changes and feedback to us!
Shong
We are using Talend 6.3.1 and still get the same error for tFileInputJSON (screenshot attached) even though the source json is valid. The input file has 346 records, but only 329 records come out before the job throws below log:
[statistics] connecting to socket on port 3604 [statistics] connected [WARN ]: renew_checks_0_1.Renew_Checks - tFileInputJSON_1 - The Json resource datas maybe have some problems, please make sure the data structure with the same fields. 1296 milliseconds [statistics] disconnected
