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

Check if YQL limits have been reached?

Is there any way (other than having to add custom code) to check if my application has exceeded the YQL limits that are allowed? (Not sure if per application limit or the per IP limit applies in my case) I assume that all queries would fail after…
Nick
  • 7,475
  • 18
  • 77
  • 128
6
votes
2 answers

Getting back urls while loading multiple urls with YQL

I'm using YQL to fetch a bunch of pages, some of which could be offline (obviously I don't know which ones). I'm using this query: SELECT * FROM html WHERE url IN ("http://www.whooma.net", "http://www.dfdsfsdgsfagdffgd.com",…
Matteo Monti
  • 8,362
  • 19
  • 68
  • 114
5
votes
1 answer

YQL for twitter follower's tweets

How can I get a list of the tweets of a particular twitter account's followers? I can get a list of the follower's ids with this: select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml' my assumption was that to retrieve…
thatismatt
  • 9,832
  • 10
  • 42
  • 54
5
votes
1 answer

YQL "Redirected to a robots.txt restricted URL" Error for Google Domain

I am using YQL Console and I want to return results from this link in Google Shopping Using the following in YQL: select content from html where…
ToddN
  • 2,901
  • 14
  • 56
  • 96
5
votes
1 answer

How to fetch private data with YQL on Yahoo PHP5 Sdk yos-social-php5

I am using Yahoo PHP5 SDK and use it to fetch user contacts from table social.contacts which is a private data. On the example, from Delicious, it only shown fetching public data from YQL. May I know what parameter should I use to fetch private data…
davidlee
  • 5,611
  • 17
  • 56
  • 82
5
votes
3 answers

Include additonal field in select query

I'm using YQL to get a list of feeds, like this: SELECT title, link, pubDate FROM rss WHERE url IN ('.implode("','", array_values($urls)).') $urls contains the feed urls: $urls = array( 'delicious' => 'http://feeds.delicious.com/v2/rss/foo', …
Alex
  • 66,732
  • 177
  • 439
  • 641
5
votes
1 answer

YQL Losing HTML Element Attributes?

YQL Console Link Query: select * from html where url='http://www.cbs.com/shows/big_brother/video/' and xpath='//div[@id="cbs-video-metadata-wrapper"]/div[@class="cbs-video-share"]/a' Returns:
Nuri Hodges
  • 868
  • 6
  • 13
5
votes
2 answers

Get an RSS feed's title using YQL

I'm using YQL to retrieve an RSS feed using javascript (as json), for example i use the following query: select * from rss where url = "http://feeds2.feedburner.com/ajaxian" The response contains the feed items, already parsed as json and…
Bagelzone Ha'bonè
  • 1,192
  • 1
  • 14
  • 29
5
votes
3 answers

Trouble using Xpath "starts with" to parse xhtml

I'm trying to parse a webpage to get posts from a forum. The start of each message starts with the following format
and I only want to get the first one I tried xpath='//div[starts-with(@id, '"post_message_')]'…
bigbucky
  • 61
  • 1
  • 1
  • 2
5
votes
2 answers

YQL returning null results from one client, populated results from another

I have an application using a YQL query to convert results to jsonp format. It has been working for several days, but suddenly started returning null…
Chris Smith
  • 103
  • 1
  • 4
5
votes
3 answers

How to use multiple xpath selectors in a YQL query

Hey, I'd like to scrape some data from my blog using YQL: SELECT * FROM html WHERE url="http://site.com/blog" AND xpath="//div[@class='post']" How can I use different bits of xpath in my query? E.g. can I do something like: SELECT * FROM html WHERE…
Umar Hansa
  • 99
  • 2
  • 7
5
votes
0 answers

Yahoo Finance API returns yesterday's data until after market closes

I've been using Yahoo Finance queries for a few years now, and over the past weeks (or few months) I noticed that each query I try no longer returns 15-minute delayed data. Instead, while the market is open, it returns the prior market day's data…
Drac
  • 51
  • 4
5
votes
2 answers

Is it possible to alias or rename fields in YQL?

I'm making a bunch of YQL queries at once & have a standard way of accessing the fields on the server. Unfortunately one of the feeds uses a different name than the rest for a field so I was assuming I could alias it within YQL. Something…
Tivac
  • 2,553
  • 18
  • 21
5
votes
0 answers

How to use yahoo api key with yql rest query

I am attempting to get stock data from the yahoo finance tables using this url: Get Yahoo Stocks I would like to include my api key to this url to raise my access limits. I have a consumer key and consumer secret from a registered yahoo application.…
Optimus
  • 1,354
  • 1
  • 21
  • 40
5
votes
1 answer

YQL query to retrieve all listed companies symbols in a given stock exchange

I need a YQL (Yahoo Query Language) query. The quesry should give me all the companies symbols listed in a given stock exchange. Here is a psudocode for what I am looking for: select * from yahoo.finance.??? where exchange(??) in…
rudeboy
  • 71
  • 5
1 2
3
…
54 55