REST API / Collections

`brand_facts`

CollectionRequires Perception

Versioned project brand facts. Removed and historical versions remain visible with validity and removal timestamps.

Max rows per query: 100
Default order: id asc
Cursor paging: by id

Use read report_* for dashboard headline metrics and anchored comparison windows.

Fields

Field	Type	Description	Filter	Sort
`id` indexed	`string`	Unique row ID.	✓	✓
`project_id` indexed	`string`	Project ID from projects.	✓	–
`family_id` nullable	`string`	Fact family ID.	✓	✓
`text`	`string`	Fact text.	✓	✓
`origin`	`string`	Fact origin. `OWNER` `SITE` `PAGE`	✓	–
`status`	`string`	Fact review status. `DRAFT` `CONFIRMED` `REJECTED`	✓	–
`source_url` nullable	`string`	Supporting source URL.	✓	✓
`site_page_id` nullable	`string`	Supporting site page ID.	✓	✓
`quote` nullable	`string`	Supporting site-page quote.	✓	✓
`severity`	`string`	Claim impact severity. `HIGH` `MEDIUM` `LOW`	✓	–
`version`	`integer`	Fact version.	✓	✓
`valid_from`	`datetime`	Version start time.	✓	✓
`valid_to` nullable	`datetime`	Version end time.	✓	✓
`confirmed_at` nullable	`datetime`	Confirmation time.	✓	✓
`removed_at` nullable	`datetime`	Removal time.	✓	✓
`created_at`	`datetime`	Created time.	✓	✓
`updated_at`	`datetime`	Updated time.	✓	✓

Examples

Example

SELECT id, project_id, family_id, text, origin
FROM brand_facts
ORDER BY id ASC
LIMIT 25

Calling it

MCP

Tool call

query({"sql":"SELECT id, project_id, family_id, text, origin FROM brand_facts ORDER BY id ASC LIMIT 25"})

REST

curl

curl -X POST "https://app.sensorhub.ai/api/v1/query" \
  -H "Authorization: Bearer $API_KEY" \
  -H "Content-Type: application/json" \
  --data-binary @- <<'JSON'
{
  "sql": "SELECT id, project_id, family_id, text, origin FROM brand_facts ORDER BY id ASC LIMIT 25"
}
JSON

Row JSON Schema

json

{
  "type": "object",
  "description": "Versioned project brand facts. Removed and historical versions remain visible with validity and removal timestamps.",
  "properties": {
    "id": {
      "type": "string",
      "description": "Unique row ID.",
      "x-sensorhub-indexed": true,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "project_id": {
      "type": "string",
      "description": "Project ID from projects.",
      "x-sensorhub-indexed": true,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": false
    },
    "family_id": {
      "type": [
        "string",
        "null"
      ],
      "description": "Fact family ID.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "text": {
      "type": "string",
      "description": "Fact text.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "origin": {
      "type": "string",
      "description": "Fact origin.",
      "enum": [
        "OWNER",
        "SITE",
        "PAGE"
      ],
      "x-sensorhub-filter-operators": [
        "=",
        "!=",
        "<>",
        "IN",
        "NOT IN",
        "IS NULL",
        "IS NOT NULL"
      ],
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": false
    },
    "status": {
      "type": "string",
      "description": "Fact review status.",
      "enum": [
        "DRAFT",
        "CONFIRMED",
        "REJECTED"
      ],
      "x-sensorhub-filter-operators": [
        "=",
        "!=",
        "<>",
        "IN",
        "NOT IN",
        "IS NULL",
        "IS NOT NULL"
      ],
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": false
    },
    "source_url": {
      "type": [
        "string",
        "null"
      ],
      "description": "Supporting source URL.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "site_page_id": {
      "type": [
        "string",
        "null"
      ],
      "description": "Supporting site page ID.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "quote": {
      "type": [
        "string",
        "null"
      ],
      "description": "Supporting site-page quote.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "severity": {
      "type": "string",
      "description": "Claim impact severity.",
      "enum": [
        "HIGH",
        "MEDIUM",
        "LOW"
      ],
      "x-sensorhub-filter-operators": [
        "=",
        "!=",
        "<>",
        "IN",
        "NOT IN",
        "IS NULL",
        "IS NOT NULL"
      ],
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": false
    },
    "version": {
      "type": "integer",
      "description": "Fact version.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "valid_from": {
      "type": "string",
      "description": "Version start time.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "valid_to": {
      "type": [
        "string",
        "null"
      ],
      "description": "Version end time.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "confirmed_at": {
      "type": [
        "string",
        "null"
      ],
      "description": "Confirmation time.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "removed_at": {
      "type": [
        "string",
        "null"
      ],
      "description": "Removal time.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "created_at": {
      "type": "string",
      "description": "Created time.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "updated_at": {
      "type": "string",
      "description": "Updated time.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    }
  },
  "additionalProperties": false
}