Hi all,
I've just stumbled across YQL as a means of screen scraping HTML content from one site and displaying it in an XML web part on a SharePoint page.
...It is Awesome!
Try whacking the following URL in an XML web part to get an idea of what can be done:
http://query.yahooapis.com/v1/public/yql?q=SELECT%20*%20FROM%20html%20WHERE%20url%3D%22http%3A%2F%2Fpublic.ukcrn.org.uk%2FSearch%2FPortfolio.aspx%3Flevel1%3D2%22%20AND%20xpath%3D%22%2F%2Ftable%5B%40id%3D'ctl00_contentMain_gvStatsLevel2'%5D%22&format=xml
[You'll need to copy the entire URL there]
Now this table displays just fine, but the links in the source html page are all relative and are therefore broken in the context of the SP site.
If I knew XSL even a bit I am sure I could amend this XML output to prepend the URL of the source site.
BUT I am thinking this could also be an interesting use of JQUERY too?
Any ideas on a clever workaround here?
Cheers
Ben