Yahoo! Query Language (YQL) is an
SQL
Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel")
is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...
-like
query language
A query language, also known as data query language or database query language (DQL), is a computer language used to make queries in databases and information systems. In database systems, query languages rely on strict theory to retrieve informa ...
created by
Yahoo!
Yahoo (, styled yahoo''!'' in its logo) is an American web portal that provides the search engine Yahoo Search and related services including My Yahoo, Yahoo Mail, Yahoo News, Yahoo Finance, Yahoo Sports, y!entertainment, yahoo!life, and its a ...
as part of their
Developer Network. YQL is designed to retrieve and manipulate data from
API
An application programming interface (API) is a connection between computers or between computer programs. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how to build ...
s through a single Web interface, thus allowing
mashups that enable developers to create their own applications using
Yahoo! Pipes
Yahoo! Pipes was a web application from Yahoo! that provided a graphical user interface for building data Mashup (web application hybrid), mashups that aggregate web feeds, web pages, and other services; creating Web-based apps from various sour ...
online tool.
Initially launched in October 2008 with access to Yahoo APIs, February 2009 saw the addition of open
data tables from third parties such as
Google Reader
Google Reader was an RSS/Atom feed aggregator operated by Google. It was created in early 2005 by Google engineer Chris Wetherell and launched on October 7, 2005, through Google Labs. Google Reader grew in popularity to support a number of pr ...
, the ''
Guardian
Guardian usually refers to:
* Legal guardian, a person with the authority and duty to care for the interests of another
* ''The Guardian'', a British daily newspaper
(The) Guardian(s) may also refer to:
Places
* Guardian, West Virginia, Unit ...
'', and ''
The New York Times
''The New York Times'' (''NYT'') is an American daily newspaper based in New York City. ''The New York Times'' covers domestic, national, and international news, and publishes opinion pieces, investigative reports, and reviews. As one of ...
''.
Some of these APIs still require an
API key
An application programming interface (API) key is a secret unique identifier used to authenticate and authorize a user, developer, or calling program to an API.
Cloud computing providers such as Google Cloud Platform and Amazon Web Services reco ...
to access them. On April 29 of 2009, Yahoo introduced the capability to execute the tables of data built through YQL using
JavaScript
JavaScript (), often abbreviated as JS, is a programming language and core technology of the World Wide Web, alongside HTML and CSS. Ninety-nine percent of websites use JavaScript on the client side for webpage behavior.
Web browsers have ...
run on the company's servers for free.
On January 3, 2019, Yahoo retired the YQL API service.
Examples
Filter RSS feeds
select title, link from rss where url = 'https://www.engadget.com/rss.xml'
Convert CSV to JSON or XML
select * from csv where url='http://download.finance.yahoo.com/d/quotes.csv?s=YHOO,GOOG,AAPL&f=sl1d1t1c1ohgv&e=.csv' and columns='symbol,price,date,time,change,col1,high,low,col2'
Extract HTML via CSS Selectors
SELECT * FROM data.html.cssselect WHERE url='http://www.w3.org/' AND css='ul.theme'
Get AppLinks meta data
SELECT * from applinks WHERE url IN ('movietickets.com', 'pinterest.com')
Parse any XML source
select Status.presence from xml where url = 'http://mystatus.skype.com/pjjdonnelly.xml' and Status.presence.lang = 'en'
Rate limits
Use of the YQL should not exceed reasonable request volume.
Access is limited as below:
* Per application limit (identified by your Access Key): 100,000 calls per day;
* Per IP limits: /v1/public/*: 2,000 calls per hour; /v1/yql/*: 20,000 calls per hour.
See also
*
SQL
Structured Query Language (SQL) (pronounced ''S-Q-L''; or alternatively as "sequel")
is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling s ...
*
WSO2 Mashup Server
*
Yahoo! Pipes
Yahoo! Pipes was a web application from Yahoo! that provided a graphical user interface for building data Mashup (web application hybrid), mashups that aggregate web feeds, web pages, and other services; creating Web-based apps from various sour ...
References
External links
Official site
query language
A query language, also known as data query language or database query language (DQL), is a computer language used to make queries in databases and information systems. In database systems, query languages rely on strict theory to retrieve informa ...
Query languages
Web scraping
{{www-stub