Skip to main content

Get User's Sell Orders

In this tutorial, you will learn how to get the user's sell orders by calling the Moxie Protocol 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 user's sell orders in Moxie bonding curve. 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 the user's sell orders, you can use the following query:

query MyQuery($userAddresses: ID) {
users(where: {id_in: $userAddresses}) {
  orders(where: {orderType: SELL}) {
    price
    protocolToken
    protocolTokenAmount
    protocolFeeTransfer {
      txHash
      amount
    }
    subjectToken {
      name
      symbol
    }
    subjectAmount
    subjectFeeTransfer {
      txHash
      amount
    }
  }
}
}
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($userAddresses: ID) {
users(where: {id_in: $userAddresses}) {
  orders(where: {orderType: SELL}) {
    price
    protocolToken
    protocolTokenAmount
    protocolFeeTransfer {
      txHash
      amount
    }
    subjectToken {
      name
      symbol
    }
    subjectAmount
    subjectFeeTransfer {
      txHash
      amount
    }
  }
}
}
`;

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


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": [
    {
      "orders": [
        {
          "price": "0.006968543664227871909162462934855122",
          "protocolToken": "0xf86136afb0fb72cdbd27d7aea9e283725d6815a1",
          "protocolTokenAmount": "143502006758366481515",
          "protocolFeeTransfer": {
            "txHash": "0xad4766fdfcce942ab44b9f6bd8a7bfe9ba6e4d5e27a50f4113e3cce024f75c02",
            "amount": "20000000000000000"
          },
          "subjectToken": {
            "name": "aalitkn",
            "symbol": "fid:340066"
          },
          "subjectAmount": "1000000000000000000",
          "subjectFeeTransfer": {
            "txHash": "0xad4766fdfcce942ab44b9f6bd8a7bfe9ba6e4d5e27a50f4113e3cce024f75c02",
            "amount": "40000000000000000"
          }
        }
      ]
    }
  ]
}
}

Congrats! 🥳🎉 You've just fetched all the user's sell orders!

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.