public async System.Threading.Tasks.Task <HttpResponseMessage> ExecuteAsync(ExcelMergeHandlerFunctionArgs args)
{
// Get request body
string requestJson = await _request.Content.ReadAsStringAsync();
var js = new JavaScriptSerializer();
try
{
var request = js.Deserialize <PostBody>(requestJson);
if (request == null)
{
throw new InvalidOperationException("No merge data");
}
if (request.Workbook == string.Empty && request.WorkbookUrl == string.Empty)
{
throw new InvalidOperationException("Document template is missing");
}
byte[] workbook;
if (request.Workbook != string.Empty)
{
workbook = Convert.FromBase64String(request.Workbook);
}
else
{
workbook = await(new WebClient()).DownloadDataTaskAsync(request.WorkbookUrl);
}
Log("Got workbook.");
var result = Merger.Merge(workbook, request);
Log($"Merged data with workbook");
_response.Content = new ByteArrayContent(result);
_response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment")
{
FileName = request.FileName
};
_response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/octet-stream");
_response.Content.Headers.ContentType.MediaType = MimeMapping.GetMimeMapping(request.FileName);
_response.StatusCode = HttpStatusCode.OK;
return(_response);
}
catch (Exception ex)
{
Log(ex.ToString());
_response.StatusCode = HttpStatusCode.BadRequest;
_response.Content = new StringContent(GetErrorPage());
_response.Content.Headers.ContentType = new MediaTypeHeaderValue("text/html");
return(_response);
}
}
public static async Task <HttpResponseMessage> Run([HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "ExcelMerge")] HttpRequestMessage req, TraceWriter log)
{
log.Info("C# HTTP trigger function processed a request.");
Log(log, $"C# HTTP trigger function processed a request! RequestUri={req.RequestUri}");
var func = new ExcelMergeHandler(req);
func.FunctionNotify += (sender, args) => Log(log, args.Message);
var functionArgs = new ExcelMergeHandlerFunctionArgs
{
StorageAccount = ConfigurationManager.AppSettings["ConfigurationStorageAccount"],
StorageAccountKey = ConfigurationManager.AppSettings["ConfigurationStorageAccountKey"]
};
return(await Task.Run(() => func.ExecuteAsync(functionArgs)));
}
