Skip navigation
wthughes_gis
Currently Being Moderated

httpservice google spreadsheet

Jan 25, 2013 2:51 PM

Tags: #flex #xml #rss #httpservice #google_spreadsheet #array_collection

Anyone know how to setup an httpservice to parse a google (drive) spreadsheet?

 

In Google Drive there are options to publish a spreadheet to RSS and ATOM but I am having a hard time parsing either of those formats.

 

HTML

https://docs.google.com/spreadsheet/pub?key=0AiUGI1feNGPZdGlZdmd3bFY5Y 2xyV2RzRy1RMjd6eUE&single=true&gid=0&output=html

 

ATOM

https://spreadsheets.google.com/feeds/cells/0AiUGI1feNGPZdGlZdmd3bFY5Y 2xyV2RzRy1RMjd6eUE/od6/public/basic

 

RSS

https://spreadsheets.google.com/feeds/cells/0AiUGI1feNGPZdGlZdmd3bFY5Y 2xyV2RzRy1RMjd6eUE/od6/public/basic?alt=rss

 

Thanks.

 

ex. I know that typical RSS structure looks like this: rss.channel.item.  Ultimately I want to parse the data into and Array Collection and then display results in a Datagrid.

 

Will

 

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points