> This page is for Glide Classic.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://www.glideapps.com/docs/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://www.glideapps.com/docs/_mcp/server.

# Update Row

PATCH https://api.glideapps.com/tables/{tableID}/rows/{rowID}
Content-Type: application/json

Updates an existing row in a Big Table.

If a column is not included in the passed row data, it will not be updated. If a column is passed that does not exist in the table schema, or with a value that does not match the column's type, the default behavior is for no update to be made and the API call to [return an error](/docs/classic-api/general/errors#invalid-row-data). However, you can control this behavior with the `onSchemaError` query parameter.

Reference: https://www.glideapps.com/docs/classic-api/tables/update-row

## Authentication

- `Authorization` header (bearer token, required) — Bearer authentication header of the form Bearer `<token>`, where `<token>` is your [auth token](/docs/api-reference/v2/general/authentication).

## Request

### Path parameters

- `tableID` (string, required)
- `rowID` (string, required)

### Query parameters

- `onSchemaError` (enum, optional) — The action to take when the passed data does not match the table schema: - `abort`: Abort the entire operation and return an error. - `dropColumns`: Ignore the data that caused the error, and do not import those columns in the affected rows. - `updateSchema`: Update the schema as needed to add any missing columns or widen the data types of existing columns, and then import the data from them.
  - Allowed values: `abort`, `dropColumns`, `updateSchema`

### Headers

- `if-match` (string, optional)

### Body (application/json)

This endpoint expects a map from string to any.

- `map from string to any`

## Errors

### 400 Bad Request Error

- `error` (TablesTableIdRowsRowIdPatchResponsesContentApplicationJsonSchemaError, required)

### 402 Payment Required Error

- `error` (TablesTableIdRowsRowIdPatchResponsesContentApplicationJsonSchemaError, required)

### 404 Not Found Error

- `error` (TablesTableIdRowsRowIdPatchResponsesContentApplicationJsonSchemaError, required)

### 412 Precondition Failed Error

- `error` (TablesTableIdRowsRowIdPatchResponsesContentApplicationJsonSchemaError, required)

### 422 Unprocessable Entity Error

- `error` (TablesTableIdRowsRowIdPatchResponsesContentApplicationJsonSchemaError, required)

## Types

### TablesTableIdRowsRowIdPatchResponsesContentApplicationJsonSchemaError

- `type` (enum, required)
  - Allowed values: `column_has_invalid_value`, `column_id_reserved`, `column_id_not_found`
- `message` (string, required)

## Examples

**Request**

```json
{
  "amountPaid": 0,
  "fullName": "Alex Bard",
  "invoiceDate": "2024-07-29T14:04:15.561Z",
  "totalAmount": 34.5
}
```

**Response**

```json
{}
```

**SDK Code**

```python
import requests

url = "https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows/zcJWnyI8Tbam21V34K8MNA"

payload = {
    "amountPaid": 0,
    "fullName": "Alex Bard",
    "invoiceDate": "2024-07-29T14:04:15.561Z",
    "totalAmount": 34.5
}
headers = {
    "Authorization": "Bearer <token>",
    "Content-Type": "application/json"
}

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

print(response.json())
```

```javascript
const url = 'https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows/zcJWnyI8Tbam21V34K8MNA';
const options = {
  method: 'PATCH',
  headers: {Authorization: 'Bearer <token>', 'Content-Type': 'application/json'},
  body: '{"amountPaid":0,"fullName":"Alex Bard","invoiceDate":"2024-07-29T14:04:15.561Z","totalAmount":34.5}'
};

try {
  const response = await fetch(url, options);
  const data = await response.json();
  console.log(data);
} catch (error) {
  console.error(error);
}
```

```go
package main

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

func main() {

	url := "https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows/zcJWnyI8Tbam21V34K8MNA"

	payload := strings.NewReader("{\n  \"amountPaid\": 0,\n  \"fullName\": \"Alex Bard\",\n  \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n  \"totalAmount\": 34.5\n}")

	req, _ := http.NewRequest("PATCH", 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(res)
	fmt.Println(string(body))

}
```

```ruby
require 'uri'
require 'net/http'

url = URI("https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows/zcJWnyI8Tbam21V34K8MNA")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Patch.new(url)
request["Authorization"] = 'Bearer <token>'
request["Content-Type"] = 'application/json'
request.body = "{\n  \"amountPaid\": 0,\n  \"fullName\": \"Alex Bard\",\n  \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n  \"totalAmount\": 34.5\n}"

response = http.request(request)
puts response.read_body
```

```java
import com.mashape.unirest.http.HttpResponse;
import com.mashape.unirest.http.Unirest;

HttpResponse<String> response = Unirest.patch("https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows/zcJWnyI8Tbam21V34K8MNA")
  .header("Authorization", "Bearer <token>")
  .header("Content-Type", "application/json")
  .body("{\n  \"amountPaid\": 0,\n  \"fullName\": \"Alex Bard\",\n  \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n  \"totalAmount\": 34.5\n}")
  .asString();
```

```php
<?php
require_once('vendor/autoload.php');

$client = new \GuzzleHttp\Client();

$response = $client->request('PATCH', 'https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows/zcJWnyI8Tbam21V34K8MNA', [
  'body' => '{
  "amountPaid": 0,
  "fullName": "Alex Bard",
  "invoiceDate": "2024-07-29T14:04:15.561Z",
  "totalAmount": 34.5
}',
  'headers' => [
    'Authorization' => 'Bearer <token>',
    'Content-Type' => 'application/json',
  ],
]);

echo $response->getBody();
```

```csharp
using RestSharp;

var client = new RestClient("https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows/zcJWnyI8Tbam21V34K8MNA");
var request = new RestRequest(Method.PATCH);
request.AddHeader("Authorization", "Bearer <token>");
request.AddHeader("Content-Type", "application/json");
request.AddParameter("application/json", "{\n  \"amountPaid\": 0,\n  \"fullName\": \"Alex Bard\",\n  \"invoiceDate\": \"2024-07-29T14:04:15.561Z\",\n  \"totalAmount\": 34.5\n}", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);
```

```swift
import Foundation

let headers = [
  "Authorization": "Bearer <token>",
  "Content-Type": "application/json"
]
let parameters = [
  "amountPaid": 0,
  "fullName": "Alex Bard",
  "invoiceDate": "2024-07-29T14:04:15.561Z",
  "totalAmount": 34.5
] as [String : Any]

let postData = JSONSerialization.data(withJSONObject: parameters, options: [])

let request = NSMutableURLRequest(url: NSURL(string: "https://api.glideapps.com/tables/2a1bad8b-cf7c-44437-b8c1-e3782df6/rows/zcJWnyI8Tbam21V34K8MNA")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "PATCH"
request.allHTTPHeaderFields = headers
request.httpBody = postData as Data

let session = URLSession.shared
let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in
  if (error != nil) {
    print(error as Any)
  } else {
    let httpResponse = response as? HTTPURLResponse
    print(httpResponse)
  }
})

dataTask.resume()
```