Yahoo! Query Language (YQL) is anSQL-likequery language created byYahoo! as part of theirDeveloper Network. YQL is designed to retrieve and manipulate data fromAPIs through a single Web interface, thus allowingmashups that enable developers to create their own applications[1] usingYahoo! Pipes online tool.
Initially launched in October 2008 with access to Yahoo APIs,[2] February 2009 saw the addition of opendata tables from third parties such asGoogle Reader, theGuardian, andThe New York Times.[3] Some of these APIs still require anAPI key to access them. On April 29 of 2009, Yahoo introduced the capability to execute the tables of data built through YQL usingJavaScript run on the company's servers for free.[3] On January 3, 2019, Yahoo retired the YQL API service.
Filter RSS feeds
selecttitle,linkfromrsswhereurl='https://www.engadget.com/rss.xml'
Convert CSV to JSON or XML
select*fromcsvwhereurl='http://download.finance.yahoo.com/d/quotes.csv?s=YHOO,GOOG,AAPL&f=sl1d1t1c1ohgv&e=.csv'andcolumns='symbol,price,date,time,change,col1,high,low,col2'
Extract HTML via CSS Selectors
SELECT*FROMdata.html.cssselectWHEREurl='http://www.w3.org/'ANDcss='ul.theme'
Get AppLinks meta data
SELECT*fromapplinksWHEREurlIN('movietickets.com','pinterest.com')
Parse any XML source
selectStatus.presencefromxmlwhereurl='http://mystatus.skype.com/pjjdonnelly.xml'andStatus.presence.lang='en'
Use of the YQL should not exceed reasonable request volume.[4] Access is limited as below:
![]() | ThisWorld Wide Web–related article is astub. You can help Wikipedia byexpanding it. |