如何批量导出 public social platform 粉丝与关注列表：从 API 到 Excel/CSV 完整教程

curl --request POST \
  --url https://api.twexapi.io/v3/twitter/users/followers \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "username": "elonmusk",
  "count": 20,
  "cursor": ""
}
'

curl --request POST \
  --url https://api.twexapi.io/twitter/followers/page \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '{
    "screen_name": "elonmusk"
  }'

{
  "code": 200,
  "msg": "success",
  "data": [],
  "has_next_page": true,
  "next_cursor": "1234567890"
}

1import os
2from typing import Any
3
4import requests
5
6TOKEN = os.environ["TWEXAPI_BEARER_TOKEN"]
7BASE_URL = "https://api.twexapi.io"
8
9def headers() -> dict[str, str]:
10    return {"Authorization": f"Bearer {TOKEN}", "Content-Type": "application/json"}
11
12def get_latest_followers(screen_name: str, count: int = 20) -> list[dict[str, Any]]:
13    response = requests.post(
14        f"{BASE_URL}/v3/twitter/users/followers",
15        headers=headers(),
16        json={"username": screen_name, "count": count, "cursor": ""},
17        timeout=30,
18    )
19    response.raise_for_status()
20    data = response.json()
21    return data.get("data", []) if isinstance(data.get("data"), list) else data.get("data", {}).get("users", [])
22
23def get_followers_page(
24    screen_name: str,
25    *,
26    next_cursor: str | None = None,
27) -> dict[str, Any]:
28    payload: dict[str, Any] = {"screen_name": screen_name}
29    if next_cursor:
30        payload["next_cursor"] = next_cursor
31
32    response = requests.post(
33        f"{BASE_URL}/twitter/followers/page",
34        headers=headers(),
35        json=payload,
36        timeout=30,
37    )
38    response.raise_for_status()
39    return response.json()
40
41def normalize_follower(user: dict[str, Any]) -> dict[str, Any]:
42    return {
43        "user_id": user.get("user_id") or user.get("userId") or user.get("id"),
44        "screen_name": user.get("screen_name") or user.get("username"),
45        "name": user.get("name"),
46        "description": user.get("description") or "",
47        "followers_count": user.get("followers_count") or user.get("followersCount") or 0,
48        "verified": bool(user.get("verified")),
49        "protected": bool(user.get("protected")),
50        "created_at": user.get("created_at_datetime") or user.get("createdAtDatetime") or user.get("createdAt"),
51    }
52
53def collect_followers(screen_name: str, max_pages: int = 2) -> list[dict[str, Any]]:
54    rows: list[dict[str, Any]] = []
55    seen_ids: set[str] = set()
56    cursor = None
57
58    for _ in range(max_pages):
59        page = get_followers_page(screen_name, next_cursor=cursor)
60        for user in page.get("data", []):
61            row = normalize_follower(user)
62            user_id = str(row.get("user_id") or "")
63            if user_id and user_id in seen_ids:
64                continue
65            if user_id:
66                seen_ids.add(user_id)
67            rows.append(row)
68
69        cursor = page.get("next_cursor")
70        if not page.get("has_next_page") or not cursor:
71            break
72
73    return rows
74
75if __name__ == "__main__":
76    followers = collect_followers("elonmusk", max_pages=2)
77    print(len(followers))