# Substack · Archive

Get news and media data with Substack · Archive from Alexandria through one Spiral API key. One page of a Substack publication's archive, newest or top first, or only its pinned posts. Each entry carries title, subtitle, URL, publish time, audience (free or paid), word count, engagement counts, section, tags and bylines. Page with cursor (or offset) and limit. It runs in the background and returns structured JSON. Pay as you go, with no subscription.

- Provider: Alexandria
- Category: News & Media
- Runs: In the background
- Returns: json
- Tool id: `alexandria` / `substack-com/newsletters/archive`
- Page: https://spiral.ai/tools/alexandria/substack-com/newsletters/archive

## Pricing

$0.00873 per call.

## Limits

- Longest queue wait: 1 hour
- Run deadline: 5 minutes
- Longest run, end to end: 225 minutes
- Largest inline input: 1 MB
- Largest input file: 2 GB
- Largest output: 5 GB

## Input

| Field | Kind | Allowed | Default | Description |
| --- | --- | --- | --- | --- |
| `publication` (required) | text |  | — | Substack slug or a declared custom publication host (www.astralcodexten.com, www.lennysnewsletter.com, www.noahpinion.blog). Other custom domains are not supported by this program. |
| `sort` | one of | new, top, pinned | new | new = newest first, top = most popular, pinned = the publication's pinned posts only (usually one, a single page). |
| `limit` | number | 1 to 50 | 12 | Posts to return. Substack serves 25 per request, so larger pages take two requests. |
| `cursor` | text |  | — | next_cursor from the previous page of the same publication, sort and query. Takes precedence over offset. |
| `offset` | number | 0 to 10000 | 0 | Posts to skip. new listings reach at most 250 by offset; follow next_cursor for deeper pages. Ignored when cursor is set. |

## Example

```bash
curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "substack-com/newsletters/archive",
    "input": {
      "publication": "<publication>"
    }
  }'
```

Try it in the Playground: https://spiral.ai/start?provider=alexandria&model=substack-com%2Fnewsletters%2Farchive

## Common questions

### Substack · Archive

**How much does Substack · Archive cost?**

$0.00873 per call. You pay as you go from one Spiral balance, with no subscription, and a failed run is not charged.

**How do I use Substack · Archive through an API?**

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "substack-com/newsletters/archive"` and the input fields on this page, using one Spiral API key. It runs in the background: poll the run, or name a webhook to be told when it finishes.

**Do I need an account with Alexandria to use Substack · Archive?**

No. Spiral runs it on its own Alexandria account and charges your Spiral balance.

**Can my AI agent use Substack · Archive?**

Yes. Agents find and run it through Spiral's MCP server, CLI or agent skill, with the same API key.

