OK, so in natural language, what you're doing so far is: 1. querying the complete list of the user's spreadsheets 2. picking one of those spreadsheets, and querying its worksheet-feed to list the worksheets in it - this is your WorkSheetsList.xml
Each <entry/> in that worksheet-feed output represents a worksheet. You'll notice the <title/> of each worksheet-entry is the same as what the Google Docs GUI labels each tab in the spreadsheet (eg. 'Calls'). Each worksheet-entry has its own private 'list' feed associated with it, but you don't find the URL for this in a <link/> element - it's in the <content/> element (because ATOM requires such an element, and it's convenient to regard a worksheet's list-feed as the 'content'). You now need to do an additional GET on the list-feed URL (eg. https://spreadsheets.google.com/feeds/list/tTpG7Ocn4nkWN9gfgm-2AOg/oda/private/full). This will give you a <feed/> which contains the #post link you crave in a top-level <link/>, as well as each row in the list given as an <entry/> element. Does that make more sense of it? I think you've been considering as a 'list feed' that which was not a list feed. Hence the confusion. cheers, David. On Mon, Apr 18, 2011 at 11:36 PM, gts <[email protected]> wrote: > Thank you for your reply David! > > > Are you sending the GData-Version: 3.0 header in your requests? > > > 1. In the code I have this line (application for Symbian): > SetHeaderL(hdr, _L8("GData-Version"), _L8("3.0")); > > 2. I am logging headers and data that is sent/received (in HTTP API > callbacks) and I see that header "GData-Version: 3.0" is sent with each > transaction after first one (which is logging in and token request) > > 3. In the response headers I also see "GData-Version: 3.0" > > > Are you sure you're getting the #post link from the *list feed*? It seems > like you're getting it from the *worksheet feed*. > > I am not sure I understand your question. Here are exact steps I am > performing (after authentication): > > 1. Send GET request to " > https://spreadsheets.google.com/feeds/spreadsheets/private/full"; > 2. Parse received response, which is: > > <?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/"C0ECR3czeCt7ImA9WhZQEU4."'><id> > https://spreadsheets.google.com/feeds/spreadsheets/private/full</id><updated>2011-04-18T13:01:06.980Z</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='"BUsPUw5eGit7I > mBr"'><id> > https://spreadsheets.google.com/feeds/spreadsheets/tTpG7Ocn4nkWN9gfgm-2AOg</id><updated>2011-03-23T18:45:25.546Z</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='applica > tion/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> > > 3. Use SpreadsheetKey found in previous response data to construct new URL > "https://spreadsheets.google.com/feeds/worksheets/*<SpreadsheetKey>*/private/full" > and send second GET request > > 4. Parse second response, which is "WorkSheetsList.xml" file attached to > this post: > > > > >
