YUI Library Examples: DataTable Control: JSON Data Over XHR
DataTable Control: JSON Data Over XHR
This example populates a DataTable with data received via XHR from the Yahoo! Local webservice.
Sample Code for this Example
Data:
| 1 | {"ResultSet":{ |
| 2 | "totalResultsAvailable":665, |
| 3 | "totalResultsReturned":10, |
| 4 | "firstResultPosition":1, |
| 5 | "ResultSetMapUrl":"http:\/\/local.yahoo.com\/mapview?stx=pizza&csz=Sunnyvale%2C+CA+94089&city=Sunnyvale&state=CA&radius=15&ed=9brhZa131DwigChqKlCo22kM1H_9WgoouCr87Ao-", |
| 6 | "Result":[{ |
| 7 | "Title":"Pizza Depot", |
| 8 | "Address":"919 E Duane Ave", |
| 9 | "City":"Sunnyvale", |
| 10 | "State":"CA", |
| 11 | "Phone":"(408) 245-7760", |
| 12 | "Latitude":"37.388537", |
| 13 | "Longitude":"-122.003972", |
| 14 | "Rating":{ |
| 15 | "AverageRating":"3.5", |
| 16 | "TotalRatings":"5", |
| 17 | "TotalReviews":"5", |
| 18 | "LastReviewDate":"1161495667"}, |
| 19 | "Distance":"0.93", |
| 20 | "Url":"http:\/\/local.yahoo.com\/details?id=21332021&stx=pizza&csz=Sunnyvale+CA&ed=6tiAL6160Sx1XVIEu1zIWPu6fD8rJDV4.offJLNUTb1Ri2Q.R5oLTYvDCz8YmzivI7Bz0gfrpw--", |
| 21 | "ClickUrl":"http:\/\/local.yahoo.com\/details?id=21332021&stx=pizza&csz=Sunnyvale+CA&ed=6tiAL6160Sx1XVIEu1zIWPu6fD8rJDV4.offJLNUTb1Ri2Q.R5oLTYvDCz8YmzivI7Bz0gfrpw--", |
| 22 | "MapUrl":"http:\/\/maps.yahoo.com\/maps_result?name=Pizza+Depot&desc=4082457760&csz=Sunnyvale+CA&qty=9&cs=9&ed=6tiAL6160Sx1XVIEu1zIWPu6fD8rJDV4.offJLNUTb1Ri2Q.R5oLTYvDCz8YmzivI7Bz0gfrpw--&gid1=21332021", |
| 23 | "BusinessUrl":"http:\/\/pizza-depot.com\/", |
| 24 | "BusinessClickUrl":"http:\/\/pizza-depot.com\/"}, |
| 25 | |
| 26 | ... |
| 27 | ]} |
| 28 | } |
| view plain | print | ? |
CSS:
| 1 | /* No custom CSS. */ |
| view plain | print | ? |
Markup:
| 1 | <div id="json"></div> |
| view plain | print | ? |
JavaScript:
| 1 | YAHOO.util.Event.addListener(window, "load", function() { |
| 2 | YAHOO.example.XHR_JSON = new function() { |
| 3 | this.formatUrl = function(elCell, oRecord, oColumn, sData) { |
| 4 | elCell.innerHTML = "<a href='" + oRecord.getData("ClickUrl") + "' target='_blank'>" + sData + "</a>"; |
| 5 | }; |
| 6 | |
| 7 | var myColumnDefs = [ |
| 8 | {key:"Title", label:"Name", sortable:true, formatter:this.formatUrl}, |
| 9 | {key:"Phone"}, |
| 10 | {key:"City"}, |
| 11 | {key:"Rating.AverageRating", label:"Rating", formatter:YAHOO.widget.DataTable.formatNumber, sortable:true} |
| 12 | ]; |
| 13 | |
| 14 | this.myDataSource = new YAHOO.util.DataSource("assets/php/ylocal_proxy.php?"); |
| 15 | this.myDataSource.responseType = YAHOO.util.DataSource.TYPE_JSON; |
| 16 | this.myDataSource.connXhrMode = "queueRequests"; |
| 17 | this.myDataSource.responseSchema = { |
| 18 | resultsList: "ResultSet.Result", |
| 19 | fields: ["Title","Phone","City",{key:"Rating.AverageRating",parser:"number"},"ClickUrl"] |
| 20 | }; |
| 21 | |
| 22 | this.myDataTable = new YAHOO.widget.DataTable("json", myColumnDefs, |
| 23 | this.myDataSource, {initialRequest:"query=pizza&zip=94089&results=10&output=json"}); |
| 24 | |
| 25 | var myCallback = function() { |
| 26 | this.set("sortedBy", null); |
| 27 | this.onDataReturnAppendRows.apply(this,arguments); |
| 28 | }; |
| 29 | var callback1 = { |
| 30 | success : myCallback, |
| 31 | failure : myCallback, |
| 32 | scope : this.myDataTable |
| 33 | }; |
| 34 | this.myDataSource.sendRequest("query=mexican&zip=94089&results=10&output=json", |
| 35 | callback1); |
| 36 | |
| 37 | var callback2 = { |
| 38 | success : myCallback, |
| 39 | failure : myCallback, |
| 40 | scope : this.myDataTable |
| 41 | }; |
| 42 | this.myDataSource.sendRequest("query=chinese&zip=94089&results=10&output=json", |
| 43 | callback2); |
| 44 | }; |
| 45 | }); |
| view plain | print | ? |
Configuration for This Example
You can load the necessary JavaScript and CSS for this example from Yahoo's servers. Click here to load the YUI Dependency Configurator with all of this example's dependencies preconfigured.
YUI Logger Output:
Logger Console
INFO 2032ms (+0) 7:35:53 PM:
DataSource instance0
Making connection to live data for "query=chinese&zip=94089&results=10&output=json"
INFO 2032ms (+2) 7:35:53 PM:
DataSource instance0
Making connection to live data for "query=mexican&zip=94089&results=10&output=json"
INFO 2030ms (+1) 7:35:53 PM:
DataSource instance0
Making connection to live data for "query=pizza&zip=94089&results=10&output=json"
INFO 2029ms (+0) 7:35:53 PM:
DataTable instance yui-dt0
DataTable showing message: Loading...
WARN 2029ms (+0) 7:35:53 PM:
DataTable instance yui-dt0
Could not find DragDrop for resizeable Columns
INFO 2029ms (+2) 7:35:53 PM:
DataTable instance yui-dt0
TH cells for 4 keys created
INFO 2027ms (+0) 7:35:53 PM:
RecordSet instance yui-rs0
RecordSet initialized
INFO 2027ms (+1) 7:35:53 PM:
ColumnSet instance yui-cs0
ColumnSet initialized
INFO 2026ms (+174) 7:35:53 PM:
DataSource instance0
DataSource initialized
INFO 1852ms (+1852) 7:35:53 PM:
LogReader instance0
LogReader initialized
INFO 0ms (+0) 7:35:51 PM:
global
Logger initialized
Note: You are viewing this example in debug mode with logging enabled. This can significantly slow performance.
DataTable Control Examples:
- Basic Example
- Progressive Enhancement
- Custom Cell Formatting
- Conditional row coloring
- Nested Headers
- JSON Data Over XHR
- XML Data Over XHR With POST
- Textual Data Over XHR
- Local XML Data
- Polling the DataSource
- Adding, Updating, and Deleting Rows
- Client-side Pagination
- Client-side Sorting
- Server-side Pagination and Sorting for Dynamic Data
- Integrating Browser History Manager with Server-side Pagination and Sorting
- XY-scrolling, Y-scrolling, and X-scrolling
- Row Selection
- Cell Selection
- Inline Cell Editing
- Showing, Hiding, and Reordering Columns.
- Highlighting Cells, Rows, or Columns
- Context Menu Integration
- TabView Integration
- Complex Example of Multiple Features
- Datatable with Autocomplete
- Configuring the Paginator (included with examples for Paginator)
- Skinning Model
- Complex Application (included with examples for Layout Manager)
More DataTable Control Resources:
- User's Guide (external)
- API Documentation
- Cheat Sheet PDF (external)
- Yahoo! UI Library
- Home (external)
- YUIBlog (external)
- YUI Discussion Forum (external)
- YUI on GitHub
- API Documentation
- Functional Examples
- YUI Theater (external)
- YUI License (external)
- YUI Functional Examples
- Animation
- AutoComplete
- Browser History Manager
- Button
- Calendar
- Carousel
- Charts (experimental)
- Color Picker
- Cookie
- Connection Manager
- Container
- DataTable
- Dom
- Drag & Drop
- Event
- Get
- ImageCropper
- ImageLoader
- JSON
- Layout Manager
- Logger
- Menu
- Paginator
- Profiler
- ProfilerViewer
- Resize
- Rich Text Editor
- Selector
- Slider
- Stylesheet
- TabView
- TreeView
- Uploader (experimental)
- YAHOO Global Object
- YUI Loader
- YUI Test
- Reset CSS
- Base CSS
- Fonts CSS
- Grids CSS
- YUI Articles on the YUI Website
- YUI FAQ (external)
- Graded Browser Support (external)
- Bug Reports/Feature Requests (external)
- Serving YUI Files from Yahoo! (external)
- Security Best Practices (external)
Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Copyright Policy - Job Openings