Hello, Thank you for your reply. As per your post, I modified the structure of my spreadsheet's worksheet while its creation. But, I still get the same error. Perhaps, if I manually add the header row and then add the row (as provided in the documentation), then it is adding the row successfully; But this is completely buggy, as I cannot manually insert a header row after I create a worksheet. In programming terms the flow should be 1. Creating a spreadsheet 2. Adding a worksheet 3. Adding a row to worksheet
I cannot add a header column in between manually!!! Kindly specify if I am doing something wrong or that is the way the API is build? Thankx in Advance!! On Wednesday, October 24, 2012 8:37:34 PM UTC+2, Claudio Cherubino wrote: > > As reported in the documentation, the list feed makes some assumptions > about how the data is laid out in the spreadsheet. In particular, the list > feed treats the first row of the worksheet as a header row: > > > https://developers.google.com/google-apps/spreadsheets/#working_with_list-based_feeds > > In your code you are trying to add a row with four values: firstname, > lastname, age and height. If the first row of the worksheet doesn't define > those headers, your request will be invalid and your code throw an > exception. > > Please make sure that your code matches the structure of the spreadsheet > or use the Cell feed if you need to dynamically determine the contents of > the header row. > > On Wednesday, October 24, 2012 8:27:56 AM UTC-7, Mandar wrote: >> >> Hello, >> Is this forum alive? I am continuing to get 400 response error for >> adding a row via google spreadsheet api and their isn't any support from on >> this from google admins. Is this API a release version or in alpha phase. >> We are using this api for commercial purposes so answer is expected >> after similar posts (of error messages) from other users as well. >> >> Thankx in advance. >> >> >> Le mercredi 24 octobre 2012 12:11:29 UTC+2, Mandar a écrit : >>> >>> Hello All, >>> I am new to this forum. >>> I am recently using Google spreadsheet API for creating spreadsheets >>> and store data on them. >>> I have followed the entire tut with specifying oAuth scopes and >>> enabling drive sdk. >>> I am successfully able to create a spreadsheet and add a worksheet >>> too, but when I try to add a new row its gives me a exception : {"The >>> remote server returned an error: (400) Bad Request."} >>> Moreover, I am also able to delete and update a row if I add one >>> manually on the spreadsheets, so I don't understand what is wrong in my >>> code (or if their is error on google server side?). >>> Also,the version 3 of API is just released and their isn't any >>> support on the bugs from Google admins/developers. >>> >>> Anyone knowing plz help!! >>> Thankx in advance. >>> >>
