/// <summary> /// データの更新 /// </summary> internal static void UpdateSheetData( string accessToken, string sheetId, Sheet.SheetProperties prop, string[,] param, string range, Action <PutSheet> success = null, Action <ErrorMessage> error = null) { var titleRange = $"\'{prop.title}\'!{range}"; var url = string.Format(SPREAD_SHEET_PUT_URL, sheetId, titleRange); var json = GoogleSpreadSheetUtil.ConvertPostJson(param, titleRange); var request = new UnityWebRequest(url, "PUT"); request.AddJson(json); request.SetAccessToken(accessToken); void Success() { var put = JsonUtility.FromJson <PutSheet>(request.downloadHandler.text); success?.Invoke(put); } request.Request(Success, error); }
/// <summary> /// シートの中身をロード /// </summary> internal static void GetSheet( string accessToken, string sheetId, Sheet.SheetProperties prop, Action <string[, ]> onLoaded = null, Action <ErrorMessage> error = null) { var url = string.Format(SPREAD_SHEET_GET_URL, sheetId, prop.title); var request = UnityWebRequest.Get(url); request.SetAccessToken(accessToken); void Success() { var sheet = GoogleSpreadSheetUtil.ParseJson(request.downloadHandler.text); onLoaded?.Invoke(sheet); } request.Request(Success, error); }