Sign in or Join FriendFeed
FriendFeed is the easiest way to share online. Learn more »
YQL

YQL

Discuss Yahoo! Query Language
Custom RSS/Atom
Mike Chelen
Accessing #NCBI Entrez web services with Yahoo #YQL Open Data Table - Esearch example https://login.yahoo.com/config...
the open data table adapts the query URL parameters and specifies the series of elements to return. source code: http://github.com/mchelen... - Mike Chelen
all three tables are available using a custom environment, for example with esearch: http://bit.ly/27tTVn - Mike Chelen
YQL
Changelog for build 3396 - http://yqlblog.net/blog...
New feature highlights: y.rest and y.query now support timeouts y.rest(..).timeout(30).get() will fail after 30ms y.query(…,30) will fail after 30ms An exception gets thrown if the timeout is hit Open Data Table schema changes url/urls is now optional in the schema Bug fixes, including: @ substitution works for paging parts of the query url based paging works in more cases
Mike Chelen
Mike Chelen
Debugging Open Data Tables and YQL Network Calls - YDN - http://developer.yahoo.com/yql...
"To aid in your debugging efforts, YQL provides the option to have network-level logging. When enabled, all network requests are uncached, so you can iteratively develop Open Data Tables more easily, as well as debug network requests between YQL and the remote service. Network logs display both the request headers and the response content for each network call." - Mike Chelen from Bookmarklet
Mike Chelen
Mike Chelen
Create a YQL open data table for #Datagov data catalog - http://www.data.gov/details/92
yql128.gif
#yql opentables guide: http://developer.yahoo.com/yql... something similar to sunlight lab's open data table for legislators http://github.com/spullar... - Mike Chelen
source is #CSV file so method would be similar to http://www.yqlblog.net/blog... - Mike Chelen
results would allow creation of RSS feed and other metrics, similar to http://sunlightlabs.com/blog... http://data.sunlightlabs.com/data... http://github.com/sunligh... - Mike Chelen
needed because html scraping such as http://sunlightlabs.com/blog... doesn't work any more since the number of records no longer fit on one page - Mike Chelen
the csv is now too large (~1.5mb) for yql to load directly - Mike Chelen
there is a version available on data gov wiki http://data-gov.tw.rpi.edu/wiki... - Mike Chelen
Mike Chelen
Querying html using Yahoo YQL - Stack Overflow - http://stackoverflow.com/questio...
Q: "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." - Mike Chelen from Bookmarklet
A: "YQL requires the xpath expression to evaluate to an itemPath rather than node text. But once you have an itemPath you can project various values from the tree" - Mike Chelen
YQL
Changelog for build 3013 - http://yqlblog.net/blog...
New feature highlights: set verb for configuring static variables yql.storage tables for storing tables, environments and more in YQL itself debug mode for table development (debug=true) multiple environment support Core table changes: update for geo.placemaker table social.connections.updates results are sorted by date similar to social.updates csv table now has a charset key (if the source doesn’t provide one this can be used instead [...]
Mike Chelen
Young Rewired State: Letting young hackers show the government the way (Yahoo! Developer Network Blog) - http://developer.yahoo.net/blog...
Young Rewired State: Letting young hackers show the government the way (Yahoo! Developer Network Blog)
"Last weekend the Young Rewired State event in London, England, a few dozen hackers aged 15-18 years came to Google's office to hack with government data." - Mike Chelen from Bookmarklet
Mike Chelen
Fwd: @spullara are we supposed to modify alltables.env when adding community #yql tables? (via http://friendfeed.com/mikeche...)
Mike Chelen
Mike Chelen
Open Data Tables Reference - YDN - http://developer.yahoo.com/yql...
"The following elements and sub-elements of YQL Open Data Tables are discussed in this reference" - Mike Chelen from Bookmarklet
Mike Chelen
yql's jquery.query-yql at master - GitHub - http://github.com/yql...
"jQuery Plugin: Query YQL simply" - Mike Chelen from Bookmarklet
Mike Chelen
Fork me! YQL Open Tables! (Yahoo! Developer Network Blog) - http://developer.yahoo.net/blog...
Ivan Zuzak
YQL
Changelog for build 2174 - http://yqlblog.net/blog...
New feature highlights: INSERT/UPDATE/DELETE bindings and language features JSONP-X feature (XML string as JSON result if format=xml and JSONP callback is specified) Core table changes: social.updates defaults to sorting updates by date (most recent first) New core tables: social.profile.status social.connections.updates (efficiently gets updates for all connections) flickr.photoset geo.placemaker Open Data Table schema changes new “url” paging model new “insert”,”update” and “delete” bindings new “map” and “value” input key [...]
Mike Chelen
Using YQL With Yahoo Pipes « OUseful.Info, the blog… - http://ouseful.wordpress.com/2009...
Using YQL With Yahoo Pipes « OUseful.Info, the blog…
Show all
"A couple of days ago, @mikechelen asked: “can yql plug in to pipes for improved development, compared with other cloud platforms that accept standard languages?” where YQL is the Yahoo Query Language, a SQL like query language that can run queries on data pulled in from all over the web… There are a couple of ways at least of doing this: a) calling YQL from Yahoo Pipes; b) calling Yahoo Pipes from within a YQL query." - Mike Chelen from Bookmarklet
YQL
Adding value to a data feed using YQL Execute - http://www.yqlblog.net/blog...
I want USGS earthquake data.  More specifically, I’m interested in recent, substantial quakes.  Fortunately, data.gov makes this data easy to find.  After searching through the USGS raw data catalog for the text “earthquake”, I choose the Worldwide M2.5+ Earthquakes, Past 7 Days feed, and pull it into YQL for parsing.  It’s almost perfect, but I [...]
YQL
Getting stock information with YQL and open data tables - http://yqlblog.net/blog...
Getting stock information with YQL and open data tables
One question that the YQL and Pipes teams get asked is “how can I get stock quotes? There isn’t an API for it on developer.yahoo.com”. Interestingly, while there isn’t a more traditional web service API, Yahoo finance does provide a very nice way to get a lot of well structured information on a given company. [...]
YQL
Changelog for build 1678 - http://yqlblog.net/blog...
Bug fixes, including URI Template Handler now supports multiple -neg variables. Escaped values in literals such as ‘\\d’ are now correctly passed to YQL execute as ‘\d’ Fixed uritemplate table example Better integration of Local Search: Added search parameters to local.seach namely listing_id, omit_category, minimum_rating, route and sort Enhancements YQL Execute: y.rest(uri) now parses HTML documents and returns an E4X object [...]
YQL
Do it your way with execute and open data tables - http://www.yqlblog.net/blog...
Today we’ve released a significant new feature for YQL: <execute>. Previously our open data tables enabled any developer to bring the power of YQL and the table model available to new APIs or data sources that we hadn’t covered. Many of these are hosted on github, and you can read (and use) about them on datatables.org. [...]
YQL
Changelog for build 1432 - http://www.yqlblog.net/blog...
Bug fixes, including JSON and JSONP mimetypes now different/fixed. fixed robots.txt evaluation bug “NaN” value sorting bug fixed Open Data Table schema changes private open data table keys don’t have to be “const” and key name (not value) is displayed in “desc” new “https=true” attribute on open data tables new “variable” paramType for open data table [...]
YQL
YQL environment files - http://www.yqlblog.net/blog...
We’ve introduced a new env query parameter to both the YQL console and the web service. The env parameter expects a URL value that points to a plain text file anywhere on the web (including subversion repositories, github etc). The file should contain a list of use statements that specify all the open data tables [...]
YQL
Changelog for build 911 - http://yqlblog.net/blog...
Console and web service now support an “env” query parameter. This is a url that points to an environment/shell file that YQL will load. Currently this enables multiple tables to be used at once. “Use” table no longer requires the “as” clause. When “as” is absent it will default to the final path segment filename minus [...]
YQL
Open data tables added to YQL - http://www.yqlblog.net/blog...
We’re pleased to announce that our last update now enables developers can create, use, and share table definitions over for any public API on the web, in addition to the Yahoo! APIs we support today. For example, one of the requests we had when using our weather table was how to get an ID that would [...]
YQL
Changelog for build 822 - http://yqlblog.net/blog...
NOT LIKE added MATCHES regex matching added New USE verb for open data table importing Support for open data table definitions
YQL
Changelog for 2009.01.12.16:11 - http://yqlblog.net/blog...
New tables upcoming.user microformats flickr.photos.sizes Table updates local.search “location” key is now optional mybloglog user by service fixed typo in mybloglog.members.find “charset” is now an optional key in html table, to enable developers to force a particular charset to be used when parsing the web page Bug fixes, including: more html and xhtml and i18n issues fixed for html table subselect fix for optional keys Other: publiclyCallable [...]
Other ways to read this feed:Feed readerFacebook