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 >> > >
