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.