APEX

Hello everyone.

I'm using Apex 4.0.1 against Oracle 10.2.0.5 on a Solaris server and using OAS (mod_plsql).

I've created an Apex form on which I present users with a url. When users click the url, a .php file is retrieved containing a JSON object consisting of data that was retrieved from a MySQL database.
The url and the retirieved .php file is being provided by another organization, and so, I have no control over how this data is being sent.

The way things are now, the browser (IE or Firefox, latest versions) prompts users to save the file to disk. Then I have to provide a way to navigate to the save directory, upload the .php file, and finally parse through it so as to display the data in a report.

Instead, I would like a way to seamlessly capture/read this JSON data without having to first save to disk followed by an upload. I am aware of the open source PLSQL package PL/JSON that I can use to parse through the JSON data. It's just that the "workflow" here is laborious (save to disk followed by navigate to file).

Would someone know of a seamless way to read a file retrieved via a url?

Thanks in advance for any help - pointers - code.

Elie