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
45
votes
4 answers

Getting data from Yahoo Finance

I read about the YQL, but I didn't understand how can I get some simple data (like company ticker, market cap, stock price, etc.), for ALL COMPANIES? And an additional question, how can I get all Yahoo Finance tables and theirs fields that can be…
Ilan
  • 989
  • 2
  • 12
  • 22
19
votes
3 answers

YQL query service replacement now that Yahoo shut it down

So now that Yahoo shut down query.yahooapis.com as the following message indicates, does anyone know of a free replacement? "Important EOL Notice: As of Thursday, Jan. 3, 2019, the YQL service at query.yahooapis.com will be retired. This will…
Purp1eOne
  • 199
  • 1
  • 1
  • 4
18
votes
4 answers

YQL: html table is no longer supported

I use YQL to get some html-pages for reading information out of it. Since today I get the return message "html table is no longer supported. See https://policies.yahoo.com/us/en/yahoo/terms/product-atos/yql/index.htm for YQL Terms of Use" Example in…
hebr3
  • 307
  • 2
  • 6
18
votes
5 answers

Return Yahoo! weather API data in Celsius, using YQL

I'm trying to get Yahoo! weather API with temperatures in Celsius. I've added &u=c in the request, but it's still returning data in Fahrenheit. This is the URL I'm…
Kodr.F
  • 13,932
  • 13
  • 46
  • 91
16
votes
4 answers

Making Yahoo Weather API request with OAuth 1

I ran into a problem with Yahoo Weather API because it wasn't giving me any data. After visiting YDN website I've found out that all requests should be updated to OAuth 1 starting from March 15th (but I got working it just today!). It's also said to…
phbelov
  • 2,329
  • 3
  • 18
  • 15
15
votes
7 answers

Any good Finance API?

Yahoo! Finance feeds are pain in the ass. Google Finance API seems OK but don't know why I can't retrieve stock quotes information for Dow Johnes, NASDAQ, S&P... Works perfect with company quotes like YHOO, MSFT but don't gets full data for stock…
Otar
  • 2,561
  • 1
  • 20
  • 24
15
votes
1 answer

YQL How to use wildcard in XPath

I have a malformed page to scrape, and have had a hard time getting the correct XPath for YQL. I can scrape individual fields that I need using, for example: //*[@id="cell_12345"] But what I really need to do is return all elements who's ID begins…
user191688
  • 2,609
  • 5
  • 26
  • 30
14
votes
3 answers

jQuery Ajax request every 30 seconds

I have this piece of code, but the values may change while someone is on my site. I would need to update the #finance div every 30 seconds or so. Can this be done? $(function() { $.getJSON( …
user141621
12
votes
4 answers

Any .NET examples for Yahoo Query Language (YQL)?

I'd like to make some simple calls to Yahoo Query Language (YQL). Has anyone implemented this in .NET? Here is the query I'd like to make from .NET: select MarketCapitalization from yahoo.finance.quotes where symbol in…
Contango
  • 76,540
  • 58
  • 260
  • 305
12
votes
5 answers

No definition found for Table yahoo.finance.xchange

I have a service which uses a Yahoo! Finance table yahoo.finance.xchange. This morning I noticed it has stopped working because suddenly Yahoo! started to return an error saying: { "error": { "lang": "en-US", "description": "No…
DolceVita
  • 2,090
  • 1
  • 23
  • 35
12
votes
1 answer

Convert string with white space into URL

I'm using ruby and googles reverse geocode yql table to ideally automate some search query I have. The problem I hit is turning the query into a legal url format. The issue is that the encoding I'm using is returning illegal urls. The query I'm…
Steve
  • 21,163
  • 21
  • 69
  • 92
12
votes
2 answers

YQL and javascript (failed)

I found a trickshot // Define variables var query = 'select * from data.html.cssselect where url="http://www.chucknorrisfacts.com/chuck-norris-top-50-facts" and css=".field-content a"'; var yqlAPI = 'http://query.yahooapis.com/v1/public/yql?q=' +…
benoît
  • 1,473
  • 3
  • 13
  • 31
11
votes
3 answers

Is there a way to get YQL to return HTML?

I am trying to use YQL to extract a portion of HTML from a series of web pages. The pages themselves have slightly different structure (so a Yahoo Pipes "Fetch Page" with its "Cut content" feature does not work well) but the fragment I am…
Joe Shaw
  • 22,066
  • 16
  • 70
  • 92
11
votes
3 answers

How to Access Yahoo Finance YQL query with historical data

I'm new to YQL. Perhaps this is very trivial, but I couldn't quite figure this out. I know, for instance, how to query current stock data from Yahoo/YQL using the YQL console: http://developer.yahoo.com/yql/console/ with the query string: select *…
user780069
  • 431
  • 2
  • 5
  • 6
10
votes
1 answer

Querying html using Yahoo YQL

While trying to parse html using Yahoo Query Language and xpath functionality provided by YQL, I ran into problems of not being able to extract “text()” or attribute values. For e.g. perma link select * from html where…
Cherian
  • 19,107
  • 12
  • 55
  • 69
1
2 3
…
54 55