This tutorial shows you how to run YQL statements and examine the resulting data with the YQL Console.
select * from geo.places where text="san francisco, ca"
This SELECT statement requests geo data about San Francisco. The "*" indicates that all
fields of the
geo.places table will be returned. In the filter
of the WHERE clause, the string "san francisco, ca" is the value of the search query.
geo.placestable is in the
resultselement. To get the response in JSON format, select the JSON radio button and click TEST.
select name, country from geo.places where text="san francisco, ca"
Make sure that
country are lowercase.
Unlike SQL, in YQL the field and table names are case sensitive.
placefields should only have the
To call the YQL Web Service, an application would call an HTTP
method on this URL. The
q parameter in the URL matches the SELECT
statement displayed under Your YQL Statement (except that
characters such as spaces are URL encoded). The COPY URL
button copies this URL to your clipboard, so that you can paste it into the source code of
geo.places, then click desc. On the TREE VIEW tab, take a look at these nodes: "query->results->table". The nodes under the "table" node contain information such as meta-data and search fields (input keys). For more information on input keys, see Remote Filters.