Community Export API

Export community holder data for admin operations such as airdrops and snapshots

Community Export API

Admin-only endpoint that exports all claimed community holders with their tier, credit, and badge information. Designed for downstream operations such as airdrop snapshots and analytics.

Export community data

GET /api/community/export

Requires admin session authentication. Returns all claimed holders with their wallet addresses, tiers, credit amounts, and badge titles.

Query parameters

Parameter	Type	Required	Description
format	string	No	Response format: json (default) or csv

JSON response

{
  "exportedAt": "2026-04-10T12:00:00.000Z",
  "count": 42,
  "rows": [
    {
      "userId": "user_abc123",
      "walletAddress": "7xKXtg2CW87d97TXJSDpbD5jBkheTqA83TZRuJosgAsU",
      "tier": "builder",
      "credits": 100,
      "claimedAt": "2026-04-10T12:00:00.000Z",
      "badgeTitle": "Founding Community"
    }
  ]
}

JSON response fields

Field	Type	Description
exportedAt	string	ISO 8601 timestamp of when the export was generated
count	number	Total number of rows in the export
rows	array	List of claimed holder records
rows[].userId	string	User identifier
rows[].walletAddress	string	Solana wallet address that made the claim
rows[].tier	string	Tier at time of claim (whale, builder, or holder)
rows[].credits	number	Credits granted
rows[].claimedAt	string	ISO 8601 timestamp of the claim
rows[].badgeTitle	string | null	Founding badge title, or null if no badge

CSV response

When format=csv is passed, the response is returned as a downloadable CSV file with the following columns:

Column	Description
user_id	User identifier
wallet_address	Solana wallet address
tier	Claim tier
credits	Credits granted
claimed_at	ISO 8601 timestamp
badge_title	Founding badge title

The response includes Content-Disposition: attachment; filename="agentbot-community-export.csv" to trigger a file download.

Errors

Code	Description
403	Forbidden — admin session required