Access surfaces
Extralt's access surfaces are complementary. Availability in one surface does not imply availability in every other surface.
Coverage matrix
| Capability or data | Dashboard | Public API | Export | SQL query endpoint | Dashboard agent |
|---|---|---|---|---|---|
| Robots and Robot Builds | Manage and inspect | List, create/read/stop/delete Builds; list/rename/delete Robots | No | No | Read; cannot build a Robot |
| Runs | Create, inspect, restart, stop | List, create, read, restart, stop | No | No | Read; can propose a Run for approval |
| Schedules | Create, edit, pause, resume, delete | Full lifecycle | No | No | Read; can propose a Schedule for approval |
| Imports | Create and inspect | Create and read status | No dedicated export | No | Read-only |
| Captures | Browse, inspect, AI query | List, count, query | JSONL or Parquet by Run or Import | Yes | Query and answer with up to 100 rows |
| Enrichments | Create, inspect, stop | List, create, read, stop | No | No | Read; can propose an Enrichment for approval |
| Items | Browse, inspect, AI query | List and detail | No dedicated export | Yes | Query and answer with up to 100 rows |
| Changes | Browse and AI query | Explore change view | No dedicated export | Yes | Query and answer with up to 100 rows |
| Products, Variants, Listings, Offers, Reviews, Stores | Extend relationship graph and change view; Explore views | Purpose-built Explore endpoints | No dedicated bulk export | No | No generic final-table query tool |
| Explore overview and facets | Yes | Yes | No | No | Can explain available views; no dedicated Explore analysis tool |
| Current markets and Variant history | Yes | Yes | No | No | No dedicated Explore analysis tool |
Public API
The generated OpenAPI reference is the authority for routes, request fields, filters, and response payloads. There is no general public Extend mutation endpoint: Extend runs downstream, and supported results are read through Explore.
Constrained SQL queries
POST /v0/extract/captures/query accepts a single read-only SELECT or WITH
query over exactly one of these customer tables:
extralt.capturesextralt.itemsextralt.changes
The endpoint rejects joins, mutations, multiple statements, unions,
query-level SETTINGS, and offset pagination. It wraps every query with a
101-row limit, returns at most 100 rows, marks truncated results, and enforces a
30-second timeout. The authenticated organization is applied by the service.
This is a safe analytical query surface, not unrestricted ClickHouse access. Queries against Products, Variants, Listings, Offers, Reviews, Stores, or internal tables are rejected by this endpoint.
Dashboard agent
The dashboard agent can:
- read recent or selected Robots, Runs, Enrichments, Schedules, and Imports;
- query Captures, Items, or Changes and return a persisted result page;
- prepare an Extract Run, Extract Schedule, or Enrichment plan for approval.
The agent cannot build or ensure a Robot, create an Import, query the final Extend tables through its generic query tool, or execute a state-changing plan without explicit dashboard approval.