That's right. *1*. querying the complete list of the user's spreadsheets
And here is first difference between documentation and actual response that I am getting. Documentation (here: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#ListingSpreadsheets) says that each <entry> will contain 3 <link> elements: 1.1 one with rel="http://schemas.google.com/spreadsheets/2006#* worksheetsfeed*" 1.2 one with rel="alternate" 1.3. one with rel="self" instead of first one I am getting <link> with rel="http://schemas.google.com/spreadsheets/2006#*tablesfeed*"; (see "SpreadsheetsList.xml" attached) But this doesn't bother me much (except that I see it as first sign that something is going wrong here). I am looking for <entry> with a certain <title> that you mentioned in your post (namely, "GreenExpenses" - hardcoded name of worksheet that I need). Then I am using third <link> within that <entry> (one with rel="self") to determine spreadsheet ID *2*. querying its worksheet-feed to list the worksheets in it - WorkSheetsList.xml Now, according to documentation (here:http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#RetrievingWorksheetFeeds) I expect to see <entry> for each Worksheet and each such entry should contain 4 <link> elements: 2.1 one with rel="http://schemas.google.com/spreadsheets/2006#listfeed"; 2.2 one with rel="http://schemas.google.com/spreadsheets/2006#cellsfeed"; 2.3 one with rel="self" 2.4 one with rel="edit" Here is another difference: *I am not getting <link> *with rel="http://schemas.google.com/spreadsheets/2006#*listfeed"* (see "WorkSheetsList.xml" attached again). "cellsfeed" comes first, then there is <link> with rel="http://schemas.google.com/visualization/2008#visualizationApi";, and then last two, "self" and "edit". Yes, there is <content> element with URL that I could use to get a feed with list of rows in <entry> elements. But do I really have to use this URL if I don't need list of rows? I don't care what rows alredy exist in the worksheet. My goal is just to add new rows to the end of worksheet with title "Log" (yes, again hard-coded). To do this, can't I look up an <entry> in WorkSheetsList.xml with <title> "Log" and use some of other elements within the same <entry> to determine worksheet id? I am reading this section of documentation: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#CreatingListRows First it says what you David say: You can find the POST URL in the *list feed's* <link> element that has rel="http://schemas.google.com/g/2005#post";. Ok, I understand that to use this method I need to get list feed. But few lines later documentation says: Now send the request to the POST URL: POST https://spreadsheets.google.com/feeds/list/*key/worksheetId* /private/full To construct this URL do I need list feed if I already have both Spreadsheet key and Worksheet ID? Also, as I wrote in first post, those differences in documentation and actual results I am getting make me worried a bit. If I will write code expecting certain elements and attributes in response, will it always work? What elements and attributes are guaranteed (at least within given API version)? Thank you David for responses and also thank you for giving me natural English language lessons, I will try to absorb them )))
<?xml version='1.0' encoding='UTF-8'?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearch/1.1/' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='W/"DE8DRnc6eyt7ImA9WhZRF0w."'><id>https://spreadsheets.google.com/feeds/spreadsheets/private/full</id><updated>2011-04-13T17:47:57.913Z</updated><category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#spreadsheet'/><title>Available Spreadsheets - greenexpe [email protected]</title><link rel='alternate' type='text/html' href='http://docs.google.com'/><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/spreadsheets/private/full'/><link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/spreadsheets/private/full'/><openSearch:totalResults>1</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><entry gd:etag='"BVZVFwhJRit7I mBr"'><id>https://spreadsheets.google.com/feeds/spreadsheets/tTpG7Ocn4nkWN9gfgm-2AOg</id><updated>2011-03-25T13:52:33.169Z</updated><category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#spreadsheet'/><title>GreenExpenses</title><content type='application/atom+xml;type=feed' src='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full'/><link rel='http://schemas.google.com/spreadsheets/2006#tablesfeed' type='application/ atom+xml' href='https://spreadsheets.google.com/feeds/tTpG7Ocn4nkWN9gfgm-2AOg/tables'/><link rel='alternate' type='text/html' href='https://spreadsheets.google.com/ccc?key=0Ah2BmtOm32iTdFRwRzdPY240bmtXTjlnZmdtLTJBT2c'/><link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/spreadsheets/private/full/tTpG7Ocn4nkWN9gfgm-2AOg'/><author><name>greenexpense</name><email>[email protected]</email></author></entry></feed>
<?xml version='1.0' encoding='UTF-8'?> <feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearch/1.1/' xmlns:gs='http://schemas.google.com/spreadsheets/2006' xmlns:gd='http://schemas.google.com/g/2005' gd:etag='W/"D04GRHs_fit7ImA9WhZTGU0."'> <id>https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full</id> <updated>2011-03-23T18:45:25.546Z</updated> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#worksheet'/> <title>GreenExpenses</title> <link rel='alternate' type='text/html' href='https://spreadsheets.google.com/ccc?key=tTpG7Ocn4nkWN9gfgm-2AOg'/> <link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full'/> <link rel='http://schemas.google.com/g/2005#post' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full'/> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full'/> <author> <name>greenexpense</name> <email>[email protected]</email> </author> <openSearch:totalResults>6</openSearch:totalResults> <openSearch:startIndex>1</openSearch:startIndex> <entry gd:etag='"EVgXVRYHRSt7ImBvHRI."'> <id>https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/od6</id> <updated>2011-03-23T18:45:25.546Z</updated> <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-03-23T18:42:35.226Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#worksheet'/> <title>Log</title> <content type='application/atom+xml;type=feed' src='https://spreadsheets.google.com/feeds/list/tTpG7Ocn4nkWN9gfgm-2AOg/od6/private/full'/> <link rel='http://schemas.google.com/spreadsheets/2006#cellsfeed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/cells/tTpG7Ocn4nkWN9gfgm-2AOg/od6/private/full'/> <link rel='http://schemas.google.com/visualization/2008#visualizationApi' type='application/atom+xml' href='https://spreadsheets.google.com/tq?key=tTpG7Ocn4nkWN9gfgm-2AOg&sheet=od6'/> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/od6'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/od6'/> <gs:rowCount>100</gs:rowCount> <gs:colCount>20</gs:colCount> </entry> <entry gd:etag='"EVUMAwZXQSt7ImBvHRI."'> <id>https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/od7</id> <updated>2011-03-23T18:42:35.226Z</updated> <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-03-23T18:42:35.226Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#worksheet'/> <title>Methods</title> <content type='application/atom+xml;type=feed' src='https://spreadsheets.google.com/feeds/list/tTpG7Ocn4nkWN9gfgm-2AOg/od7/private/full'/> <link rel='http://schemas.google.com/spreadsheets/2006#cellsfeed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/cells/tTpG7Ocn4nkWN9gfgm-2AOg/od7/private/full'/> <link rel='http://schemas.google.com/visualization/2008#visualizationApi' type='application/atom+xml' href='https://spreadsheets.google.com/tq?key=tTpG7Ocn4nkWN9gfgm-2AOg&sheet=od7'/> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/od7'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/od7'/> <gs:rowCount>100</gs:rowCount> <gs:colCount>20</gs:colCount> </entry> <entry gd:etag='"EVZPVUFCRSt7ImBvHRI."'> <id>https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/od4</id> <updated>2011-03-23T18:42:56.056Z</updated> <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-03-23T18:42:56.056Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#worksheet'/> <title>Categories</title> <content type='application/atom+xml;type=feed' src='https://spreadsheets.google.com/feeds/list/tTpG7Ocn4nkWN9gfgm-2AOg/od4/private/full'/> <link rel='http://schemas.google.com/spreadsheets/2006#cellsfeed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/cells/tTpG7Ocn4nkWN9gfgm-2AOg/od4/private/full'/> <link rel='http://schemas.google.com/visualization/2008#visualizationApi' type='application/atom+xml' href='https://spreadsheets.google.com/tq?key=tTpG7Ocn4nkWN9gfgm-2AOg&sheet=od4'/> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/od4'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/od4'/> <gs:rowCount>100</gs:rowCount> <gs:colCount>20</gs:colCount> </entry> <entry gd:etag='"EVYFDRwEBit7ImBvHRI."'> <id>https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/od5</id> <updated>2011-03-23T18:43:47.348Z</updated> <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-03-23T18:43:47.348Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#worksheet'/> <title>Shops</title><content type='application/atom+xml;type=feed' src='https://spreadsheets.google.com/feeds/list/tTpG7Ocn4nkWN9gfgm-2AOg/od5/private/full'/> <link rel='http://schemas.google.com/spreadsheets/2006#cellsfeed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/cells/tTpG7Ocn4nkWN9gfgm-2AOg/od5/private/full'/> <link rel='http://schemas.google.com/visualization/2008#visualizationApi' type='application/atom+xml' href='https://spreadsheets.google.com/tq?key=tTpG7Ocn4nkWN9gfgm-2AOg&sheet=od5'/> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/od5'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/od5'/> <gs:rowCount>100</gs:rowCount> <gs:colCount>20</gs:colCount> </entry> <entry gd:etag='"EVcZDRpTSSt7ImBvHRI."'> <id>https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/oda</id> <updated>2011-03-23T18:44:14.225Z</updated><app:edited xmlns:app='http://www.w3.org/2007/app'>2011-03-23T18:44:14.225Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#worksheet'/> <title>Calls</title> <content type='application/atom+xml;type=feed' src='https://spreadsheets.google.com/feeds/list/tTpG7Ocn4nkWN9gfgm-2AOg/oda/private/full'/> <link rel='http://schemas.google.com/spreadsheets/2006#cellsfeed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/cells/tTpG7Ocn4nkWN9gfgm-2AOg/oda/private/full'/> <link rel='http://schemas.google.com/visualization/2008#visualizationApi' type='application/atom+xml' href='https://spreadsheets.google.com/tq?key=tTpG7Ocn4nkWN9gfgm-2AOg&sheet=oda'/> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/oda'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/oda'/> <gs:rowCount>100</gs:rowCount><gs:colCount>20</gs:colCount> </entry> <entry gd:etag='"EVcNDkBTHit7ImBvHRI."'> <id>https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/odb</id> <updated>2011-03-23T18:44:34.221Z</updated> <app:edited xmlns:app='http://www.w3.org/2007/app'>2011-03-23T18:44:34.221Z</app:edited> <category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#worksheet'/> <title>SMSes</title> <content type='application/atom+xml;type=feed' src='https://spreadsheets.google.com/feeds/list/tTpG7Ocn4nkWN9gfgm-2AOg/odb/private/full'/> <link rel='http://schemas.google.com/spreadsheets/2006#cellsfeed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/cells/tTpG7Ocn4nkWN9gfgm-2AOg/odb/private/full'/> <link rel='http://schemas.google.com/visualization/2008#visualizationApi' type='application/atom+xml' href='https://spreadsheets.google.com/tq?key=tTpG7Ocn4nkWN9gfgm-2AOg&sheet=odb'/> <link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/odb'/> <link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/worksheets/tTpG7Ocn4nkWN9gfgm-2AOg/private/full/odb'/> <gs:rowCount>100</gs:rowCount> <gs:colCount>20</gs:colCount> </entry> </feed>
