You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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?
The text was updated successfully, but these errors were encountered:
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?
The text was updated successfully, but these errors were encountered: