Skip to main content

Get All Cancelled Bids On Certain Auction

In this tutorial, you will learn how to get all canceled bids from a certain auction by calling the Moxie Auction 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 canceled bids from a certain auction, you can use the following query:

query MyQuery($auctionId: BigInt!) {
cancellationSellOrders(where: { auctionId: $auctionId }) {
  buyAmount
  sellAmount
  userId
  blockInfo {
    blockNumber
    hash
    timestamp
  }
}
}
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($auctionId: BigInt!) {
cancellationSellOrders(where: { auctionId: $auctionId }) {
  buyAmount
  sellAmount
  userId
  blockInfo {
    blockNumber
    hash
    timestamp
  }
}
}
`;

const variable = {
"auctionId": "37"
}


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": {
  "cancellationSellOrders": [
    {
      "buyAmount": "11000000000000000000",
      "sellAmount": "11000000000000000000",
      "userId": "9",
      "blockInfo": {
        "blockNumber": "12667487",
        "hash": "0x2b422395d0786933c689a17df179f2657a6844a53dc9e8b2e523993cff785921",
        "timestamp": "1721103262"
      }
    }
  ]
}
}

Congrats! 🥳🎉 You've just fetched all canceled bids from a certain auction!

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.