Skip to main content

Example Indexer API Queries

Beta

The Indexer API, Transaction Stream Service, and Custom Processors are currently in beta. Please report any problems you encounter by creating an issue in the aptos-indexer-processors repo.

Running example queries

  1. Open the Hasura Explorer for the network you want to query. You can find the URLs here.
  2. Paste the Query code from an example into the main query section, and the Query Variables code from the same example into the Query Variables section (below the main query section).

More Examples

You can find many more example queries in the TypeScript SDK. Indeed, if you're using the TypeScript SDK, you should look at the API.

Example Token Queries

Getting all tokens currently in account.

Query

query CurrentTokens($owner_address: String, $offset: Int) {
current_token_ownerships(
where: {
owner_address: { _eq: $owner_address }
amount: { _gt: "0" }
table_type: { _eq: "0x3::token::TokenStore" }
}
order_by: [{ last_transaction_version: desc }, { token_data_id: desc }]
offset: $offset
) {
token_data_id_hash
name
collection_name
property_version
amount
}
}

Query Variables

{
"owner_address": "0xaa921481e07b82a26dbd5d3bc472b9ad82d3e5bfd248bacac160eac51687c2ff",
"offset": 0
}

Getting all token activities for a particular token. Note that to get the token_id_hash you have to first make a query to get the token from the above query.

Query

query TokenActivities($token_id_hash: String, $offset: Int) {
token_activities(
where: { token_data_id_hash: { _eq: $token_id_hash } }
# Needed for pagination
order_by: [{ last_transaction_version: desc }, { event_index: asc }]
# Optional for pagination
offset: $offset
) {
transaction_version
from_address
property_version
to_address
token_amount
transfer_type
}
}

Query Variables

{
"token_id_hash": "f344b838264bf9aa57d5d4c1e0c8e6bbdc93f000abe3e7f050c2a0f4dc23d030",
"offset": 0
}

Getting current token offered to account.

Query

query CurrentOffers($to_address: String, $offset: Int) {
current_token_pending_claims(
where: { to_address: { _eq: $to_address }, amount: { _gt: "0" } }
# Needed for pagination
order_by: [{ last_transaction_version: desc }, { token_data_id: desc }]
# Optional for pagination
offset: $offset
) {
token_data_id_hash
name
collection_name
property_version
from_address
amount
}
}

** Query Variables**

{
"to_address": "0xe7be097a90c18f6bdd53efe0e74bf34393cac2f0ae941523ea196a47b6859edb",
"offset": 0
}

Example Coin Queries

Getting coin activities (including gas fees).

Query

query CoinActivity($owner_address: String, $offset: Int) {
coin_activities(
where: { owner_address: { _eq: $owner_address } }
# Needed for pagination
order_by: [{ last_transaction_version: desc }, { event_index: asc }]
# Optional for pagination
offset: $offset
) {
activity_type
amount
coin_type
entry_function_id_str
transaction_version
}
}

Query Variables

{
"owner_address": "0xe7be097a90c18f6bdd53efe0e74bf34393cac2f0ae941523ea196a47b6859edb",
"offset": 0
}

Currently owned coins (0x1::coin::CoinStore).

Query

query CurrentBalances($owner_address: String, $offset: Int)Ï {
current_coin_balances(
where: {owner_address: {_eq: $owner_address}}
# Needed for pagination
order_by: [{last_transaction_version: desc}, {token_data_id: desc}]
# Optional for pagination
offset: $offset
) {
owner_address
coin_type
amount
last_transaction_timestamp
}
}

Query Variables

{
"owner_address": "0xe7be097a90c18f6bdd53efe0e74bf34393cac2f0ae941523ea196a47b6859edb",
"offset": 0
}

Example Explorer Queries

Getting all user transaction versions (to filter on user transaction for block explorer).

Query

query UserTransactions($limit: Int) {
user_transactions(limit: $limit, order_by: { version: desc }) {
version
}
}

Query Variables

{
"limit": 10
}