When working with the list-based feed, the assumption is that the header row is already created. If you need to do everything from the script, including the spreadsheet creation, you should probably use the cell-based feed instead:
https://developers.google.com/google-apps/spreadsheets/#working_with_cell-based_feeds Claudio On Thu, Oct 25, 2012 at 3:11 AM, Mandar <[email protected]> wrote: > 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<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. >>>> >>>
