substack.archive

stable Advanced

What you get#

A list of Substack results in Onekey's unified shape, in data (an array). An empty array is a normal, successful answer and is charged like any other; a source that reports "nothing found" as an error returns a free 404 not_found instead.

What it costs#

Advanced · 5 credits for a fresh fetch, charged only when it succeeds.
Free when served from cache (0.2 credit for a cached response over 100 KB).
Free if the request is invalid (never charged) or the source fails or reports not found (refunded).

Parameters#

Name	Type	Required	Default	What it is	Constraints
`pub`	string	yes	(required)	Allowlisted Substack publication host, e.g. www.astralcodexten.com	max 253 chars; must match `[a-z0-9.-]{3,253}`; trimmed, lowercased

Request#

curl "https://api.onekey.dev/v1/substack/archive?pub=www.astralcodexten.com" \
  -H "x-api-key: YOUR_API_KEY"

Try it

Add your key to run this call right here. No key? Get one free. The key stays in this tab.

Recorded response#

A real Substack response, recorded and returned in Onekey's shape. Fields the platform does not provide are null.

json

{
  "success": true,
  "data": [
    {
      "content": {
        "id": "217850009",
        "title": "Open Thread 453",
        "text": "...",
        "url": "https://www.astralcodexten.com/p/open-thread-453",
        "createdAt": "2026-09-28T16:02:37Z"
      },
      "media": {
        "thumbnailUrl": "https://substack-post-media.s3.amazonaws.com/public/images/0ec8a952-4cdc-4f7b-95cd-26b48993feeb_1536x1024.png"
      },
      "engagement": {
        "likes": 37,
        "comments": 130
      },
      "author": {
        "id": "12009663",
        "displayName": "Scott Alexander",
        "username": "astralcodexten",
        "avatarUrl": "https://substackcdn.com/image/fetch/f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fbucketeer-e05bbc84-baa3-437e-9518-adb32be77984.s3.amazonaws.com%2Fpublic%2Fimages%2F7b500d22-1176-42ad-afaa-5d72bc36a809_44x44.png"
      },
      "ext": {
        "audience": "everyone",
        "wordCount": 299
      },
      "entity": {
        "slug": "open-thread-453"
      }
    },
    {
      "content": {
        "id": "210681369",
        "title": "Your Book Review: Lee Kuan Yew's Memoirs",
        "text": "Finalist #10 in the Book Review Contest",
        "url": "https://www.astralcodexten.com/p/your-book-review-lee-kuan-yews-memoirs",
        "createdAt": "2026-09-25T22:26:10Z"
      },
      "media": {
        "thumbnailUrl": "https://substack-post-media.s3.amazonaws.com/public/images/3d745943-c11a-4ff0-9c6a-aaf91333ac9f_2546x2560.jpeg"
      },
      "engagement": {
        "likes": 281,
        "comments": 155
      },
      "author": {
        "id": "12009663",
        "displayName": "Scott Alexander",
        "username": "astralcodexten",
        "avatarUrl": "https://substackcdn.com/image/fetch/f_auto,q_auto:good,fl_progressive:steep/https%3A%2F%2Fbucketeer-e05bbc84-baa3-437e-9518-adb32be77984.s3.amazonaws.com%2Fpublic%2Fimages%2F7b500d22-1176-42ad-afaa-5d72bc36a809_44x44.png"
      },
      "ext": {
        "audience": "everyone",
        "wordCount": 5683
      },
      "entity": {
        "slug": "your-book-review-lee-kuan-yews-memoirs"
      }
    }
  ],
  "metadata": {
    "platform": "substack",
    "endpoint": "archive",
    "cached": false,
    "stale": false,
    "age_s": 0,
    "fetched_at": "2026-01-01T12:00:00+00:00",
    "credits_charged": 5,
    "request_id": "7f3a9c2e5b1d4c8fa2e6d0b9c4f18e37"
  },
  "error": null
}

Field mapping#

How this endpoint's source fields become Onekey's unified schema. Fields the source lacks come back as null.

Source path	Onekey field	Transform
`id`	`content.id`	`toString`
`title`	`content.title`	-
`subtitle`	`content.text`	-
`canonical_url`	`content.url`	`safeUrl`
`post_date`	`content.createdAt`	`toIsoDate`
`cover_image`	`media.thumbnailUrl`	`safeUrl`
`reaction_count`	`engagement.likes`	`toNumber`
`comment_count`	`engagement.comments`	`toNumber`
`publishedBylines.0.id`	`author.id`	`toString`
`publishedBylines.0.name`	`author.displayName`	-
`publishedBylines.0.handle`	`author.username`	-
`publishedBylines.0.photo_url`	`author.avatarUrl`	`safeUrl`
`audience`	`ext.audience`	-
`slug`	`entity.slug`	-
`wordcount`	`ext.wordCount`	`toNumber`

Caching and freshness#

Fresh for about 2 minutes. Repeat calls in that window are served from cache and are free.
Between 2 minutes and 15 minutes the cached copy is still served instantly and marked stale: true while Onekey refreshes it in the background.
If the source is down when a refresh is needed, the last copy can be served for up to 1 hour more (marked stale).
A "not found" is remembered for 1 minute and is free.
The cache is shared across all customers, which is what keeps repeat calls cheap.

What can go wrong#

Status	Code	What to do
401	`unauthorized`	Check the `x-api-key` header.
402	`insufficient_credits`	Add credits; your balance must cover the price.
404	`not_found`	Unknown endpoint path.
422	`invalid_params`	Fix the parameters using the table above. Free.
429	`rate_limited`	Wait `Retry-After` seconds, then retry.
502	`upstream_error`	The source failed. Refunded; retry with backoff.

See Errors for the full list and retry guidance.

Status: stable (verified against the live source).