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

Reply via email to