Yahoo Query Language: Difference between revisions

Browse history interactively

← Previous edit

Content deleted Content added

VisualWikitext

Revision as of 04:02, 28 November 2020 edit Sammi Brie (talk \| contribs) Autopatrolled, Extended confirmed users, Page movers, File movers, New page reviewers, Pending changes reviewers, Rollbackers, Template editors, Temporary account IP viewers 159,377 edits Adding short description: "SQL-like query language" (Shortdesc helper) ← Previous edit		Latest revision as of 08:28, 19 February 2025 edit undo InternetArchiveBot (talk \| contribs) Bots, Pending changes reviewers 5,692,122 edits Rescuing 0 sources and tagging 1 as dead.) #IABot (v2.0.9.5) (LeapTorchGear - 22831
(9 intermediate revisions by 8 users not shown)
Line 1: {{short description\|SQL-like query language}}▼ {{Redirect-distinguish\|YQL\|Lethbridge Airport}} ▲{{short description\|SQL-like query language}} '''Yahoo! Query Language''' ('''YQL''') is an [[SQL]]-like [[query language]] created by [[Yahoo!]] as part of their [[Yahoo! Developer Network\|Developer Network]]. YQL is designed to retrieve and manipulate data from [[API]]s through a single Web interface, thus allowing [[mashup (digital)\|mashups]] that enable developers to create their own applications.<ref>{{cite news \|url=https://www.pcworld.com/article/164067/yahoo_extends_yql_web_data_query_platform.html \|work=[[PC World (magazine)\|PC World]] \|title=Yahoo Extends YQL Web Data Query Platform \|date=April 29, 2009 \|last=Perez \|first=Juan Carlos }}{{Dead link\|date=February 2025 \|bot=InternetArchiveBot \|fix-attempted=yes }}</ref> using [[Yahoo! Pipes]] online tool. Initially launched in October 2008 with access to Yahoo APIs,<ref>{{cite news \|url=http://www.eweek.com/c/a/Application-Development/Yahoo-Launches-YQL-Execute-Updates-YSlow-660481/ \|archive-url=https://archive.today/20120731002123/http://www.eweek.com/c/a/Application-Development/Yahoo-Launches-YQL-Execute-Updates-YSlow-660481/ \|url-status=dead \|archive-date=July 31, 2012 \|work=[[eWeek]] \|title=Yahoo Launches YQL Execute, Updates YSlow \|last=Kolakowski \|first=Nicholas \|date=April 29, 2009 }}</ref> February 2009 saw the addition of open [[data table]]s from third parties such as [[Google Reader]], the ''[[Guardian newspaper\|Guardian]]'', and ''[[The New York Times]]''.<ref name="rww"/> 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.<ref name="rww">{{cite news \|url=http://www.readwriteweb.com/archives/theres_a_great_amount_of.php \|work=[[ReadWriteWeb]] \|last=O'Dell \|first=Jolie \|date=May 2, 2009 \|title=Developers: Never Mind the APIs, Here's YQL Execute }}</ref>. On January 3, 2019, Yahoo retired the YQL API service. ==Examples== Filter RSS feeds <syntaxhighlight lang="sql">select title, link from rss where url = 'https://www.engadget.com/rss.xml')</syntaxhighlight> Convert CSV to JSON or XML