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 >
