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. >> >
