Yahoo! Query Language

Source: Wikipedia, the free encyclopedia.
"YQL" redirects here. Not to be confused with Lethbridge Airport.

Yahoo! Query Language (YQL) is an

mashups that enable developers to create their own applications[1] using Yahoo! Pipes
online tool.

Initially launched in October 2008 with access to Yahoo APIs,

Guardian, and The New York Times.[3] Some of these APIs still require an API key to access them. On April 29 of 2009, Yahoo introduced the capability to execute the tables of data built through YQL using JavaScript run on the company's servers for free.[3]
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.[4] 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

References

  1. PC World
    .
  2. ^ Kolakowski, Nicholas (April 29, 2009). "Yahoo Launches YQL Execute, Updates YSlow". eWeek. Archived from the original on July 31, 2012.
  3. ^
    ReadWriteWeb
    .
  4. ^ "YQL".

External links


Stub icon

This World Wide Web–related article is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=Yahoo!_Query_Language&oldid=1156287454"