Most of you should be familiar with it, do you remember 'select * from internet' ? You could pick data from different sources, mashup it, mix, filter, etc. But also create new content sources, this makes you the ability to turn ANY (yes in capital case) digital resource (an api, html, csv, what ever!!) into a YQL content source.
And after some lines of table definition, 5 minutes , a new table was born, the 'execute' table, it's included in the community open tables, so once you are in the console, click on 'Show Community Tables' and you will be ready to use it.
- code: With this parameter you directly write inline the code to be executed.
- file: You specify a url or a YQL internal storage key where your code resides.
You can use both parameters as well, first will be executed the code in the 'file' parameter and after that the 'code' one.
How queries look like:
select * from execute where code="response.object=<hello><world/></hello>;"
select * from execute where file="http://myserver/myfile.js"
And now why use this?
- YQL prototyping. This is really helpful for people that use extremely YQL, and deal with the infamous and loved 'execute' block. Will reduce considerably your development time. In conjunction with Sam's Pullara yql storage editor, is the definitive tool to work with YQL.
Hope you liked it, happy hacking!!