Skip to main content

Admin API

Overview​

Internal administrative endpoints for system management, content generation, and data quality. Restricted Access: Requires X-Admin-Token header.

📣 Marketing & Content​

Generate Social Content​

POST /api/admin/marketing/generate

Uses Gemini to generate tweets/posts based on platform data.

Parameters:

  • content_type: top_project, risk_alert, whale_watch, etc.
  • custom_prompt: Optional instructions.
  • include_image: Generate AI image (default: true).

Trigger Bot Post​

POST /api/admin/marketing/trigger

Triggers the TwitterContentBot to post directly to X (Twitter).

🧹 Data Quality​

Get Quality Metrics​

GET /api/admin/data-quality

Returns dashboard of data health:

  • Missing sentiment %
  • Duplicate reviews
  • Empty entries

Delete Review​

DELETE /api/admin/review/{review_id}

Hard deletes a review and its associated aspect data.

⚙️ System Management​

Initialize Database​

POST /api/admin/init-database

Runs the schema.sql script if tables do not exist.

Refresh Materialized Views​

POST /api/admin/refresh-views

Refreshes mv_company_stats and mv_source_stats. usage: Call after bulk imports.

Trigger ABSA Analysis​

POST /api/admin/run-absa

Manually triggers Aspect-Based Sentiment Analysis for a company (Background Task).