Query API

Query nodes with JSON filters and SQL.

JSON Query

POST /api/repository/{repo}/{branch}/head/{workspace}/query

Request:

{
  "filter": {
    "node_type": "Article",
    "properties.status": "published"
  },
  "limit": 20,
  "offset": 0
}

Execute SQL

POST /api/sql/{repo}

Request:

{
  "query": "SELECT * FROM nodes WHERE node_type = $1 LIMIT $2",
  "params": ["Article", 10]
}

Response:

{
  "columns": ["id", "path", "properties"],
  "rows": [...],
  "row_count": 10
}

Full-Text Search

POST /api/repository/{repo}/{branch}/fulltext/search

Request:

{
  "query": "raisindb database",
  "workspace": "content",
  "limit": 10
}