0 Replies Latest reply: Jan 25, 2013 2:51 PM by wthughes_gis RSS

    httpservice google spreadsheet

    wthughes_gis

      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=0AiUGI1feNGPZdGlZdmd3bFY5Y2xyV2RzRy1RMjd6eUE&s ingle=true&gid=0&output=html

       

      ATOM

      https://spreadsheets.google.com/feeds/cells/0AiUGI1feNGPZdGlZdmd3bFY5Y2xyV2RzRy1RMjd6eUE/o d6/public/basic

       

      RSS

      https://spreadsheets.google.com/feeds/cells/0AiUGI1feNGPZdGlZdmd3bFY5Y2xyV2RzRy1RMjd6eUE/o d6/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