Yahoo! Query Language
   HOME

TheInfoList



OR:

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