Hello, I am just about at my wits' end. I have been working on interfacing with the Sheets API via Ajax, and I have run into a couple of issues. I am able to sent GET requests just fine, but I am having problems getting my POST/PUSH requests to work correctly. Specifically, I am trying to perform a batch update on a cell feed. Here is the XML that I am sending out: <?xml version="1.0" encoding="UTF-8"?> <feed xmlns:batch="https://schemas.google.com/gdata/batch"; xmlns="http://www.w3.org/2005/Atom"; xmlns:gs="http://schemas.google.com/spreadsheets/2006";> <id>https://spreadsheets.google.com/feeds/cells/1aNOEmp3Xil3zBuod3DhvUE27qEEzTBhxKJ9C9DO2t9Q/od6/private/full</id> <entry> <batch:id>0</batch:id> <batch:operation type="update"/> <title type="text">0</title> <id>https://spreadsheets.google.com/feeds/cells/<KEY>/od6/private/full/R1C1</id> <link rel="edit" type="application/atom+xml" href="https://spreadsheets.google.com/feeds/cells/<KEY>/od6/private/full/R1C1"/> <gs:cell row="1" col="1" inputValue="quux"/> </entry> </feed>
When sending this out via POST, I get the following response: <?xml version="1.0" encoding="UTF-8"?> <feed xmlns="http://www.w3.org/2005/Atom"; xmlns:openSearch="http://a9.com/-/spec/opensearch/1.1/"; xmlns:batch="http://schemas.google.com/gdata/batch"; xmlns:gs="http://schemas.google.com/spreadsheets/2006";> <id>https://spreadsheets.google.com/feeds/cells/1aNOEmp3Xil3zBuod3DhvUE27qEEzTBhxKJ9C9DO2t9Q/od6/batch/1435022622318</id> <updated>2015-06-23T01:23:42.324Z</updated> <category scheme="http://schemas.google.com/spreadsheets/2006"; term="http://schemas.google.com/spreadsheets/2006#cell"/> <title>Batch Feed</title> <entry> <updated>2015-06-23T01:23:42.324Z</updated> <title>Error</title> <content>Insert not supported on batch.</content> <batch:status code="501" reason="Insert not supported on batch."/> </entry> </feed> Trying to send the request via PUT doesn't even work *that* well. I've set up the Authorization ( "Bearer ..."), content-type (application/atom+xml), and GData-Version (3.0) HTTP headers, but it would appear that they are not fixing the problem. Does anyone have any ideas? - Philip B. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
