curl --request PUT \
  --url https://api.synci.io/api/v1/destinations/google-sheets/connections/{connectionId}/sheets/{sheetId} \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "name": "<string>",
  "transactions_sheet_gid": 123,
  "transactions_sheet_name": "<string>",
  "live_balance_sheet_gid": 123,
  "live_balance_sheet_name": "<string>",
  "balance_history_sheet_gid": 123,
  "balance_history_sheet_name": "<string>",
  "header_config": []
}
'

const options = {
  method: 'PUT',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: JSON.stringify({
    name: '<string>',
    transactions_sheet_gid: 123,
    transactions_sheet_name: '<string>',
    live_balance_sheet_gid: 123,
    live_balance_sheet_name: '<string>',
    balance_history_sheet_gid: 123,
    balance_history_sheet_name: '<string>',
    header_config: []
  })
};

fetch('https://api.synci.io/api/v1/destinations/google-sheets/connections/{connectionId}/sheets/{sheetId}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

import requests

url = "https://api.synci.io/api/v1/destinations/google-sheets/connections/{connectionId}/sheets/{sheetId}"

payload = {
    "name": "<string>",
    "transactions_sheet_gid": 123,
    "transactions_sheet_name": "<string>",
    "live_balance_sheet_gid": 123,
    "live_balance_sheet_name": "<string>",
    "balance_history_sheet_gid": 123,
    "balance_history_sheet_name": "<string>",
    "header_config": []
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

response = requests.put(url, json=payload, headers=headers)

print(response.text)

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://api.synci.io/api/v1/destinations/google-sheets/connections/{connectionId}/sheets/{sheetId}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "PUT",
  CURLOPT_POSTFIELDS => json_encode([
    'name' => '<string>',
    'transactions_sheet_gid' => 123,
    'transactions_sheet_name' => '<string>',
    'live_balance_sheet_gid' => 123,
    'live_balance_sheet_name' => '<string>',
    'balance_history_sheet_gid' => 123,
    'balance_history_sheet_name' => '<string>',
    'header_config' => [
        
    ]
  ]),
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>",
    "Content-Type: application/json"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

package main

import (
	"fmt"
	"strings"
	"net/http"
	"io"
)

func main() {

	url := "https://api.synci.io/api/v1/destinations/google-sheets/connections/{connectionId}/sheets/{sheetId}"

	payload := strings.NewReader("{\n  \"name\": \"<string>\",\n  \"transactions_sheet_gid\": 123,\n  \"transactions_sheet_name\": \"<string>\",\n  \"live_balance_sheet_gid\": 123,\n  \"live_balance_sheet_name\": \"<string>\",\n  \"balance_history_sheet_gid\": 123,\n  \"balance_history_sheet_name\": \"<string>\",\n  \"header_config\": []\n}")

	req, _ := http.NewRequest("PUT", url, payload)

	req.Header.Add("Authorization", "Bearer <token>")
	req.Header.Add("Content-Type", "application/json")

	res, _ := http.DefaultClient.Do(req)

	defer res.Body.Close()
	body, _ := io.ReadAll(res.Body)

	fmt.Println(string(body))

}

{
  "message": "Spreadsheet updated.",
  "data": {
    "id": "<string>",
    "connection_id": "<string>",
    "connection": {
      "id": "<string>",
      "name": "<string>",
      "enabled": "<string>",
      "google_email": "<string>",
      "last_synced_at": "<string>",
      "created_at": "<string>",
      "updated_at": "<string>",
      "health": {
        "status": "<string>",
        "integrator_message": "<string>",
        "failure_count": "<string>",
        "transient_message": "<string>",
        "transient_failure_count": "<string>",
        "last_attempt_at": "<string>"
      },
      "auth_url": "<string>",
      "sheets": "<array>"
    },
    "health": {
      "status": "<string>",
      "integrator_message": "<string>",
      "failure_count": "<string>",
      "transient_message": "<string>",
      "transient_failure_count": "<string>",
      "last_attempt_at": "<string>"
    },
    "name": "<string>",
    "spreadsheet_id": "<string>",
    "spreadsheet_name": "<string>",
    "spreadsheet_url": "<string>",
    "is_synci_managed": "<string>",
    "transactions_sheet_gid": "<string>",
    "transactions_sheet_name": "<string>",
    "live_balance_sheet_gid": "<string>",
    "live_balance_sheet_name": "<string>",
    "balance_history_sheet_gid": "<string>",
    "balance_history_sheet_name": "<string>",
    "last_synced_at": "<string>",
    "created_at": "<string>",
    "updated_at": "<string>",
    "transfer_links": [
      {
        "id": "<string>",
        "financial_account_id": "<string>",
        "destination_type": "<string>",
        "destination_id": "<string>",
        "transfer_start_date": "2025-01-01",
        "active": "<string>",
        "sync_mode": "<string>",
        "on_booked_change": {
          "update_status": "<string>",
          "update_payee": "<string>",
          "update_description": "<string>",
          "update_amount": "<string>"
        },
        "created_at": "<string>",
        "updated_at": "<string>",
        "financial_account": {
          "id": "<string>",
          "enabled": "<string>",
          "integrator": "<string>",
          "account_category": "<string>",
          "raw_type": "<string>",
          "cash_balance": {
            "amount": "<string>",
            "currency": "<string>"
          },
          "total_balance": {
            "amount": "<string>",
            "currency": "<string>"
          },
          "meta": "<string>",
          "name": "<string>",
          "custom_name": "<string>",
          "display_name": "<string>",
          "currency": "<string>",
          "product_name": "<string>",
          "cash_account_type": "<string>",
          "account_usage": "<string>",
          "linked_accounts": "<string>",
          "details": "<string>",
          "details_last_synced_at": "<string>",
          "transactions_last_synced_at": "<string>",
          "transactions_backfill_cursor": "<string>",
          "balances_last_synced_at": "<string>",
          "balance": {
            "available": "<string>",
            "cleared": "<string>"
          },
          "created_at": "<string>",
          "updated_at": "<string>",
          "financial_connection_id": "<string>",
          "financial_connection": {
            "id": "<string>",
            "institution_id": "<string>",
            "region": "<string>",
            "enabled": "<string>",
            "status": "<string>",
            "status_message": "<string>",
            "sync_balances": "<string>",
            "supports_reauthorization": true,
            "supports_manage": true,
            "max_historical_days": "<string>",
            "access_valid_for_days": "<string>",
            "consent_expires_at": "<string>",
            "reference": "<string>",
            "accounts_last_synced_at": "<string>",
            "setup_pending": true,
            "setup_renewal": "<string>",
            "activated_at": "<string>",
            "created_at": "<string>",
            "updated_at": "<string>",
            "institution": {
              "id": "<string>",
              "integrator": "<string>",
              "region": "<string>",
              "country": "<string>",
              "name": "<string>",
              "bic": "<string>",
              "external_id": "<string>",
              "logo": "<string>",
              "supported": "<string>",
              "supports_pending_transactions": "<string>",
              "supports_card_accounts": "<string>",
              "max_historical_days": "<string>",
              "max_access_valid_for_days": "<string>",
              "supported_products": "<string>",
              "category": "<string>",
              "updated_at": "<string>"
            },
            "health": {
              "status": "<string>",
              "integrator_message": "<string>",
              "failure_count": "<string>",
              "transient_message": "<string>",
              "transient_failure_count": "<string>",
              "last_attempt_at": "<string>"
            },
            "financial_accounts": "<array>",
            "financial_accounts_count": "<string>"
          },
          "config": {
            "map_fields": {
              "payee": "<string>",
              "description": "<string>",
              "date": "<string>"
            },
            "enrichment": {
              "enabled": "<string>",
              "provider": "<string>",
              "country": "<string>"
            },
            "sync_start_date": "2025-01-01",
            "sync_auto": "<string>",
            "sync_pending_transactions": "<string>",
            "pending_settlement_matching": "<string>",
            "pending_settlement_max_days": "<string>",
            "fuzzy_counterparty_matching": "<string>",
            "fuzzy_counterparty_min_chars": "<string>",
            "sync_balances": "<string>",
            "sync_frequency_in_minutes": "<string>",
            "fields_for_duplicate_filtering": [
              "<string>"
            ]
          },
          "health": {
            "status": "<string>",
            "integrator_message": "<string>",
            "failure_count": "<string>",
            "transient_message": "<string>",
            "transient_failure_count": "<string>",
            "last_attempt_at": "<string>"
          },
          "account_number_masked": "<string>",
          "bban": "<string>",
          "scan": "<string>",
          "iban": "<string>",
          "bic": "<string>",
          "owner_name": "<string>",
          "owner_address": "<string>",
          "msisdn": "<string>",
          "integrator_id": "<string>",
          "institution_id": "<string>",
          "rules": [
            {
              "order": 123,
              "rule": {}
            }
          ],
          "transfer_links": "<array>",
          "transfer_links_count": "<string>"
        },
        "destination": {
          "id": "<string>",
          "budget_id": "<string>",
          "ynab_id": "<string>",
          "name": "<string>",
          "type": "<string>",
          "on_budget": "<string>",
          "closed": "<string>",
          "note": "<string>",
          "balance": "<string>",
          "cleared_balance": "<string>",
          "uncleared_balance": "<string>",
          "transfer_payee_id": "<string>",
          "direct_import_linked": "<string>",
          "last_reconciled_at": "<string>",
          "created_at": "<string>",
          "updated_at": "<string>",
          "budget": {
            "id": "<string>",
            "connection_id": "<string>",
            "ynab_id": "<string>",
            "enabled": "<string>",
            "name": "<string>",
            "currency": "<string>",
            "first_month": "<string>",
            "last_month": "<string>",
            "last_synced_at": "<string>",
            "created_at": "<string>",
            "updated_at": "<string>",
            "connection": {
              "id": "<string>",
              "name": "<string>",
              "enabled": "<string>",
              "sync_balances": "<string>",
              "ynab_user_id": "<string>",
              "last_synced_at": "<string>",
              "created_at": "<string>",
              "updated_at": "<string>",
              "health": {
                "status": "<string>",
                "integrator_message": "<string>",
                "failure_count": "<string>",
                "transient_message": "<string>",
                "transient_failure_count": "<string>",
                "last_attempt_at": "<string>"
              },
              "auth_url": "<string>",
              "budgets": "<array>"
            },
            "accounts": "<array>"
          },
          "health": {
            "status": "<string>",
            "integrator_message": "<string>",
            "failure_count": "<string>",
            "transient_message": "<string>",
            "transient_failure_count": "<string>",
            "last_attempt_at": "<string>"
          },
          "transfer_links": "<array>"
        },
        "rules": [
          {
            "order": 123,
            "rule": {}
          }
        ]
      }
    ]
  }
}

{
  "message": "<string>"
}

{
  "message": "<string>"
}

{
  "message": "<string>"
}

{
  "message": "<string>",
  "errors": {}
}