public static async Task <IActionResult> Results( [HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = "Results/{docId}")] HttpRequest req, string docId, ILogger log) { using var service = new GoogleService(docId); string body = await new StreamReader(req.Body).ReadToEndAsync().ConfigureAwait(false); try { var election = await Election.ReadElection(service).ConfigureAwait(false); var results = await service.GetResults(election); return(new OkObjectResult(results)); } catch (GoogleApiException ex) { if (ex.HttpStatusCode == System.Net.HttpStatusCode.NotFound) { return(new NotFoundObjectResult($@"404: NOT FOUND from Google API Could not find a Google Sheets document with documentId: {docId}")); } if (ex.HttpStatusCode == System.Net.HttpStatusCode.Forbidden) { return(new ObjectResult($@"403: NOT AUTHORIZED from Google API This service has not been authorized to access documentId: {docId} Please share your Google Sheets document with [email protected] and try again Note that you must grant Editor access for the service to update your document") { StatusCode = 403 }); } return(new BadRequestObjectResult(ex)); } catch (Exception ex) { log.LogInformation(ex.GetType().AssemblyQualifiedName); log.LogInformation(ex.ToString()); return(new BadRequestObjectResult(ex.ToString())); } }