You can import public JSON/XML/CSV/HTML(and other) data.

You can connect/import private stuff with the Secure Data Connector, though I don't know all the types supported.

http://code.google.com/securedataconnector/docs/1.3/overview...

You can get everything out w/the API, too.