Skip to main content
A query dedicated to returning user commands, otherwise known as transactions (excludes coinbase and fee transfers). This data is the same as that obtained via the block query but separated out into its own query for ease of use.

​
Get the last 25 transactions for a public key

Get all transactions to, or from, a public key. Only includes those on the canonical chain. 
{
  transactions(limit: 25, sortBy: DATETIME_DESC, query: {
    canonical: true,
    OR: [{
      to: "B62qpge4uMq4Vv5Rvc8Gw9qSquUYd6xoW1pz7HQkMSHm6h1o7pvLPAN"
    }, {
      from: "B62qpge4uMq4Vv5Rvc8Gw9qSquUYd6xoW1pz7HQkMSHm6h1o7pvLPAN"
    }]
  }) {
    fee
    from
    to
    nonce
    amount
    memo
    hash
    kind
    dateTime
    block {
      blockHeight
      stateHash
    }
    failureReason
  }
}

​
Return associated block data for a transaction

The block relationship may be used to extract information about the block the transaction was contained in. 
{
  transactions(
    limit: 1
    sortBy: DATETIME_DESC
    query: {from: "B62qqHM1bihHNvju89PFYugLw73PYRb7pGwp82CpEmWfSYVJiQAppaC"}
  ) {
     from
     to
     nonce
     amount  
  	 hash
     block {
      protocolState {
        consensusState {
          blockHeight
        }
      }
    }
    failureReason
  }
}

​
Get all transactions sent from a public key after a date

{
  transactions(
    limit: 10
    sortBy: NONCE_DESC
    query: {
      from: "B62qqHM1bihHNvju89PFYugLw73PYRb7pGwp82CpEmWfSYVJiQAppaC"
      dateTime_gte: "2021-01-26T00:00:00Z"
    }
  ) {
    from
    to
    nonce
    dateTime
    amount
    hash
    failureReason
  }
}

​
Find the largest fees sent in a period

This query demonstrates additional sorting options by sorting the transactions by largest fee. 
{
  transactions(
    limit: 10
    sortBy: FEE_DESC
    query: { AND: [{dateTime_gte: "2021-01-26T00:00:00Z"}, {dateTime_lte: "2021-01-27T00:00:00Z"}] }
  ) {
    from
    to
    fee
    nonce
    dateTime
    amount
    hash
    failureReason
  }
}

​
Determine the largest transfers made in a period

This query finds the largest transfers made over a period. 
{
  transactions(
    limit: 10
    sortBy: AMOUNT_DESC
    query: { AND: [{dateTime_gte: "2021-01-26T00:00:00Z"}, {dateTime_lte: "2021-01-27T00:00:00Z"}] }
  ) {
    from
    to
    fee
    nonce
    dateTime
    amount
    hash
    failureReason
  }
}

​
Find where the memo field is not empty

Memos are returned in base58 check encoding. The default memo is E4YM2vTHhWEg66xpj52JErHUBU4pZ1yageL4TVDDpTTSsv8mK6YaH so this query simply returns all results who memo is no that value so they can be decoded. 
{
  transactions(
    limit: 10
    sortBy: AMOUNT_DESC
    query: {
      AND: [
        { dateTime_gte: "2021-01-26T00:00:00Z" }
        { dateTime_lte: "2021-01-27T00:00:00Z" }
        { memo_ne: "E4YM2vTHhWEg66xpj52JErHUBU4pZ1yageL4TVDDpTTSsv8mK6YaH" }
      ]
    }
  ) {
    from
    to
    fee
    nonce
    dateTime
    amount
    hash
    memo
    failureReason
  }
}
Using the dateTime query filters you can greatly improve the performance of your queries by more specifically targeting your date range of returned results.