Method Run

internal/cmd/sheets.go:372–440

(ctx context.Context, flags *RootFlags)

}

func (c *SheetsBatchUpdateCmd) Run(ctx context.Context, flags *RootFlags) error {
	u := ui.FromContext(ctx)

	spreadsheetID := normalizeGoogleID(strings.TrimSpace(c.SpreadsheetID))
	if spreadsheetID == "" {
		return usage("empty spreadsheetId")
	}

	data, err := parseSheetsBatchUpdateData(c.DataJSON, stdinReader(ctx))
	if err != nil {
		return err
	}

	valueInputOption := strings.TrimSpace(c.ValueInput)
	if valueInputOption == "" {
		valueInputOption = sheetsDefaultValueInputOption
	}
	req := &sheets.BatchUpdateValuesRequest{
		Data:                    data,
		ValueInputOption:        valueInputOption,
		IncludeValuesInResponse: c.IncludeValuesInResponse,
	}
	if strings.TrimSpace(c.ResponseValueRenderOption) != "" {
		req.ResponseValueRenderOption = strings.TrimSpace(c.ResponseValueRenderOption)
	}
	if strings.TrimSpace(c.ResponseDateTimeRenderOption) != "" {
		req.ResponseDateTimeRenderOption = strings.TrimSpace(c.ResponseDateTimeRenderOption)
	}

	if dryRunErr := dryRunExit(ctx, flags, "sheets.batch-update", map[string]any{
		"spreadsheet_id":                   spreadsheetID,
		"value_input_option":               req.ValueInputOption,
		"include_values_in_response":       req.IncludeValuesInResponse,
		"response_value_render_option":     req.ResponseValueRenderOption,
		"response_date_time_render_option": req.ResponseDateTimeRenderOption,
		"data":                             req.Data,
	}); dryRunErr != nil {
		return dryRunErr
	}

	account, err := requireAccount(flags)
	if err != nil {
		return err
	}

	svc, err := sheetsService(ctx, account)
	if err != nil {
		return err
	}

	resp, err := svc.Spreadsheets.Values.BatchUpdate(spreadsheetID, req).Do()
	if err != nil {
		return err
	}

	if outfmt.IsJSON(ctx) {
		return outfmt.WriteJSON(ctx, stdoutWriter(ctx), map[string]any{
			"spreadsheetId":       resp.SpreadsheetId,