Our backend recently changed a bit but both keys should workas the Google Spreadsheet key=X value. (Just verified that myself)
The one that starts with TNWS is a legacy ID/key, while the 0Av... is the new version. In general, you should be using whatever value the alternate link is giving you to view the doc in gDocs. Eric On Wed, Jul 15, 2009 at 2:57 PM, jonathan. <jonathan.ri...@gmail.com> wrote: > > Hello Eric, > > Yes, bellow you'll find two examples of responses when uploading the > csv documents... > > EXAMPLE 1: > > <?xml version='1.0' encoding='UTF-8'?> > <entry xmlns='http://www.w3.org/2005/Atom' xmlns:docs='http:// > schemas.google.com/docs/2007' xmlns:batch='http://schemas.google.com/ > gdata/batch <http://schemas.google.com/%0Agdata/batch>' xmlns:gd=' > http://schemas.google.com/g/2005'> > <id>http://docs.google.com/feeds/documents/private/full/ > spreadsheet > %3AtWVw7tzx2aZcPNWHvqaoLng</id> > <published>2009-07-15T21:45:51.967Z</published> > <updated>2009-07-15T21:45:51.967Z</updated> > <category scheme='http://schemas.google.com/g/2005/labels' > term='http://schemas.google.com/g/2005/labels#viewed' label='viewed'/ > > > <category scheme='http://schemas.google.com/g/2005#kind' > term='http:// > schemas.google.com/docs/2007#spreadsheet' label='spreadsheet'/> > <title type='text'>(Testing Spreadsheet1) Worksheet</title> > <content type='text/html' src='http://spreadsheets.google.com/ > feeds/ > download/spreadsheets/Export? > key=0AvROzS1ElLw3dFdWdzd0engyYVpjUE5XSHZxYW9Mbmc'/<http://spreadsheets.google.com/%0Afeeds/%0Adownload/spreadsheets/Export?%0Akey=0AvROzS1ElLw3dFdWdzd0engyYVpjUE5XSHZxYW9Mbmc'/> > > > > THIS IS WHERE A DIFFERENT KEY APPEARS IN THE URL: > > <link rel='alternate' type='text/html' href='http:// > spreadsheets.google.com/a/mydomain.com/a/mydomain.com/ccc? > key=0AvROzS1ElLw3dFdWdzd0engyYVpjUE5XSHZxYW9Mbmc&hl=en'/<http://spreadsheets.google.com/a/mydomain.com/a/mydomain.com/ccc?%0Akey=0AvROzS1ElLw3dFdWdzd0engyYVpjUE5XSHZxYW9Mbmc&hl=en'/> > > > > <link rel='http://schemas.google.com/spreadsheets/ > 2006#worksheetsfeed<http://schemas.google.com/spreadsheets/%0A2006#worksheetsfeed>' > type='application/atom+xml' href='http:// > spreadsheets.google.com/feeds/worksheets/ > 0AvROzS1ElLw3dFdWdzd0engyYVpjUE5XSHZxYW9Mbmc/private/full'/<http://spreadsheets.google.com/feeds/worksheets/%0A0AvROzS1ElLw3dFdWdzd0engyYVpjUE5XSHZxYW9Mbmc/private/full'/> > > > <link rel='http://schemas.google.com/spreadsheets/ > 2006#tablesfeed<http://schemas.google.com/spreadsheets/%0A2006#tablesfeed> > ' > type='application/atom+xml' href='http://spreadsheets.google.com/ > feeds/ > 0AvROzS1ElLw3dFdWdzd0engyYVpjUE5XSHZxYW9Mbmc/tables'/<http://spreadsheets.google.com/%0Afeeds/%0A0AvROzS1ElLw3dFdWdzd0engyYVpjUE5XSHZxYW9Mbmc/tables'/> > > > <link rel='self' type='application/atom+xml' href='http:// > docs.google.com/feeds/documents/private/full/spreadsheet > %3AtWVw7tzx2aZcPNWHvqaoLng<http://docs.google.com/feeds/documents/private/full/spreadsheet%0A%3AtWVw7tzx2aZcPNWHvqaoLng> > '/> > <link rel='edit' type='application/atom+xml' href='http:// > docs.google.com/feeds/documents/private/full/spreadsheet > %3AtWVw7tzx2aZcPNWHvqaoLng/fx6l03fj'/<http://docs.google.com/feeds/documents/private/full/spreadsheet%0A%3AtWVw7tzx2aZcPNWHvqaoLng/fx6l03fj'/> > > > <link rel='edit-media' type='text/html' href='http:// > docs.google.com/ > feeds/media/private/full/spreadsheet%3AtWVw7tzx2aZcPNWHvqaoLng/ > fx6l03fj<http://docs.google.com/%0Afeeds/media/private/full/spreadsheet%3AtWVw7tzx2aZcPNWHvqaoLng/%0Afx6l03fj> > '/> > <author> > <name>jrico</name> > <email>jr...@mydomain.com</email> > </author> > > THIS IS THE CORRECT KEY: > > <gd:resourceId>spreadsheet:tWVw7tzx2aZcPNWHvqaoLng</ > gd:resourceId> > <gd:lastModifiedBy> > <name>jrico</name> > <email>jr...@mydomain.com</email> > </gd:lastModifiedBy> > <gd:lastViewed>2009-07-15T21:45:53.370Z</ > gd:lastViewed> > <gd:quotaBytesUsed>0</gd:quotaBytesUsed> > <docs:writersCanInvite value='true'/> > <gd:feedLink rel='http://schemas.google.com/acl/ > 2007#accessControlList<http://schemas.google.com/acl/%0A2007#accessControlList>' > href='http://docs.google.com/feeds/acl/ > private/ > full/spreadsheet%3AtWVw7tzx2aZcPNWHvqaoLng'/<http://docs.google.com/feeds/acl/%0Aprivate/%0Afull/spreadsheet%3AtWVw7tzx2aZcPNWHvqaoLng'/> > > > </entry> > > EXAMPLE 2: > > <?xml version='1.0' encoding='UTF-8'?> > <entry xmlns='http://www.w3.org/2005/Atom' xmlns:docs='http:// > schemas.google.com/docs/2007' xmlns:batch='http://schemas.google.com/ > gdata/batch <http://schemas.google.com/%0Agdata/batch>' xmlns:gd=' > http://schemas.google.com/g/2005'> > <id>http://docs.google.com/feeds/documents/private/full/ > spreadsheet > %3AtNWSMgMwLEWtv9VF-RKvgGA</id> > <published>2009-07-15T21:46:29.440Z</published> > <updated>2009-07-15T21:46:29.440Z</updated> > <category scheme='http://schemas.google.com/g/2005/labels' > term='http://schemas.google.com/g/2005/labels#viewed' label='viewed'/ > > > <category scheme='http://schemas.google.com/g/2005#kind' > term='http:// > schemas.google.com/docs/2007#spreadsheet' label='spreadsheet'/> > <title type='text'>(Testing SpreadSheet2) Worksheet</title> > <content type='text/html' src='http://spreadsheets.google.com/ > feeds/ > download/spreadsheets/Export? > key=0AvROzS1ElLw3dE5XU01nTXdMRVd0djlWRi1SS3ZnR0E'/<http://spreadsheets.google.com/%0Afeeds/%0Adownload/spreadsheets/Export?%0Akey=0AvROzS1ElLw3dE5XU01nTXdMRVd0djlWRi1SS3ZnR0E'/> > > > > DIFFERENT KEY APPEARS IN THE URL: > > <link rel='alternate' type='text/html' href='http:// > spreadsheets.google.com/a/mydomain.com/a/mydomain.com/ccc? > key=0AvROzS1ElLw3dE5XU01nTXdMRVd0djlWRi1SS3ZnR0E&hl=en'/> > <link rel='http://schemas.google.com/spreadsheets/ > 2006#worksheetsfeed<http://schemas.google.com/spreadsheets/%0A2006#worksheetsfeed>' > type='application/atom+xml' href='http:// > spreadsheets.google.com/feeds/worksheets/ > 0AvROzS1ElLw3dE5XU01nTXdMRVd0djlWRi1SS3ZnR0E/private/full'/<http://spreadsheets.google.com/feeds/worksheets/%0A0AvROzS1ElLw3dE5XU01nTXdMRVd0djlWRi1SS3ZnR0E/private/full'/> > > > <link rel='http://schemas.google.com/spreadsheets/ > 2006#tablesfeed<http://schemas.google.com/spreadsheets/%0A2006#tablesfeed> > ' > type='application/atom+xml' href='http://spreadsheets.google.com/ > feeds/ > 0AvROzS1ElLw3dE5XU01nTXdMRVd0djlWRi1SS3ZnR0E/tables'/<http://spreadsheets.google.com/%0Afeeds/%0A0AvROzS1ElLw3dE5XU01nTXdMRVd0djlWRi1SS3ZnR0E/tables'/> > > > <link rel='self' type='application/atom+xml' href='http:// > docs.google.com/feeds/documents/private/full/spreadsheet > %3AtNWSMgMwLEWtv9VF-RKvgGA'/<http://docs.google.com/feeds/documents/private/full/spreadsheet%0A%3AtNWSMgMwLEWtv9VF-RKvgGA'/> > > > <link rel='edit' type='application/atom+xml' href='http:// > docs.google.com/feeds/documents/private/full/spreadsheet > %3AtNWSMgMwLEWtv9VF-RKvgGA/fx6l0wcg'/<http://docs.google.com/feeds/documents/private/full/spreadsheet%0A%3AtNWSMgMwLEWtv9VF-RKvgGA/fx6l0wcg'/> > > > <link rel='edit-media' type='text/html' href='http:// > docs.google.com/ > feeds/media/private/full/spreadsheet%3AtNWSMgMwLEWtv9VF-RKvgGA/ > fx6l0wcg<http://docs.google.com/%0Afeeds/media/private/full/spreadsheet%3AtNWSMgMwLEWtv9VF-RKvgGA/%0Afx6l0wcg> > '/> > <author> > <name>jrico</name> > <email>jr...@mydomain.com</email> > </author> > > CORRECT KEY: > > <gd:resourceId>spreadsheet:tNWSMgMwLEWtv9VF-RKvgGA</ > gd:resourceId> > <gd:lastModifiedBy> > <name>jrico</name> > <email>jr...@mydomain.com</email> > </gd:lastModifiedBy> > <gd:lastViewed>2009-07-15T21:46:30.346Z</gd:lastViewed> > <gd:quotaBytesUsed>0</gd:quotaBytesUsed> > <docs:writersCanInvite value='true'/> > <gd:feedLink rel='http://schemas.google.com/acl/ > 2007#accessControlList<http://schemas.google.com/acl/%0A2007#accessControlList>' > href='http://docs.google.com/feeds/acl/ > private/ > full/spreadsheet%3AtNWSMgMwLEWtv9VF-RKvgGA'/<http://docs.google.com/feeds/acl/%0Aprivate/%0Afull/spreadsheet%3AtNWSMgMwLEWtv9VF-RKvgGA'/> > > > </entry> > > Hope this helps, thanks in advance > > > On Jul 15, 3:34 pm, "Eric (Google)" <api.e...@google.com> wrote: > > Can you post the two different examples? > > > > On Jul 15, 12:11 pm, "jonathan." <jonathan.ri...@gmail.com> wrote: > > > > > > > > > Hello everyone, > > > > > I started to get an error today when uploading a document as a Google > > > Spreadsheeet, the URL for accessing the spreadsheet contains a > > > different key from the one in gd:resourceId. If I navigate to the url > > > provided with the new key I get an 405 error... any ideas on why this > > > is happening? This just started today... > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Docs Data APIs" group. To post to this group, send email to Google-Docs-Data-APIs@googlegroups.com To unsubscribe from this group, send email to google-docs-data-apis+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Docs-Data-APIs?hl=en -~----------~----~----~----~------~----~------~--~---
