Json parse subvalues

Anonymous — Thu, 04 Apr 2019 16:10:31 GMT

Hello,

I am trying to parse the following json data:

{
"clinical_trials": {
"total": 1,
"results": [
{
"position": "Principal Investigator",
"title": "Combined Treatment With XYZ",
"study_phase": "Phase II",
"conditions": [
"AAAAA BBBBBB CCCCC"
],
"start_date": "2018-06-08T00:00:00",
"status": "Recruiting"
}
]
}
}

The output for "conditions" looks like this:

tInputFileJson

tExtractJson:

Here's the tInputFileJson component

Here's the tExtract component:

I have tried all sorts of variations on "conditions[*]" and so on but they either produce null or the data with the square brackets and quotes round it.

To be clear, there can be more than one value in the field.

Hope you can help.

Many thanks,

Bob.

Re: Json parse subvalues

Anonymous — Thu, 04 Apr 2019 19:33:05 GMT

Hi Bob,

I believe this one is a duplicate of the post below where you have already got the solution.

https://community.talend.com/t5/Design-and-Development/Json-parse-subvalues/m-p/157256#M96041

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

topic Re: Json parse subvalues in Talend Studio

Json parse subvalues

Re: Json parse subvalues