Hi,
I'm busy fiddling with the spreadsheets API trying to get an async type
update working but I'm running into some weird issues at the moment.
Based on some old posts that look like they're using a different version of
the API, it seems like it's possible (or at least used to be possible) to
run a batch update without running a batch query on the cells that you need
to update beforehand.
Is this true or has there been some change that stops this from being
possible or has it never been possible and I'm just missing the plot?
When I create my cell entries using the below code, I get a "Missing
Resource Version ID" for the first update followed by "Internal Error" for
every subsequent update.
CellFeed batchRequest = new CellFeed(cellQuery.Uri, service);
foreach (CellAddress cellAddr in cellAddrs)
{
//CellEntry batchEntry = cellEntries[cellAddr.IdString];
CellEntry batchEntry = new CellEntry(cellAddr.Row,
cellAddr.Col);
batchEntry.Id = new AtomId(string.Format("{0}/{1}",
cellFeed.Self, cellAddr.IdString));
batchEntry.InputValue = cellAddr.IdString;
batchEntry.BatchData = new
GDataBatchEntryData(cellAddr.IdString, GDataBatchOperationType.update);
batchRequest.Entries.Add(batchEntry);
}
The code is based on the example in the documentation but as I said, I'm
trying to bypass the query and run the update immediately.
Any help would be appreciated.
Thanks,
Mark.
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
