This content has been marked as final. Show 3 replies
I haven't done actual JSON work using Apex yet (although I have done quite a bit using servlets) I have found packages that allow you to work with JSON objects from within PL/SQL. You might want to check out a couple listed here.
I would try creating an on-demand process that accepts the JSON string as a parameter, then parse it within PL/SQL.
Hope this helps.
You should be able to create a web-service reference and then invoke the web service and extract the values in plsql.
See Creating a RESTful Web Service Reference
and also http://sourceforge.net/projects/pljson/