private async Task <List <DetailDataViewModel> > GetAsync() { GoogleSheetHelper sheet = new GoogleSheetHelper(); var serviceValues = sheet.GetSheetsService().Spreadsheets.Values; return(await sheet.ReadAsync(serviceValues)); }
private async Task PutAsync([FromBody] DetailDataViewModel newData) { GoogleSheetHelper sheet = new GoogleSheetHelper(); var serviceValues = sheet.GetSheetsService().Spreadsheets.Values; List <object> data = new List <object> { newData.CharName, newData.Type, newData.Skins, newData.Skin_Spotlight }; var end = _configuration.GetValue <string>("DefaultSettings:Parameters:ColumnRange"); string writeRange = "A" + newData.Id + ":" + end + newData.Id; await sheet.WriteAsync(serviceValues, data, writeRange); }