Started getting below error randomly. while same code works fine if I stop my service and sun again. but after 1 days or two its start giving this error. I have scheduled a job to run after every 15 minutes where based on some condition it update the K column value.
A quick help is highly appreciated.
Error message : Google.Apis.Requests.RequestError Range (Sheet1!K1254) exceeds grid limits. Max rows: 804, max columns: 25 [400] Errors [ Message[Range (Sheet1!K1254) exceeds grid limits. Max rows: 804, max columns: 25] Location[ - ] Reason[badRequest] Domain[global] ]
Edit1: code which I am using to update the code:
private static async Task UpdateValue(SpreadsheetsResource.ValuesResource valuesResource,string updatedvalue, string emailaddr)
{
var valueRange = new ValueRange { Values = new List<IList<object>> { new List<object> { updatedvalue } } };
var update = valuesResource.Update(valueRange, SpreadsheetId, WriteRange);
update.ValueInputOption = SpreadsheetsResource.ValuesResource.UpdateRequest.ValueInputOptionEnum.RAW;
var response = await update.ExecuteAsync();
Console.WriteLine($"Updated Licenses Status for : { response.UpdatedRows} " + emailaddr );
}