Thanks, most appreciated. -Vic
On Fri, Dec 17, 2010 at 1:04 AM, Sean Horgan <[email protected]> wrote: > Sure, I'll create the bug in the morning. For now I'm just going to work > around it. > > Thanks. > > Sean > > > On Thu, Dec 16, 2010 at 21:50, Vic Fryzel <[email protected]> wrote: > >> Hey Sean, >> >> You're right. Let's start with the content link not showing up in your >> feed result. >> >> I just ran a GET against this URL using GData-Version 3.0: >> https://spreadsheets.google.com/feeds/spreadsheets/private/full/ >> >> And got this back: >> >> <entry gd:etag=""AVZVGAlQTyt7ImBr""> >> >> <id>https://spreadsheets.google.com/feeds/spreadsheets/t2234aDDgNu0-SeGGhWFavHDwW_4-Q</id> >> >> >> <updated>2010-12-14T19:14:28.868Z</updated> >> <category scheme="http://schemas.google.com/spreadsheets/2006"; >> term="http://schemas.google.com/spreadsheets/2006#spreadsheet"/> >> <title>Printer Supplies</title> >> <content type="application/atom+xml;type=feed" >> src="https://spreadsheets.google.com/feeds/worksheets/t2234aDDgNu0-SeGGhWFavHDwW_4-Q/private/full"/> >> >> >> >> <link rel="http://schemas.google.com/spreadsheets/2006#tablesfeed"; >> type="application/atom+xml" >> href="https://spreadsheets.google.com/feeds/t2234aDDgNu0-SeGGhWFavHDwW_4-Q/tables"/> >> >> >> >> <link rel="alternate" type="text/html" >> href="https://spreadsheets.google.com/ccc?key=0Anv123GGF1cNcx6HE-dDROdTAtU2VHR2hXRmF2SER3V180LVE"/> >> <link rel="self" type="application/atom+xml" >> href="https://spreadsheets.google.com/feeds/spreadsheets/private/full/t2234aDDgNu0-SeGGhWFavHDwW_4-Q"/> >> <author> >> <name>...</name> >> <email>...</email> >> </author> >> </entry> >> >> >> If you somehow are setting GData-Version to 1.0, this will cause you to >> get a different output which has a content link that is not very useful in >> this case. >> >> Then, using I pulled the worksheet using the URL mentioned above. >> >> <entry gd:etag=""YDwreyI.""> >> >> ... >> <content type="application/atom+xml;type=feed" >> src="https://spreadsheets.google.com/feeds/list/t2234aDDgNu0-SeGGhWFavHDwW_4-Q/od7/private/full"/> >> >> ... >> </entry> >> >> >> And I confirm what you're seeing. I'll make a change to expose the link >> in the documented place. >> >> Would you mind opening a bug in the issue tracker? >> >> -Vic >> >> >> >> On Wed, Dec 15, 2010 at 8:55 PM, Sean <[email protected]> wrote: >> >>> I'm trying to access a worksheet's list feed using the Google API Java >>> client (v1.2.1-alpha). I'm successfully authenticated to a google apps >>> account via OAuth from a google app engine application. >>> >>> I'm currently unable to retrieve a link to the listfeed from the >>> worksheet feed, but only when I do so via my app engine dev environment. I >>> am able to see (what I believe) is the listfeed link when I use curl from >>> the command line. The doc doesn't clearly state how to determine the list >>> feed, but from: >>> https://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#ListFeeds, >>> it says the following: >>> >>> To determine the URL of a list-based feed for a given worksheet, get the >>> worksheets metafeed and examine the <content> element in which src is >>> the list feed's URI. >>> >>> >>> I do not see a "src" in the content element but from the worksheet >>> metafeed I see the following link rel: * >>> http://schemas.google.com/spreadsheets/2006#listfeed* with this href: * >>> https://spreadsheets.google.com/feeds/list/0ApGqokQEAmMddHR6S1pyUV85dXRvWkFVdGRVT2c4TVE/od7/private/full >>> *. * *This matches the next line in the doc that states that the >>> listfeed URI: >>> >>> GET https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full >>> >>> >>> I've attached the output of a command curl HTTP GET for the worksheet >>> feed URL (worksheetListFeed.txt). In there you can see the simple >>> spreadsheet with 2 worksheets (Sheet1, Sheet2) and the #listfeed link rels. >>> >>> >>> The problem I'm seeing is that when I try to access the exact same >>> feeds/entries via the Java API, it doesn't find the #listfeed. Following >>> some of the samples, I have a method that simply searches the link elements >>> of an entry: >>> >>> public String getListFeedLink() { >>> return Link.find(links, " >>> http://schemas.google.com/spreadsheets/2006#listfeed";); >>> } >>> >>> I am able to get other links from the sheet: >>> >>> Link rel: [http://schemas.google.com/spreadsheets/2006#cellsfeed] >>> Link rel: [http://schemas.google.com/visualization/2008#visualizationApi >>> ] >>> Link rel: [self] >>> Link rel: [edit] >>> >>> but for some reason, not the one I want: #listfeed. >>> >>> If I manually construct the list feed URL in the Java API using the >>> #listfeed href from the command line, I can make subsequent requests to view >>> row data in each sheet. >>> >>> Is there anything that would prevent access to it from the Java API? It >>> looks like there are some visibility constraints for the Table Feed but I >>> don't remember reading anything about the List Feed. >>> >>> Thanks. >>> >>> Sean >>> >> >> >
