Hi All,
I am working on extracting records on from a MySQL database and converting
the records to RDF. My processor workflow looks like this:
ExecuteSQL --> ConvetAvroToJSON --> SplitJSON
So far, I've managed to connect to the DB, and convert it to Avro. However,
I am failing on the spit step. I can't seem to get the JSONPath Expression
right.
The JSON data looks like this:
[{"provider_study_id": 1001},
{"provider_study_id": 1002},
{"provider_study_id": 1003}]
But, I can't seem to get the path expression correct to split the data.
I've tried:
${provider_study_id}
${"provider_study_id"}
[${"provider_study_id"}]
$.{"provider_study_id"}
The error message say the element cannot be found ...
Thanks for any help!
Bill