You have to set the first row with values. This is the header row.
list rowRow of cells in a worksheet, represented as a key-value pair, where > each key is a column name, and each value is the cell value. The first row > of a worksheet is always considered the header row when using the API, and > therefore is the row that defines the keys represented in each row. Then you match those up with the LocalName and it works fine as long as you don't use numbers. On Wednesday, October 24, 2012 4:14:26 AM UTC-6, Mandar wrote: > > Hello, > I am also getting the same error for 4 days now, I am able to delete a > row or update it (if i add manually), but adding a row seems to be > generating this bad response. > > > > Le mercredi 24 octobre 2012 03:56:25 UTC+2, steve gourley a écrit : >> >> Hi I have a google.gov account and I am trying to fool with the >> spreadsheet api to write to a worksheet. I'm using the clientLogin to use >> my google.gov login from a .net console app that will periodically write >> to the spreadsheet. >> >> I am successfully able to authenticate, list my spreadsheets, grab the >> one I want, grab the worksheet and create some row elements but inserting >> fails. The response status code is 400 bad request, the response string is >> We're sorry, a server error occurred. Please wait a bit and try reloading >> your spreadsheet. >> >> The exception message is Execution of request failed: >> https://spreadsheets.google.com/feeds/list/some mumbo >> jumbo/od6/private/full >> >> the url for my spreadsheet in a browser is something like >> https://docs.google.com/a/utah.gov/spreadsheet/ccc?key= >> >> strack trace >> >> at Google.GData.Client.GDataRequest.Execute() >> at Google.GData.Client.GDataGAuthRequest.Execute(Int32 retryCounter) >> at Google.GData.Client.GDataGAuthRequest.Execute() >> at Google.GData.Client.Service.EntrySend(Uri feedUri, AtomBase >> baseEntry, GDataRequestType type, AsyncSendData data) >> at Google.GData.Client.Service.Insert(Uri feedUri, AtomEntry newEntry, >> AsyncSendData data) >> at Google.GData.Client.Service.Insert[TEntry](Uri feedUri, TEntry >> entry) >> at >> Google.GData.Client.Service.Google.GData.Client.IService.Insert(AtomFeed >> feed, AtomEntry entry) >> at Google.GData.Client.Service.Insert[TEntry](AtomFeed feed, TEntry >> entry) >> at mapservResponseTimes.Program.Main() in >> c:\Projects\Experimental\mapservResponseTimes\Program.cs:line 58 >> at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, >> String[] args) >> at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence >> assemblySecurity, String[] args) >> at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() >> at System.Threading.ThreadHelper.ThreadStart_Context(Object state) >> at System.Threading.ExecutionContext.RunInternal(ExecutionContext >> executionContext, ContextCallback callback, Object state, Boolean >> preserveSyncCtx) >> at System.Threading.ExecutionContext.Run(ExecutionContext >> executionContext, ContextCallback callback, Object state, Boolean >> preserveSyncCtx) >> at System.Threading.ExecutionContext.Run(ExecutionContext >> executionContext, ContextCallback callback, Object state) >> at System.Threading.ThreadHelper.ThreadStart() >> >> What gem of information am I missing to use this with a google for >> business account? >> >
