Endpoint Playground
Test Crawlora's Substack Leaderboard API with realistic prefilled parameters. Generate a cURL request, inspect the expected structured JSON response, and open the full docs or pricing page when you are ready to integrate this public web data extraction endpoint into your application.
curl "https://api.crawlora.net/api/v1/substack/leaderboard?category_id=<category_id>&type=trending" \
-H "x-api-key: $CRAWLORA_API_KEY"| Parameter | Type | Required | Prefilled value | Description |
|---|---|---|---|---|
| category_id | string | Yes | Category id from /substack/categories with in_leaderboard true. Numeric, or the string ids podcast or bestseller. | |
| type | string | No | trending | Ranking to read |
| page | integer | No | Zero-based page, 0-25 |
{
"code": 200,
"data": {
"category_id": "96",
"type": "trending",
"page": 0,
"has_more": true,
"title": "Culture Bestsellers",
"entries": [
{
"rank": 1,
"publication": {
"id": 1521363,
"name": "Selvaggia Lucarelli",
"subdomain": "selvaggialucarelli",
"url": "https://selvaggialucarelli.substack.com",
"subscribers": {
"total": 231000,
"total_hidden": false,
"paid_rough": "Tens of thousands of paid subscribers"
}
},
"author": {
"id": 7851723,
"handle": "selvaggialucarelli",
"name": "Selvaggia Lucarelli",
"url": "https://substack.com/@selvaggialucarelli"
}
}
]
},
"msg": "success"
}Public Playground
Sample responses, schemas, request previews, and code snippets are visible before sign in. Create an account when you are ready to save an API key and run authenticated requests.
Returns one page of a category's bestseller leaderboard, pairing each ranked publication with its author. This is a different surface from /substack/category: it exposes the trending ranking (the site's "Rising" tab), validates its ranking values rather than silently defaulting, accepts the extra cross-category id `bestseller`, and returns the author alongside the publication. Use a category_id from /substack/categories whose in_leaderboard is true. Upstream serves 25 rows per page and accepts pages 0-25.
{
"code": 200,
"data": {
"category_id": "96",
"type": "trending",
"page": 0,
"has_more": true,
"title": "Culture Bestsellers",
"entries": [
{
"rank": 1,
"publication": {
"id": 1521363,
"name": "Selvaggia Lucarelli",
"subdomain": "selvaggialucarelli",
"url": "https://selvaggialucarelli.substack.com",
"subscribers": {
"total": 231000,
"total_hidden": false,
"paid_rough": "Tens of thousands of paid subscribers"
}
},
"author": {
"id": 7851723,
"handle": "selvaggialucarelli",
"name": "Selvaggia Lucarelli",
"url": "https://substack.com/@selvaggialucarelli"
}
}
]
},
"msg": "success"
}curl "https://api.crawlora.net/api/v1/substack/leaderboard?category_id=<category_id>" \
-H "x-api-key: $CRAWLORA_API_KEY"