How This Demo Works

A webhook-driven architecture for real-time clinical trial monitoring

Architecture Overview

Watch the flow animate when you toggle between modes

Database Schema

clinical_trials (
  id SERIAL PRIMARY KEY,
  webset_item_id VARCHAR(255) UNIQUE,
  webset_id VARCHAR(255),
  trial_name TEXT,
  nct_id VARCHAR(50),
  sponsor_name TEXT,
  activation_date DATE,
  url TEXT,
  raw_data JSONB,
  created_at TIMESTAMP,
  updated_at TIMESTAMP
)

Important Webhook Events

webset.item.created

Fired when a new clinical trial is added to the webset

→ UPSERT to database

webset.item.enriched

Fired when enrichments are added to an item

→ UPSERT with enrichment data

webset.idle

Fired when the webset completes processing

→ Log completion