Yahoo! Query Language (YQL) is an SQL-like

query language Query languages, data query languages or database query languages (DQL) are computer languages used to make queries in databases and information systems. A well known example is the Structured Query Language (SQL). Types Broadly, query language ...

created by

Yahoo! Yahoo! (, styled yahoo''!'' in its logo) is an American web services provider. It is headquartered in Sunnyvale, California and operated by the namesake company Yahoo! Inc. (2017–present), Yahoo Inc., which is 90% owned by investment funds ma ...

as part of their Developer Network. YQL is designed to retrieve and manipulate data from

API An application programming interface (API) is a way for two or more computer programs to communicate with each other. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how ...

s through a single Web interface, thus allowing mashups that enable developers to create their own applications using Yahoo! Pipes online tool. Initially launched in October 2008 with access to Yahoo APIs, February 2009 saw the addition of open

data table A table is an arrangement of information or data, typically in rows and columns, or possibly in a more complex structure. Tables are widely used in communication, research, and data analysis. Tables appear in print media, handwritten notes, comp ...

s 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 progr ...

, 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, Unite ...

'', and ''

The New York Times ''The New York Times'' (''the Times'', ''NYT'', or the Gray Lady) is a daily newspaper based in New York City with a worldwide readership reported in 2020 to comprise a declining 840,000 paid print subscribers, and a growing 6 million paid ...

''. Some of these APIs still require an

API key An application programming interface (API) key is a unique identifier used to authenticate a user, developer, or calling program to an API. However, they are typically used to authenticate a ''project'' with the API rather than a human user. Diffe ...

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 that is one of the core technologies of the World Wide Web, alongside HTML and CSS. As of 2022, 98% of Website, websites use JavaScript on the Client (computing), client side ...

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.

References

External links

Official site

Query languages Web scraping {{www-stub

Examples

Rate limits

See also

References

External links