Sorry Eric, You're right, the key is not the problem.. the problem is the url.. the url that im getting in the response is:
http://spreadsheets.google.com/a/mydomain.com/a/mydomain.com/ccc... the /a/mydomain.com part comes twice.. if remove one /a/mydomain.com from the url I no longer get the 405 error.. why is the url coming this way? On Jul 15, 6:01 pm, Eric Bidelman <api.e...@google.com> wrote: > 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/Expo...> > > > 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?%0Ak...> > > > <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/%0A0AvROzS1ElLw3dFdWd...> > > > <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/%0A0AvROzS1ElLw3dFdWdzd0engyY...> > > > <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%3A...> > > '/> > > <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%3A...> > > > <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%3AtWVw...> > > '/> > > <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%3AtWV...> > > > </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/Expo...> > > > 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/%0A0AvROzS1ElLw3dE5XU...> > > > <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/%0A0AvROzS1ElLw3dE5XU01nTXdMR...> > > > <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%3A...> > > > <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%3A...> > > > <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%3AtNWS...> > > '/> > > <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%3AtNW...> > > > </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 -~----------~----~----~----~------~----~------~--~---
