Skip to main content

Get All Auctions Participated By Certain User

In this tutorial, you will learn how to get all auctions participated by a certain user by calling the Moxie Auction Subgraph API.

Include User's Vesting Addresses

Moxie protocol users have Moxie token currently vesting in their vesting contract. A huge portion of them use these to bid on auctions and buy/sell fan tokens on the Moxie protocol.

Therefore, it is important that you include the user's vesting addresses in the query to get all auctions participated by a certain user. To get user's vesting contract addresses, click here.

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 auctions participated by a certain user, you can use the following query:

query MyQuery($userAddresses: [Bytes!]) {
users(where: { addresses_in: $userAddress }) {
participatedAuctions {
auctionId
auctioningToken {
id
symbol
decimals
}
txHash
}
address
}
}
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_auction_stats_mainnet/version/latest"
);

const query = gql`
query MyQuery($userAddresses: [Bytes!]) {
users(where: { addresses_in: $userAddress }) {
participatedAuctions {
auctionId
auctioningToken {
id
symbol
decimals
}
txHash
}
address
}
}
`;

const variable = {
"userAddresses": [
"0x1a45675bd474c8e3056a7dbd19e738d7849c0d26"
]
}


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": {
"users": [
{
"participatedAuctions": [
{
"auctionId": "37",
"auctioningToken": {
"id": "0xf08c342445e8ca84476941078a109a496244187f",
"symbol": "cid:goldy",
"decimals": "18"
},
"txHash": "0x2a96c4e8032e8eb270f17f8e4487630b171be3c20a75e8547196378f54ffab5f"
}
],
"address": "0x1a45675bd474c8e3056a7dbd19e738d7849c0d26"
}
]
}
}

Congrats! 🥳🎉 You've just fetched all auctions participated by a certain user!

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.