https://spreadsheets.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full
I get: <?xml version='1.0' encoding='UTF-8'?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gsx='http://schemas.google.com/spreadsheets/2006/extended'><id>https://spreadsheets.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full</id><upd ated>2011-02-10T18:42:43.236Z</updated><category scheme='http://schemas.google.com/spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/><title type='text'>Sheet1</title><link rel='alternate' type='text/html' href='https://spreadsheets.google.com/ccc?key=tjrHQVklaeCW91Wrb JWcrlQ'/><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full'/><link rel='http://schemas.google.com/g/2005#post' type='application/atom+xml' href='https://spreadsheets.google.com /feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full'/><link rel='self' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full'/><author><name>BocaGrandeDuplicateBC</name><email>[email protected]</email></author><open Search:totalResults>78</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><entry><id>https://spreadsheets.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full/72asr</id><updated>2011-02-10T18:42:43.236Z</updated><category scheme='http://schemas.google.com/spread sheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/><title type='text'>6/19/2010 12:14:57</title><content type='text'>yourname: Elizabeth Wood, youre-mailcontactinformation: [email protected], yourpartnersname: Pat McMillan, forwhatdateswouldyouliketoreserveaseat: "Feb 9", "Feb 16", "Feb 23", "Mar 2", "Mar 9", "Mar 16", "Mar 23", "Mar 30", "Apr 6", "Apr 13", "Apr 20", "Apr 27", preferregularornovice: Regular, doyouprefertositnsorew: Don't Care, yourpartnerse-mail: [email protected]</content><link rel='self' type='application/atom+xml' href='https://spreadsh eets.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full/72asr'/><link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full/72asr/2g841j07hf00g5'/><gsx:timestamp>6/19/2010 12:14:57</gsx:timestamp><gsx:yourna me>Elizabeth Wood</gsx:yourname><gsx:youre-mailcontactinformation>[email protected]</gsx:youre-mailcontactinformation><gsx:yourpartnersname>Pat McMillan</gsx:yourpartnersname><gsx:forwhatdateswouldyouliketoreserveaseat>"Feb 9", "Feb 16", "Feb 23", "Mar 2", "Mar 9", "Mar 16", "Mar 23", "Mar 30", "Apr 6", "Apr 13", "Apr 20", "Apr 27"</gsx:forwhatdateswouldyouliketoreserveaseat><gsx:experiencelevel></gsx:experiencelevel><gsx:preferredconventioncard></gsx:preferredconventioncard><gsx:preferregularornovice>Regular</gsx:preferregularornovice><gsx:doyouprefertositnsorew>Don't Care</gsx :doyouprefertositnsorew><gsx:yourpartnerse-mail>[email protected]</gsx:yourpartnerse-mail></entry><entry><id>https://spreadsheets.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full/753xl</id><updated>2011-02-10T18:42:43.236Z</updated><category scheme='http://schemas.google.com/ spreadsheets/2006' term='http://schemas.google.com/spreadsheets/2006#list'/><title type='text'>6/19/2010 12:16:28</title><content type='text'>yourname: Elizabeth Wood, youre-mailcontactinformation: [email protected], yourpartnersname: Judy Taylor, forwhatdateswouldyouliketoreserveaseat: "Fe b 14", "Feb 21", "Feb 28", "Mar 7", "Mar 14", "Mar 21", "Mar 28", "Apr 4", "Apr 11", "Apr 18", "Apr 25", preferregularornovice: Regular, doyouprefertositnsorew: Don't Care, yourpartnerse-mail: [email protected]</content><link rel='self' type='application/atom+xml' href='https://spreadshee ts.google.com/feeds/list/tjrHQVklaeCW91WrbJWcrlQ/od6/private/full/753xl'/><link rel='edit' type='application/atom+xml' href='https://spreadsheets.google.com does not return the etag as the following documentation describes: Retrieving a list-based feed ProtocolJava 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. To retrieve a list-based feed, send the following GET request, using the list feed's URI and an appropriate authorization header: GET https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full Google Spreadsheets returns an Atom feed resembling the following: <feed xmlns="http://www.w3.org/2005/Atom"; xmlns:openSearch="http://a9.com/-/spec/opensearch/1.1/"; xmlns:gsx="http://schemas.google.com/spreadsheets/2006/extended"; xmlns:gd="http://schemas.google.com/g/2005"; gd:etag='W/"D0cERnk-eip7ImA9WBBXGEg."'> <id>https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full</id> <updated>2006-11-17T18:23:45.173Z</updated> <title type="text">Sheet1</title> <content type="application/atom+xml;type=feed" src=" https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full"/> <link rel="alternate" type="text/html" href="https://spreadsheets.google.com/ccc?key=key"/> <link rel="http://schemas.google.com/g/2005#feed"; type="application/atom+xml" href=" https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full"/> <link rel="http://schemas.google.com/g/2005#post"; type="application/atom+xml" href=" https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full"/> <link rel="self" type="application/atom+xml" href=" https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full"/> <author> <name>Fitzwilliam Darcy</name> <email>[email protected]</email> </author> <openSearch:totalResults>8</openSearch:totalResults> <openSearch:startIndex>1</openSearch:startIndex> <openSearch:itemsPerPage>8</openSearch:itemsPerPage> <entry gd:etag='"S0wCTlpIIip7ImA0X0QI"'> <id>https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full/rowId</id> <updated>2006-11-17T18:23:45.173Z</updated> <category scheme="http://schemas.google.com/spreadsheets/2006"; term="http://schemas.google.com/spreadsheets/2006#list"/> <title type="text">Bingley</title> <content type="text">Hours: 10, Items: 2, IPM: 0.0033</content> <link rel="self" type="application/atom+xml" href=" https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full/rowId "/> <link rel="edit" type="application/atom+xml" href=" https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full/rowId/version "/> <gsx:name>Bingley</gsx:name> <gsx:hours>10</gsx:hours> <gsx:items>2</gsx:items> <gsx:ipm>0.0033</gsx:ipm> </entry> ... <entry gd:etag='"AxQDSXxjfyp7ImA0ChJVSBI."'> <id>https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full/rowId</id> <updated>2006-11-17T18:23:45.173Z</updated> <category scheme="http://schemas.google.com/spreadsheets/2006"; term="http://schemas.google.com/spreadsheets/2006#list"/> <title type="text">Charlotte</title> <content type="text">Hours: 60, Items: 18000, IPM: 5</content> <link rel="self" type="application/atom+xml" href=" https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full/rowId "/> <link rel="edit" type="application/atom+xml" href=" https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full/rowId/version "/> <gsx:name>Charlotte</gsx:name> <gsx:hours>60</gsx:hours> <gsx:items>18000</gsx:items> <gsx:ipm>5</gsx:ipm> </entry> </feed> Each entry represents a row in the worksheet. The <title> element contains the contents of the first cell in the row, and the <content> element contains a textual representation of the data from all the other cells in the row. Each item in the gsx namespace represents the contents of a cell in the row, with elements in the gsx namespace named after the contents of the header cells—that is, the cells in the first row of the worksheet. If a particular header cell is empty, then a unique column ID is used for the gsx element name. If the header cell's content contains a space, it will be removed in the gsx element name. For more information, see the gsx namespace elementssection of the reference document. Note: In a column with an empty header cell, empty cells don't appear as gsx elements; in such a column, only cells that contain data appear as gsxelements. The entries are ordered in the same order in which they appear in the worksheet GUI, unless the query includes the orderby query parameter. For further information about the list feed, see the List-based feed reference section.
