Hi,

    I have a problem in inserting worksheet with data to an existing
spreadsheet.  I always got a 500 Internal Error.  I'm sure I have
authenticated correctly to the google service using ClientAuth coz I
got the authentication token and in fact when I just insert a
worksheet that has no data inside it the worksheet is created inside
the spreadsheet but if I insert a worksheet with data (csv data) i
always got a 500 Internal Error response from the google server. Below
is my HTTP Post Request the one with out data and with data.

WITHOUT DATA => SUCCESSFUL!!! got 201 created response

POST /feeds/worksheets/KEY/private/full
Host: spreadsheets.google.com
Authorization: GoogleLogin auth=<some_authorization_token>
Content-type: application/atom+xml
Content-Length: <some_content_length>
<entry xmlns="http://www.w3.org/2005/Atom";
          xmlns:gs="http://schemas.google.com/spreadsheets/2006";>
          <title>Expenses</title>
          <gs:rowCount>50</gs:rowCount>
          <gs:colCount>10</gs:colCount>
</entry>

WITH DATA => NOT SUCCESSFUL!!! got 500 Internal Server Error response

POST /feeds/worksheets/KEY/private/full
Host: spreadsheets.google.com
Authorization: GoogleLogin auth=<some_authorization_token>
Content-type: multipart/related; boundary=END_OF_PART
Content-Length: <some_content_length>

--END_OF_PART
Content-Type: application/atom+xml

<entry xmlns="http://www.w3.org/2005/Atom";
          xmlns:gs="http://schemas.google.com/spreadsheets/2006";>
          <title>Expenses</title>
          <gs:rowCount>50</gs:rowCount>
          <gs:colCount>10</gs:colCount>
"</entry>

--END_OF_PART
Content-Type: text/csv

MyField1 , MyField2

--END_OF_PART--

Hoping for your help.

Thanks,

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

Reply via email to