YQL allows to retrieve and select data from an XML-table, using the 'xml' open table. E.g. like this:
select edition.biblija-api from xml where url="http://www.dezuidelijkenederlanden.org/Books.xml" and edition.biblija-abbr="WEB"
Is it also possible to perform a similar selection on xml-data stored on yql.storage?
I've stored the same table as above on yql.storage.admin like this:
insert into yql.storage.admin (url) values ("http://www.dezuidelijkenederlanden.org/Books.xml")
I can retrieve the data using following statement, but it's giving me the xml-encoded version of the xml-data in the results, and if I specify an element name in the select statement, the results are empty.
select * from yql.storage where name="store://Ng1jFUQURtdsia9QKYnZWU"
response.object = eval("var a = " + xmlstring + ";a");
thanks for the answer. I was thinking that I missed the obvious straightforward solution, but maybe there isn't.