Get Holders Of Certain Fan Token
In this tutorial, you will learn how to get all the holders of a certain fan token, either locked in staking contracts or not, by calling the Moxie Protocol Subgraph API.
Pre-requisites
Install dependenciesgraphql
and graphql-request
to your project :- npm
- yarn
- pnpm
- bun
npm install graphql graphql-request
yarn add graphql graphql-request
pnpm add graphql graphql-request
bun install graphql graphql graphql-request
Step 1: Add The API Query To Your Code
To get all the holders of a certain fan token, you can use the following query:
- Query
- Variable
- Response
query MyQuery($fanTokenSymbol: String) {
subjectTokens(where: {symbol: $fanTokenSymbol}) {
portfolio(
where: {
balance_gt: 0,
# Exclude the staking contract
user_not_in: ["0xcb2513d389354f7ac80f5042bb8948a234a439b2"]
}
) {
stakedBalance
unstakedBalance
user {
id
}
}
}
}
{
"fanTokenSymbol": "fid:3"
}
{
"data": {
"subjectTokens": [
{
"portfolio": [
{
"stakedBalance": "0",
"unstakedBalance": "1214949183764430400",
"user": {
"id": "0x00000000009726632680fb29d3f7a9734e3010e2"
}
},
// Other holders of FID 3
]
}
]
}
}
graphql-request
library:- TypeScript
- JavaScript
index.ts
import { gql, GraphQLClient } from "graphql-request";
const graphQLClient = new GraphQLClient(
"https://api.studio.thegraph.com/query/23537/moxie_protocol_stats_mainnet/version/latest"
);
const query = gql`
query MyQuery($fanTokenSymbol: String) {
subjectTokens(where: {symbol: $fanTokenSymbol}) {
portfolio(
where: {
balance_gt: 0,
# Exclude the staking contract
user_not_in: ["0xcb2513d389354f7ac80f5042bb8948a234a439b2"]
}
) {
stakedBalance
unstakedBalance
user {
id
}
}
}
}
`;
const variable = {
"fanTokenSymbol": "fid:3"
}
try {
const data = await graphQLClient.request(query, variable);
console.log(data);
} catch (e) {
throw new Error(e);
}
index.js
const { gql, GraphQLClient } = require("graphql-request");
const graphQLClient = new GraphQLClient(
"https://api.studio.thegraph.com/query/23537/moxie_protocol_stats_mainnet/version/latest"
);
const query = gql`
query MyQuery($fanTokenSymbol: String) {
subjectTokens(where: {symbol: $fanTokenSymbol}) {
portfolio(
where: {
balance_gt: 0,
# Exclude the staking contract
user_not_in: ["0xcb2513d389354f7ac80f5042bb8948a234a439b2"]
}
) {
stakedBalance
unstakedBalance
user {
id
}
}
}
}
`;
const variable = {
"fanTokenSymbol": "fid:3"
}
try {
const data = await graphQLClient.request(query, variable);
console.log(data);
} catch (e) {
throw new Error(e);
}
Step 2: Execute Your Code
Once you have your code ready, you can execute it by running the following command:
- TypeScript
- JavaScript
ts-node index.ts
node index.js
If it runs successfully, you should see the data returned in the terminal:
{
"data": {
"subjectTokens": [
{
"portfolio": [
{
"stakedBalance": "0",
"unstakedBalance": "1214949183764430400",
"user": {
"id": "0x00000000009726632680fb29d3f7a9734e3010e2"
}
},
// Other holders of FID 3
]
}
]
}
}
Congrats! 🥳🎉 You've just fetched all the holders of a certain fan token!
Developer Support
If you have any questions or need help with other use cases, feel free to join the /airstack Warpcast channel and ask your questions there.
Our team is always ready to help you with any questions you may have.