Example: Reusing a YQL query

Setting Up the Query

The easiest way to build a YQL query is by visiting the YQL Console. In this example we will be using the flickr.photos.recent table. The YQL statement that we are using looks like this:

select * from flickr.photos.recent where (api_key = "1895311ec0d2e23431a6407f3e8dffcc")

Setting Up the YUI Instance

Now we need to create our YUI instance and tell it to load the yql and node modules.

YUI().use('node', 'yql');

Making the Query

Now that we have a YUI instance with the yql module, we can now make a query.

YUI().use('node', 'yql', function(Y) {
 
 var res = Y.one('#res'), count = 0,
 url = '<a href="http://flickr.com/photos/{owner}/{id}"><img src="http://static.flickr.com/{server}/{id}_{secret}_t.jpg"></a>';
 
 var q = Y.YQL('select * from flickr.photos.recent where (api_key = "1895311ec0d2e23431a6407f3e8dffcc")', {
 //Tell JSONP to not cache this request so we get new images on each request
 allowCache: false,
 on: {
 success: function(r) {
 count++;
 res.setHTML('<h2>Recent Flickr Photos <em>(query #' + count + ')</em></h2>');
 Y.each(r.query.results.photo, function(v) {
 res.append(Y.Lang.sub(url, v));
 });
 },
 failure: function() {
 res.setHTML('YQL is down at the moment. Please <a href="?mock=true">try this example with mocked data</a>.');
 }
 }
 });
 Y.later(8000, q, q.send, null, true);
});