Update rows in database table | Athena

Update rows matching the filter conditions. Filter conditions are passed as query parameters using PostgREST syntax.

Filter Syntax:

?column=eq.value - Equal
?column=neq.value - Not equal
?column=gt.value - Greater than
?column=gte.value - Greater than or equal
?column=lt.value - Less than
?column=lte.value - Less than or equal
?column=like.*pattern* - LIKE (case-sensitive)
?column=ilike.*pattern* - ILIKE (case-insensitive)
?column=in.(a,b,c) - IN list
?column=is.null - IS NULL

Safety: Filters are required by default to prevent accidental bulk updates. To update all rows intentionally, pass ?force=true.

Update rows matching the filter conditions. Filter conditions are passed as query parameters using PostgREST syntax. **Filter Syntax:** - `?column=eq.value` - Equal - `?column=neq.value` - Not equal - `?column=gt.value` - Greater than - `?column=gte.value` - Greater than or equal - `?column=lt.value` - Less than - `?column=lte.value` - Less than or equal - `?column=like.*pattern*` - LIKE (case-sensitive) - `?column=ilike.*pattern*` - ILIKE (case-insensitive) - `?column=in.(a,b,c)` - IN list - `?column=is.null` - IS NULL **Safety:** Filters are required by default to prevent accidental bulk updates. To update all rows intentionally, pass `?force=true`.

Authentication

X-API-KEYstring

API Key authentication via header

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Path parameters

asset_idstringRequired

table_namestringRequired

Query parameters

forcebooleanOptionalDefaults to false

Set to true to update all rows (required when no filters provided)

Request

This endpoint expects an object.

datamap from strings to anyRequired

Column values to update

return_representationbooleanOptionalDefaults to false

If true, return the updated rows in the response

Response

Successful Response

datalist of maps from strings to any or null

Affected rows (returned when return_representation=true)

1	curl -X PATCH https://api.athenaintel.com/api/v0/databases/asset_id/data/table_name \
2	-H "X-API-KEY: <apiKey>" \
3	-H "Content-Type: application/json" \
4	-d '{
5	"data": {
6	"email": "alice.smith@example.com",
7	"name": "Alice Smith"
8	},
9	"return_representation": true
10	}'

1	{
2	"data": [
3	{
4	"email": "charlie@example.com",
5	"id": 3,
6	"name": "Charlie"
7	}
8	]
9	}