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.1 person found this helpful
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.
Thank you for the link, was quite a lot of good stuff to read there, will surely help me out in a way or 2.
If anyone else has experience, feel free to share :)
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/