Drupal and external data

Hi everyone -

I've researched this question for several days and have been unable to find a solution either built into Drupal or available as an add-on module. I'm looking to see if someone knows of a module that will allow me to provide the following functionality within Drupal. Custom coding in PHP isn't an option unless it's less than 10 lines of code.

Here's what needs to be accomplished: There are several external web services that I would like to access from Drupal. These are transactional (dynamic) services that expose data and CRUD functions via REST. Output from the web services can be pretty much whatever I need it to be (XML, JSON, etc.) The schema of the output of each REST service can be provided to the client applications. If I want to use Drupal:

I need to be able to contact these web services,
Dynamically draw high-functionality "lists" or "tables" just like those provided by Views,
Dynamically draw (or predefine a la Web Forms) forms that contain data from the web service,
Forms need to be able to pass back changes via REST,
Due to issues beyond my control, IFRAMEs are not an option.

Drupal has many options to export data as a web service but I can't find a single module to bring in data and display it. Views are exactly what I'm looking for in a "list" UI within Drupal but Views demand that data is in the local SQL data store. Web Forms give me 90% of what I'm looking for (to provide CRUD) but would require more custom coding than I'm allowed to spend time on to modify the module to read/write from/to REST services.

It seems that Drupal is very anemic in regards to bringing in external data that isn't SQL based. Durpal gives me 75% of the functionality I need for my project (the CMS stuff - static pages, CCK, Views, user management, etc) but it seems like this 25% I need will be next to impossible to provide without leveraging Drupal's APIs for forms, etc.

Does anyone have any ideas? I appreciate any thoughts you have.

Thanks!

zpf