Right, I'm glad this clarification helped you. Claudio
On Wed, Oct 24, 2012 at 11:47 AM, steve gourley <[email protected]>wrote: > a better error message would really help this out and a more clear > description in the docs would also help. > > > On Wednesday, October 24, 2012 12:46:11 PM UTC-6, steve gourley wrote: >> >> 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<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=<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? >>>> >>>
