/// <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);
}