Skip to content
LydieDevelopers
Menu

Set row values

View as Markdown
PATCH/v1/databases/{databaseId}/rows

Sets property values on one or many rows in one step: rowIds with set/unset applies the same values to every row; updates gives each row its own. Values are checked against the property type; unknown select options are added. Relation changes update the two-way side. uniqueId values are positive whole numbers: pass 12 or "LYD-12".

docs:writeUndoable
Request
curl -X PATCH "https://api.lydie.co/v1/databases/01JCQ3V5MZ8G4ZK2X7T9R6N1PB/rows" \
  -H "Authorization: Bearer $LYDIE_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{}'

Path parameters

Body

  • rowIdsULID[]· ≤ 10000 items
  • setobject

    Default {}

  • unsetULID[]

    Default []

  • updatesobject[]· ≤ 10000 items
    Show 3 fields
  • exactboolean

    Write the values as given: no type checks, no new options, no two-way relation updates. Undo uses it to restore earlier values exactly.

    Default false

  • newOptionsobject

    Options this call adds (recorded by the client so replays mint the same ids).

Response

200
{
  "updated": [
    "01JCQ3V5MZ8G4ZK2X7T9R6N1PB"
  ]
}

Errors use one envelope for every endpoint. See Errors and versions.