Stack Overflow
Stack Overflow

Questions tagged [yql]

The Yahoo! Query Language was an expressive SQL-like language that lets you query, filter, and join data across Web services.

As of Thursday, January 3, 2019, the YQL service is retired.

Historical information.

Yahoo! and other websites across the Internet made much of their structured data available to developers, primarily through Web services. To access and query these services, developers traditionally endured the pain of locating the right URLs and documentation to access and query each Web service.

With YQL, developers could access and shape data across the Internet through one simple language, eliminating the need to learn how to call different APIs.

815 questions
5
votes
3 answers

jQuery dollar sign is undefined

In my quest to get historical information, i tried using the below code. Chrome debugger says that Uncaught ReferenceError: $ is not defined. Can you suggest a fix, i'm really stuck. I just need this to work on Chrome, and I am tapping into YQL and…
bouncingHippo
  • 5,940
  • 21
  • 67
  • 107
5
votes
4 answers

How can I get stock option chains using YQL?

I am trying to get stock option chains from Yahoo using YQL. I have tried this command in the YQL console: select * from yahoo.finance.options However, I get this error XML:
Programmer_D
  • 601
  • 2
  • 15
  • 27
5
votes
5 answers

Yahoo YQL: find city WOEID by coordinates

How to get city's WOEID if I know latitude and longitude of city using YQL?
Ivan Bajalovic
  • 780
  • 1
  • 9
  • 20
4
votes
3 answers

YQL Problem - "The current table has been blocked"

I'm new to YQL and am having some problems retrieving data. The query I'm trying to execute is: select * from yahoo.finance.historicaldata where symbol = "TW.L" and startDate = "01/01/2011" and endDate = "22/01/2011" I did manage to retrieve some…
Chris Roberts
  • 18,622
  • 12
  • 60
  • 67
4
votes
2 answers

How to set up development environment for yql and open table development? How to test it locally? (best practice)

I develop -- from time to time -- yahoo open tables to access different resources on the web. Currently I am using a JavaScript editor and -- when I want to test if my open table works -- I upload the xml table description to a server to test it…
Skarab
  • 6,981
  • 13
  • 48
  • 86
4
votes
0 answers

YQL weather result is null in half the time

Yahoo data sometimes fails to get data, "query.results is null or not an object" . This is happening to me to on Chrome 55.0.2883.87 and fierfox 50.1.0. This is the YQL i'm Using: http://query.yahooapis.com/v1/public/yql?q=select *…
Me hdi
  • 1,832
  • 6
  • 24
  • 35
4
votes
1 answer

Yahoo Weather API Key Usage?

I am planning to develop an iOS weather application that is non-commercial which retrieves JSON feed from Yahoo's Weather API. Documentation: https://developer.yahoo.com/weather/ However, I don't understand the purpose of needing an API-Key? I am…
Miket25
  • 1,895
  • 3
  • 15
  • 29
4
votes
0 answers

How to get list stock from Yahoo finance

I wanna to get list stock (symbols) from Yahoo finances as Json file based on site http://finance.yahoo.com/stock-center/ . Please look at "market mover", I wanna to get all data. I have searched and trying to download some file but I have not find…
thanhoangxuannghiep
  • 67
  • 6
4
votes
1 answer

Combining two queries in Yahoo YQL

I want to get the weather information for a specific location. Right now, I need to calls to get them: The first one translated my current position (lat/lon) to a WOEID, the second call retrieves the Weather information by using that WOEID. Can I…
dmnkhhn
  • 1,013
  • 1
  • 10
  • 18
4
votes
1 answer

YQL yahoo.finance.xchange returns Column Mismatch when run via Rest Query, works from console

The following query works from console: env 'store://datatables.org/alltableswithkeys'; select * from yahoo.finance.xchange where pair in ("USDSGD") However, the rest…
wizgot
  • 338
  • 3
  • 11
4
votes
2 answers

Using YQL multi-query & XPath to parse HTML, how to escape nested quotes?

The title is more complicated than it has to be, here's the problem query. SELECT * FROM query.multi WHERE queries=" SELECT * FROM html WHERE url='http://www.stumbleupon.com/url/http://www.guildwars2.com' AND…
Tivac
  • 2,553
  • 18
  • 21
4
votes
3 answers

How to use YQL to merge 2 RSS feeds sorted by pubDate?

Seeing that YQL is being promoted as a good way to do things, I was curious as to how to use YQL to fetch and merge 2 different feeds into one (sorted by pubDate). It's pretty trivial to fetch 2 feeds but it turns out that the feeds are just…
jnman
  • 203
  • 3
  • 9
4
votes
1 answer

Get stock quotes as JSON from Yahoo Finance with Start and End dates

I have been attempting to get a stock quote history from a specific symbol (BHP.AX) with a specific start and end date. Here is my attempted query: select * from yahoo.finance.quotes where symbol in ("BHP.AX") and startDate = "2014-01-01" and…
Fizzix
  • 23,679
  • 38
  • 110
  • 176
4
votes
1 answer

Can YQL parse web sites requiring cookie-based authentication?

First, my use case: I'm trying to use YQL's built in XPATH capabilities to scrape content from Yahoo! Fantasy Sports. It uses some sort of cookie-based authentication scheme. Basically, the sequence is: 1) Do an HTTP GET on the Yahoo! Login page 2)…
Jerry SHen
  • 398
  • 3
  • 15
4
votes
1 answer

YQL Console working inconsistently

I'm trying to make a finance app that, for now, pulls stock quotes. My problem is detailed below: On the developer's console (http://developer.yahoo.com/yql/console/), I will click "show community tables" on the right under "Data Tables" I type in…
user1872121
  • 41
  • 1
1 2 3
…
54 55