Skip to main content

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 dependencies graphql and graphql-request to your project :
npm install 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 MyQuery($fanTokenSymbol: String) {
subjectTokens(where: {symbol: $fanTokenSymbol}) {
portfolio(
where: {
balance_gt: 0,
# Exclude the staking contract
user_not_in: ["0xcb2513d389354f7ac80f5042bb8948a234a439b2"]
}
) {
stakedBalance
unstakedBalance
user {
id
}
}
}
}
With this GraphQL query, you can add it to your source code and call the API with the graphql-request library:
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);
}

Step 2: Execute Your Code

Once you have your code ready, you can execute it by running the following command:

ts-node index.ts

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.