Description
I am trying to build a ql.io script to transform various atom:feeds into JSON objects tailored for my Javascript applications.
Attached is a file containing a simple test feed (3 entries) that I put in a "testfeeds" directory in my local tomcat webapp directory for testing an to illustrate my question. (this file is attached in a post to ql.io discussion thread https://groups.google.com/forum/#!topic/qlio/88gb1mMfRds)
I would like to create a table that contains just the child content of the atom:content elements.
What I can do:
create table test.feed on select get from "http://localhost:8080/testfeed/test.xml";
select '$.atom:feed.atom:entry[*].atom:content.vsc:Thing' from test.feed;
The above script gives me the feed I want: an array of "Thing" resource representations serialized in JSON.
I would prefer to use something like:
create table test.feed on select get from "http://localhost:8080/testfeed/test.xml"
resultset "$.atom:feed.atom:entry[*].atom:content.vsc:Thing";
That way, downstream scripts are simpler and don't have to filter out the atom related markup surrounding the content I want to provide.
The best I have been able to do is to use a resultset using "atom:feed.atom:entry", but of course, because atom:entry is serialized as a JSON array, that is as far as I can go without JSONPath syntax.
Is there any chance that resultset clause syntax could be upgraded to be symmetric with the JSONPath capability available in the select statement?