<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Example: Simple YQL Query</title>
<link rel="stylesheet" href="http://fonts.googleapis.com/css?family=PT+Sans:400,700,400italic,700italic">
<link rel="stylesheet" href="../../build/cssgrids/cssgrids-min.css">
<link rel="stylesheet" href="../assets/css/main.css">
<link rel="stylesheet" href="../assets/vendor/prettify/prettify-min.css">
<link rel="shortcut icon" type="image/png" href="../assets/favicon.png">
<script src="../../build/yui/yui-min.js"></script>
</head>
<body>
<!--
<a href="https://github.com/yui/yui3"><img style="position: absolute; top: 0; right: 0; border: 0;" src="https://s3.amazonaws.com/github/ribbons/forkme_right_darkblue_121621.png" alt="Fork me on GitHub"></a>
-->
<div id="doc">
<div id="hd">
<h1><img src="http://yuilibrary.com/img/yui-logo.png"></h1>
</div>
<h1>Example: Simple YQL Query</h1>
<div class="yui3-g">
<div class="yui3-u-3-4">
<div id="main">
<div class="content"><div class="intro">
<p>In this example, we make a simple YQL Query to retrieve data from the Yahoo! Weather YQL table.</p>
</div>
<div class="example">
<style>
#res .mod {
background-color:white;
border:1px solid black;
padding:1em;
}
#res h2 {
color: black;
}
</style>
<div id="res">Querying YQL..</div>
<script>
YUI().use('node', 'yql', function(Y) {
var res = Y.one('#res'),
zip = '90210';
Y.YQL('select * from weather.forecast where location=' + zip, function(r) {
var el = Y.Node.create('<div class="mod"></div>');
el.set('innerHTML', '<h2>Weather for ' + zip + '</h2>' + r.query.results.channel.item.description);
res.setHTML(el);
});
});
</script>
</div>
<p>The easiest way to build a YQL query is by visiting the <a href="http://developer.yahoo.com/yql/console/">YQL Console</a>. In this example we will be using the <code><a href="http://developer.yahoo.com/yql/console/#h=select%20*%20from%20weather.forecast%20where%20location%3D90210">weather.forecast</a></code> table. The <code>YQL</code> statement that we are using looks like this:</p>
<pre class="code prettyprint">select * from weather.forecast where location=90210</pre>
<p>You can <a href="http://developer.yahoo.com/yql/console/?q=SELECT%20*%20FROM%20weather.forecast%20WHERE%20location%3D90210" title="YQL Console">preview this query in the YQL Console</a> to get a sense of the data it returns.</p>
<h3>Setting Up the YUI Instance</h3>
<p>Now we need to create our YUI instance and tell it to load the <code>yql</code> and <code>node</code> modules.</p>
<pre class="code prettyprint">YUI().use('node', 'yql');</pre>
<h3>Making the Query</h3>
<p>We now have a YUI instance with the <code>yql</code> module (and its dependencies) attached, so we can proceed to make a query.</p>
<pre class="code prettyprint">YUI().use('node', 'yql', function(Y) {
var res = Y.one('#res'),
zip = '90210';
Y.YQL('select * from weather.forecast where location=' + zip, function(r) {
var el = Y.Node.create('<div class="mod"></div>');
el.set('innerHTML', '<h2>Weather for ' + zip + '</h2>' + r.query.results.channel.item.description);
res.setHTML(el);
});
});</pre>
</div>
</div>
</div>
<div class="yui3-u-1-4">
<div class="sidebar">
<div class="sidebox">
<div class="hd">
<h2 class="no-toc">Examples</h2>
</div>
<div class="bd">
<ul class="examples">
<li data-description="Create a simple YQL Query to retrieve data from the Yahoo! Weather YQL table.">
<a href="simple-yql.html">Simple YQL Query</a>
</li>
<li data-description="Use the Flickr Recent Photos YQL table to pull in a small set of recent Flickr images every 8 seconds.">
<a href="yql-requery.html">Reusing a YQL query</a>
</li>
</ul>
</div>
</div>
<div class="sidebox">
<div class="hd">
<h2 class="no-toc">Examples That Use This Component</h2>
</div>
<div class="bd">
<ul class="examples">
<li data-description="Example Photo Browser application.">
<a href="../dd/photo-browser.html">Photo Browser</a>
</li>
<li data-description="Portal style example using Drag & Drop Event Bubbling and Animation.">
<a href="../dd/portal-drag.html">Portal Style Example</a>
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
<script src="../assets/vendor/prettify/prettify-min.js"></script>
<script>prettyPrint();</script>
<script>
YUI.Env.Tests = {
examples: [],
project: '../assets',
assets: '../assets/yql',
name: 'simple-yql',
title: 'Simple YQL Query',
newWindow: '',
auto: false
};
YUI.Env.Tests.examples.push('simple-yql');
YUI.Env.Tests.examples.push('yql-requery');
YUI.Env.Tests.examples.push('photo-browser');
YUI.Env.Tests.examples.push('portal-drag');
</script>
<script src="../assets/yui/test-runner.js"></script>
</body>
</html>