On Wed, Feb 16, 2011 at 1:15 AM, Jason C <[email protected]> wrote:
> I'm just learning the Google Data API. I am working with the Zend PHP > bindings. I was making good progress but I've been stuck on the same > question for about an hour now: > > If I know the *title *of a spreadsheet, and the *name *of a worksheet in > that spreadsheet, how do I get a list feed for the data in that worksheet? > > Using the spreadsheets feed, search for your spreadsheet by title. http://code.google.com/apis/spreadsheets/data/1.0/developers_guide_php.html#listSpreadsheets http://code.google.com/apis/spreadsheets/data/3.0/reference.html#SpreadsheetParameters Then, pull the worksheets on that sheet, again searching by title. http://code.google.com/apis/spreadsheets/data/1.0/developers_guide_php.html#listWorksheets http://code.google.com/apis/spreadsheets/data/3.0/reference.html#WorksheetParameters > I've found solutions involving searching through feeds manually and looking > for relevant names and IDs but I am hoping for something cleaner and with > less requests to Google. The wall I'm running into is > that Zend_Gdata_Spreadsheets_ListQuery lets you set a spreadsheet key and > worksheet ID, but not a spreadsheet title or worksheet name. The reference > docs also don't look like they have a list query URL that takes > titles/names. > > Thanks! > J >
