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.