Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Output
[statistics] connected
1|Principal Investigator|AAAAA BBBBBB CCCCC
1|Principal Investigator|AAAAA BBBBBB CCCCD
[statistics] disconnected
Output
[statistics] connected
1|Principal Investigator|AAAAA BBBBBB CCCCC
1|Principal Investigator|AAAAA BBBBBB CCCCD
[statistics] disconnected
Perfect!
Thank you.