Movatterモバイル変換


[0]ホーム

URL:


Jump to content
WikipediaThe Free Encyclopedia
Search

Yahoo Query Language

From Wikipedia, the free encyclopedia
(Redirected fromYahoo! query language)
"YQL" redirects here and is not to be confused withLethbridge Airport.
SQL-like query language

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.

Examples

[edit]

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'

Rate limits

[edit]

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

[edit]

References

[edit]
  1. ^Perez, Juan Carlos (April 29, 2009)."Yahoo Extends YQL Web Data Query Platform".PC World.[permanent dead link]
  2. ^Kolakowski, Nicholas (April 29, 2009)."Yahoo Launches YQL Execute, Updates YSlow".eWeek. Archived fromthe original on July 31, 2012.
  3. ^abO'Dell, Jolie (May 2, 2009)."Developers: Never Mind the APIs, Here's YQL Execute".ReadWriteWeb.
  4. ^"YQL".

External links

[edit]
Current assets
Former assets
Related
Websites
Communication
Corporate
Defunct services
Related people
Related
Websites
Related
Former
Websites
Communication
Corporate
Defunct services
Related people
Related
In current use
Proprietary
Superseded


Stub icon

ThisWorld Wide Web–related article is astub. You can help Wikipedia byexpanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=Yahoo_Query_Language&oldid=1276515340"
Categories:
Hidden categories:

[8]ページ先頭

©2009-2025 Movatter.jp