REST API / Collections

`actions`

Collection

Read-only action board records with evidence links and the assignee display name. For recommended next actions and to-dos awaiting review use action_suggestions.

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.	✓	–
`type`	`string`	Action type. `CONTENT` `SEARCH` `AI_VISIBILITY` `SOURCE` `REPUTATION` `COMPETITOR` `COMMUNITY_REPLY` `TECHNICAL` `REVIEW_SUGGESTION`	✓	✓
`title`	`string`	Title.	✓	✓
`recommendation` nullable	`string`	Recommended next step.	✓	✓
`why_it_matters` nullable	`string`	Expected benefit.	✓	✓
`source_kind`	`string`	Evidence source kind. `SIGNAL` `MENTION` `CITATION` `COMPETITOR_SUGGESTION` `ALERT` `ANSWER` `SEARCH` `FANOUT_QUERY` `PERCEPTION_THEME` `PERCEPTION_PLACE` `PERCEPTION_THREAD` `PERCEPTION_ITEM` `PAGE` `DOMAIN` `MANUAL`	✓	✓
`source_id` nullable	`string`	Evidence record ID.	✓	✓
`evidence_url` nullable	`string`	Evidence URL.	✓	✓
`channel` nullable	`string`	Channel.	✓	✓
`impact` nullable	`string`	Estimated impact. `LOW` `MEDIUM` `HIGH`	✓	✓
`effort` nullable	`string`	Estimated effort. `LOW` `MEDIUM` `HIGH`	✓	✓
`confidence` nullable	`string`	Confidence. `LOW` `MEDIUM` `HIGH`	✓	✓
`urgency` nullable	`string`	Urgency. `IMMEDIATE` `THIS_WEEK` `THIS_MONTH` `EVERGREEN`	✓	✓
`priority`	`integer`	Priority score.	✓	✓
`board_rank` nullable	`number`	Stored board position.	✓	✓
`status`	`string`	Action state. `TODO` `IN_PROGRESS` `DONE` `DISMISSED` `ARCHIVED`	✓	✓
`owner_name` nullable	`string`	Assignee display name.	–	–
`due_date` nullable	`datetime`	Due date.	✓	✓
`notes` nullable	`string`	Notes.	✓	✓
`created_at`	`datetime`	Creation time.	✓	✓
`completed_at` nullable	`datetime`	Completion time.	✓	✓

Examples

Example

SELECT id, project_id, type, title, recommendation
FROM actions
ORDER BY id ASC
LIMIT 25

Calling it

MCP

Tool call

query({"sql":"SELECT id, project_id, type, title, recommendation FROM actions 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, type, title, recommendation FROM actions ORDER BY id ASC LIMIT 25"
}
JSON

Row JSON Schema

json

{
  "type": "object",
  "description": "Read-only action board records with evidence links and the assignee display name. For recommended next actions and to-dos awaiting review use action_suggestions.",
  "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
    },
    "type": {
      "type": "string",
      "description": "Action type.",
      "enum": [
        "CONTENT",
        "SEARCH",
        "AI_VISIBILITY",
        "SOURCE",
        "REPUTATION",
        "COMPETITOR",
        "COMMUNITY_REPLY",
        "TECHNICAL",
        "REVIEW_SUGGESTION"
      ],
      "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": true
    },
    "title": {
      "type": "string",
      "description": "Title.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "recommendation": {
      "type": [
        "string",
        "null"
      ],
      "description": "Recommended next step.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "why_it_matters": {
      "type": [
        "string",
        "null"
      ],
      "description": "Expected benefit.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "source_kind": {
      "type": "string",
      "description": "Evidence source kind.",
      "enum": [
        "SIGNAL",
        "MENTION",
        "CITATION",
        "COMPETITOR_SUGGESTION",
        "ALERT",
        "ANSWER",
        "SEARCH",
        "FANOUT_QUERY",
        "PERCEPTION_THEME",
        "PERCEPTION_PLACE",
        "PERCEPTION_THREAD",
        "PERCEPTION_ITEM",
        "PAGE",
        "DOMAIN",
        "MANUAL"
      ],
      "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": true
    },
    "source_id": {
      "type": [
        "string",
        "null"
      ],
      "description": "Evidence record ID.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "evidence_url": {
      "type": [
        "string",
        "null"
      ],
      "description": "Evidence URL.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "channel": {
      "type": [
        "string",
        "null"
      ],
      "description": "Channel.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "impact": {
      "type": [
        "string",
        "null"
      ],
      "description": "Estimated impact.",
      "enum": [
        "LOW",
        "MEDIUM",
        "HIGH",
        null
      ],
      "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": true
    },
    "effort": {
      "type": [
        "string",
        "null"
      ],
      "description": "Estimated effort.",
      "enum": [
        "LOW",
        "MEDIUM",
        "HIGH",
        null
      ],
      "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": true
    },
    "confidence": {
      "type": [
        "string",
        "null"
      ],
      "description": "Confidence.",
      "enum": [
        "LOW",
        "MEDIUM",
        "HIGH",
        null
      ],
      "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": true
    },
    "urgency": {
      "type": [
        "string",
        "null"
      ],
      "description": "Urgency.",
      "enum": [
        "IMMEDIATE",
        "THIS_WEEK",
        "THIS_MONTH",
        "EVERGREEN",
        null
      ],
      "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": true
    },
    "priority": {
      "type": "integer",
      "description": "Priority score.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "board_rank": {
      "type": [
        "number",
        "null"
      ],
      "description": "Stored board position.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "status": {
      "type": "string",
      "description": "Action state.",
      "enum": [
        "TODO",
        "IN_PROGRESS",
        "DONE",
        "DISMISSED",
        "ARCHIVED"
      ],
      "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": true
    },
    "owner_name": {
      "type": [
        "string",
        "null"
      ],
      "description": "Assignee display name.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": false,
      "x-sensorhub-filterable": false,
      "x-sensorhub-sortable": false
    },
    "due_date": {
      "type": [
        "string",
        "null"
      ],
      "description": "Due date.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "notes": {
      "type": [
        "string",
        "null"
      ],
      "description": "Notes.",
      "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": "Creation time.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "completed_at": {
      "type": [
        "string",
        "null"
      ],
      "description": "Completion 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
}