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.
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 user's sell orders on the Moxie bonding curve. To get user's vesting contract addresses, click here.
Pre-requisites
Install dependenciesgraphql
and graphql-request
to your project :- npm
- yarn
- pnpm
- bun
npm install graphql graphql-request
yarn add graphql graphql-request
pnpm add graphql graphql-request
bun install graphql 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
- Variable
- Response
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
}
}
}
}
{
"userAddresses": [
"0x3bd3e709e946b0882cd6393dde0fb200ce7119ce"
]
}
{
"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"
}
}
]
}
]
}
}
graphql-request
library:- TypeScript
- JavaScript
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);
}
const { gql, GraphQLClient } = require("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:
- TypeScript
- JavaScript
ts-node index.ts
node index.js
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.