Skip to content
LydieDevelopers
Menu

Write database rows

View as Markdown
POST/v1/databases/{databaseId}/rows/write

Creates, updates and deletes rows in one step. A row without id is created; with id it is updated (title renames it); delete: true moves it to the trash. values are keyed by property id, frontmatter key or name; relation values are row ids; select values are option names (new names become options); uniqueId values are numbers (pass 12 or "LYD-12"; new rows get the next number). unset clears properties.

docs:writeUndoableCannot be undone
Request
curl -X POST "https://api.lydie.co/v1/databases/01JCQ3V5MZ8G4ZK2X7T9R6N1PB/rows/write" \
  -H "Authorization: Bearer $LYDIE_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "rows": [
      {}
    ]
  }'

Path parameters

Body

  • rowsobject[]required· 1–1000 items
    Show 5 fields
    • idULID

      An existing row to update or delete.

    • titlestring· 1–255 chars
    • valuesobject

      Default {}

    • unsetstring[]

      Default []

    • deleteboolean

      Default false

Response

200
{
  "created": [
    "01JCQ3V5MZ8G4ZK2X7T9R6N1PB"
  ],
  "updated": [
    "01JCQ3V5MZ8G4ZK2X7T9R6N1PB"
  ],
  "deleted": [
    "01JCQ3V5MZ8G4ZK2X7T9R6N1PB"
  ]
}

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