Yahoo Query Language

"YQL" redirects here. Not to be confused with Lethbridge Airport.

Yahoo! Query Language (YQL) is an SQL-like query language created by Yahoo! as part of their Developer Network. YQL is designed to retrieve and manipulate data from APIs through a single Web interface, thus allowing 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,[2] February 2009 saw the addition of open data tables from third parties such as Google Reader, the 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. ^ Perez, Juan Carlos (April 29, 2009). "Yahoo Extends YQL Web Data Query Platform". PC World.
  2. ^ Kolakowski, Nicholas (April 29, 2009). "Yahoo Launches YQL Execute, Updates YSlow". eWeek. Archived from the original on July 31, 2012.
  3. ^ a b O'Dell, Jolie (May 2, 2009). "Developers: Never Mind the APIs, Here's YQL Execute". ReadWriteWeb.
  4. ^ "YQL".


Stub icon

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

Read other articles:

Toke Makinwa

Artikel ini sebatang kara, artinya tidak ada artikel lain yang memiliki pranala balik ke halaman ini.Bantulah menambah pranala ke artikel ini dari artikel yang berhubungan atau coba peralatan pencari pranala.Tag ini diberikan pada Desember 2023. Toke MakinwaToke MakinwaLahir03 November 1984 (umur 39)[1]LagosAlmamaterUniversity of LagosPekerjaanPembawa acaravloggerpengusahapenulisTahun aktif2010–sekarangSuami/istriMaje Ayida ​(m. 2014⁠–Ȇ...

 

Lucian Pulvermacher

Lucian PulvermacherPaus Pius XIIIGerejaGereja Katolik SejatiAwal masa kepausan24 Oktober 1998[1]Akhir masa kepausan30 November 2009Jabatan tandingan Yohanes Paulus II Benediktus XVI Informasi pribadiNama lahirEarl PulvermacherLahir(1918-04-20)20 April 1918Rock, Wood County, Wisconsin, Amerika SerikatWafat30 November 2009(2009-11-30) (umur 91)Springdale, Stevens County, Washington, Amerika Serikat Lucian Pulvermacher (nama lahir Earl Pulvermacher, 20 April 1918 – 3...

 

Kain dan Habel

Untuk tokoh-tokoh ini dalam sudut pandang Islam, lihat Qabil dan Habil. Untuk serial televisi Korea Selatan, lihat Cain and Abel. Detail Ghent Altarpiece (1432) di Katedral Santo Bavo. Kain dan Habel adalah masing-masing anak pertama dan kedua dari pasangan manusia pertama, Adam dan Hawa. Mereka dilahirkan setelah kejatuhan manusia ke dalam dosa (satu-satunya anak Adam dan Hawa yang lain yang disebut dalam Alkitab adalah Set). Cerita mereka dikisahkan dalam Alkitab Ibrani dan Perjanjian Lama ...

Provinsi Çorum

Çorum provinceProvince of TurkeyLocation of Çorum Province in TurkeyCountryTurkeyRegionBlack SeaLuas • Total12,820 km2 (4,950 sq mi)Populasi (2010-12-31)[1] • Total535.405 • Kepadatan42,000/km2 (110,000/sq mi)Kode area telepon0364Pelat kendaraan19Situs webçorum.gov.tr Çorum (Turki: Çorum İli) adalah sebuah provinsi Turki. lbsDaftar provinsi Turki Adana · Adıyaman · Afyonkarahisar · ...

 

Pendamping lokal desa

Pendamping lokal desa atau PLD adalah sebuah jabatan sebagai Pendamping desa di bawah Kementerian Desa, Pembangunan Daerah Tertinggal dan Transmigrasi Indonesia yang pembentukannya berdasarkan Undang-Undang Desa, yang bertugas untuk meningkatkan keberdayaan masyarakat dan sebagai fasilitator di sebuah desa. Sebuah ilustrasi suasana pelantikan Pendamping Lokal Desa di Jawa Tengah. Tugas Pendamping Lokal Desa No Tugas Pokok Langkah Kerja Output Kerja a) melakukan fasilitasi perencanaan pembangu...

 

ميكانيكا الأوساط المتصلة

ميكانيكا الأوساط المتصلةجزء من continuum physics (en) — ميكانيكا الموضوع continuum (en) تعديل - تعديل مصدري - تعديل ويكي بيانات تعتبر ميكانيكا الأوساط المتصلة (وأحيانا يطلق عليها الميكانيكا الاستمرارية) أحد فروع الفيزياء تحديدا الميكانيكا، حيث تقوم بدراسة المادة المتصلة بما فيها الأجسام...

Into the Flames

Into the FlamesPoster promosi untuk Into the FlamesGenreDrama sejarahDitulis olehJung Sung-hee Lee Han-hoSutradaraKim Sang-raePemeranChoi Soo-jong Ryu Jin Son Tae-young Lee In-hyeNegara asalKorea SelatanBahasa asliKoreaJmlh. episode20ProduksiProduser eksekutifChoi Byung-hwaProduserJung Hoe-seok Lee Kyung-seon Jung Hyung-seoLokasi produksiKoreaDurasiJumat dan Sabtu pukul 23:00 (WSK)Rumah produksiKangho ProductionRilis asliJaringanTV ChosunRilis25 April (2014-04-25) –28 Juni 2014&#...

 

Marianas Trench Marine National Monument

US national monument in the Mariana Archipelago Marianas Trench Marine National MonumentIUCN category V (protected landscape/seascape)[1]Marianas Trench Marine National MonumentMariana TrenchLocation of Marianas Trench in the Pacific OceanShow map of Pacific OceanMariana TrenchMariana Trench (Northern Mariana Islands)Show map of Northern Mariana IslandsLocationMariana Archipelago, Commonwealth of the Northern Mariana Islands and GuamNearest cityCapitol Hill, Saipan, Northern Mari...

 

Humbert II (roi d'Italie)

Pour les articles homonymes, voir Humbert, Humbert II et Humbert de Savoie. Humbert II(it) Umberto II Humbert de Savoie photographié par Alfred Reuben Tanner en 1944. Titre Prétendant au trône d'Italie 18 juin 1946 – 18 mars 1983 (36 ans et 9 mois) Prédécesseur Lui-même (roi d'Italie) Successeur Victor-Emmanuel de Savoie, duc de Savoie, prince de Naples Roi d'Italie 9 mai – 18 juin 1946(1 mois et 9 jours) Président du Conseil Alcide De Gasperi Prédécesseur Vi...

Sean Solomon

American planetary scientist Sean SolomonBornSean Carl Solomon (1945-10-24) October 24, 1945 (age 78)Los Angeles, CaliforniaNationalityAmericanAlma materCalifornia Institute of Technology Massachusetts Institute of TechnologyKnown forScience lead for MESSENGER and director of the Department of Terrestrial Magnetism at the Carnegie Institution for ScienceAwardsG. K. Gilbert Award, Arthur L. Day Prize and Lectureship, National Medal of Science (2012)Scientific careerFieldsPlaneta...

 

Mount Rushmore

Mountain in the US featuring a sculpture of four presidents For the band, see Mount Rushmore (band). Mount Rushmore National MemorialShrine of DemocracyTȟuŋkášila ŠákpeMount Rushmore features Gutzon Borglum's sculpted heads of George Washington, Thomas Jefferson, Theodore Roosevelt and Abraham Lincoln (left to right).Show map of South DakotaShow map of the United StatesLocationPennington County, South DakotaNearest cityKeystone, South DakotaCoordinates43°52′44″N 103°27′35�...

 

Andi Abdul Aziz (TNI AL)

Andi Abdul Aziz Kepala Staf Koarmada IIMasa jabatan27 Juni 2022 – 26 Juni 2023PendahuluRachmad JayadiPenggantiIsswarto Informasi pribadiLahir14 Juli 1969 (umur 54)Selayar, Sulawesi SelatanAlma materAkademi Angkatan Laut (1992)Karier militerPihak IndonesiaDinas/cabang TNI Angkatan LautMasa dinas1992—sekarangPangkat Laksamana Muda TNINRP10344/PSatuanKorps PelautSunting kotak info • L • B Laksamana Muda TNI Andi Abdul Aziz, S.H., M.M. (lahir 14 Juli 1969...

Slocomb, Alabama

Slocomb, AlabamaKotaNegara Amerika SerikatNegara bagianlbs Negara bagian AlabamaMontgomery (ibu kota)Topik Sejarah Geografi Orang Pemerintah Gubernur Wakil gubernur Kawasan Metropolitan Tempat wisata Landmark Nasional Bersejarah Wilayah Atlantic Coastal Plain Birmingham District Black Belt Central Alabama Cumberland Plateau Greater Birmingham Gulf Coastal Plain Lower Alabama Mobile Bay North Alabama Northeast Alabama Northwest Alabama Piedmont Ridge and Valley River Region South Ala...

 

John Henniker Heaton

British politician Sir John Henniker Heaton Sir John Henniker Heaton, 1st Baronet, KCMG, CB (18 May 1848 – 8 September 1914) was a United Kingdom Member of Parliament and a postal reformer and journalist in Australia. Early life Heaton was the only son of Lieutenant Colonel John Heaton and his wife, Elizabeth Anne née Henniker, and was born at Rochester, Kent, England. He was educated at Kent House School, Rochester, and King's College London. Australia International Penny Postage....

 

Guadalupe, Antioquia

This article does not cite any sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Guadalupe, Antioquia – news · newspapers · books · scholar · JSTOR (January 2013) (Learn how and when to remove this message) Municipality and town in Antioquia Department, ColombiaGuadalupe, AntioquiaMunicipality and town FlagSealLocation of Guadalupe in the Department of Antio...

Kayne Vincent

New Zealand footballer Kayne Vincent Vincent with Air Force United in 2017Personal informationFull name Kayne Vincent[1]Date of birth (1988-10-29) 29 October 1988 (age 35)[1]Place of birth Auckland, New ZealandHeight 1.84 m (6 ft 0 in)[1]Position(s) ForwardTeam informationCurrent team Western SpringsNumber 9Youth career1998–2001 Three Kings United2001–2002 Metro F.C.2003–2006 Mount WellingtonSenior career*Years Team Apps (Gls)2007 Cerezo Osaka...

 

2017 European Athletics U23 Championships – Men's 110 metres hurdles

2017 European Athletics U23 ChampionshipsTrack events100 mmenwomen200 mmenwomen400 mmenwomen800 mmenwomen1500 mmenwomen5000 mmenwomen10,000 mmenwomen100 m hurdleswomen110 m hurdlesmen400 m hurdlesmenwomen3000 msteeplechasemenwomen4 × 100 m relaymenwomen4 × 400 m relaymenwomenRoad events20 km walkmenwomenField eventsHigh jumpmenwomenPole vaultmenwomenLong jumpmenwomenTriple jumpmenwomenShot putmenwomenDiscus throwmenwomenHammer throwmenwomenJavelin throwmenwomenCombined eventsHeptathlonwome...

 

Air Serbia

Air SerbiaЕр Србија IATA ICAO Kode panggil JU ASL AIR SERBIA Didirikan17 Juni 1927 (sebagai Aeroput)Mulai beroperasi26 Oktober 2013 (sebagai Air Serbia)PenghubungBandara BeogradBandara NišProgram penumpang setiaEtihad GuestAnak perusahaan Air Serbia Ground Services Air Serbia Catering Armada17Tujuan63SloganHave it your wayPerusahaan indukPemerintah Serbia (82%)Kantor pusatBeograd, SerbiaTokoh utamaJiri Marek (CEO)Goran Grozdanić (COO)Situs webairserbia.comAir Serbia (ditulis sebagai...

Atletica leggera ai Giochi della XXXII Olimpiade - Decathlon

Voce principale: Atletica leggera maschile ai Giochi della XXXII Olimpiade.   DecathlonTokyo 2020 Informazioni generaliLuogoStadio nazionale del Giappone Periodo4 e 5 agosto 2021 Partecipanti23 da 15 nazioni Podio Damian Warner  Canada Kévin Mayer  Francia Ashley Moloney  Australia Edizione precedente e successiva Rio de Janeiro 2016 Parigi 2024 Atletica leggera aiGiochi olimpici diTokyo 2020 Corse piane 100 m piani   uomini   donne 200 m piani uomini donne...

 

Medical translation

Part of a series onTranslation Types Legal Literary Bible Quran Kural Linguistic validation Medical Regulatory Technical Interpretation Cultural Word-for-word Sense-for-sense Homophonic Theory Translation studies Skopos theory Translation project Translation criticism Dynamic and formal equivalence Contrastive linguistics Polysystem theory Technologies CAT Machine translation Mobile translation Translation management system Dubbing Subtitling Pre-editing Postediting Multimedia translation Loc...