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
10
votes
2 answers

Yahoo Weather Query by Latitude and Longitude

I want to fetch some weather data via latitude and longitude using yahoo query. but it seems this query is not available now. the query is below: select * from weather.forecast where woeid in (SELECT woeid FROM geo.placefinder WHERE…
squall leonhart
  • 301
  • 1
  • 5
  • 16
10
votes
3 answers

Yahoo weather API, randomly returns old data?

I started using Yahoo's free weather API to get the weather data I need, but it seems each time I request a city weather data there is a chance that either I get updated data or old data from back to 1 to 8 days. Here is a simple URL which I make my…
Night2
  • 1,168
  • 9
  • 18
10
votes
3 answers

Alternatives to YQL

This is a multi-part question. I just watched a very interesting presentation on YQL by the lead developer (a graduate of my MS program). While it was very compelling, and I am looking forward to trying it out, I am wondering if anyone knows of…
Sam McAfee
  • 10,057
  • 15
  • 60
  • 64
8
votes
2 answers

Error HttpClient cannot be resolved to a type

I am trying to use http request and response method but i am getting error that The import org.apache.commons cannot be resolved i have included httpcore.jar, httpclient.jar, httpmime.jar but yet i am getting error.
Mubashir Ali
  • 559
  • 2
  • 8
  • 23
7
votes
2 answers

How to use API key with Yahoo's YQL?

I'm using this YQL command to access stock quote information in an XML format. The problem is it keeps timing out and rejecting after a bunch of hits. I think I need to plug in my API key so it doesn't think it's bots. I'm using SharePoint to…
zen
  • 1,115
  • 3
  • 28
  • 54
7
votes
0 answers

Is there a replacement for query.yahooapis.com YQL service that was just shut down?

I was unaware that Yahoo was EOL'ing their YQL service and we have an intranet website that depends on it. Does anyone know of a replacement for this functionality, or perhaps a free dot.Net library that can help replicate this functionality? See…
Mushu
  • 99
  • 6
7
votes
2 answers

YQL: select woeid returning null

I use YQL to get weather data for that woeid is needed, but to get woeid when i call following url it return result null https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20geo.places%20where%20text%3D%27delhi%27&format=json Result i…
Ashish
  • 997
  • 6
  • 20
7
votes
1 answer

Get Yahoo weather in celsius via their API

Trying to make a query in YQL console. This one works fine: select * from weather.forecast where woeid=1989965 But I want to get values in metric system (celsius), so I use this query: select * from weather.forecast where woeid=1989965 and…
art.zhitnik
  • 604
  • 5
  • 19
6
votes
0 answers

Screening stocks using Yahoo Finance API (YQL)

i am trying to roll my own stock screener using the Yahoo Finance API. While it is easy to get a heap of data (via XML or JSON) by providing the ticker symbol: SELECT * FROM yahoo.finance.quotes WHERE symbol="RBS.L" (See the results here and click…
ZenGyro
  • 176
  • 1
  • 6
6
votes
2 answers

Get Financial Option Data with YQL

I am using YQL to retrieve Financial Option data. Something like: select * from yahoo.finance.options where symbol="AAPL" and expiration="2011-07" However, the above query returns an optionsChain of data. Is there a way to retrieve just the record…
Johnis Agorgianitis
  • 73
  • 2
  • 6
6
votes
1 answer

How to get more that 10 results for a query using YQL?

I am trying to use YQL in php to get product information from Amazon using the amazon.prodlist table and Amazon Product Advertising API. The query that I used: select * from amazon.prodlist where Title='harry potter' and SearchIndex='Books' and…
Paras Narang
  • 621
  • 1
  • 8
  • 20
6
votes
1 answer

Is it possible to transform HTML into RSS with YQL?

I could do that with Yahoo Pipes, but I don't know if it is possible with YQL.
Jader Dias
  • 88,211
  • 155
  • 421
  • 625
6
votes
4 answers

Is YQL / datatables.org down as of May 17-18, 2017?

During the past 1-2 days, the http query that I used to download historical stock prices from Yahoo Finance has not been working. The link I have been using is the first one below but I have also tried out the other three (since I saw other people…
Candamir
  • 586
  • 9
  • 22
6
votes
2 answers

Are the yahoo.finance related data api's change (YQL Console)?

I am trying to use yql for yahoo financial data. I checked the Show Community Table on the YQL console to see the database under the Yahoo tag. I can see the tables under it but i am not getting results here it is as follows::: select * from…
Devendra Chandode
  • 61
  • 4
6
votes
1 answer

Scrape XML files into RSS feed as input for IFTTT

I've got a set of XML files with article content (title, subtitle, content). I've got a Yahoo Pipe that finds the article XML for a specific date and turns it into an RSS feed. This feed is read by IFTTT to publish the article for today on my…
vicmortelmans
  • 616
  • 6
  • 16
1
2
3
…
54 55