Integration transaction history for wallet
There are 2 way to query history tx: onchain (by LCD/RPC) or offchain (by Horoscope). It is recommend to use Horoscope to query all tx which involved by address (tx sended, received, smart contract, etc).
1. Using Horoscope (recommended)
You can choose indexer server to integrate with the wallet here
Input:
- Selected chain: xstaxy/euphoria/serenity
- value: aura_xxx (address need to query)
- fromHeight
- toHeight
- limit, offset
- euphoria
- xstaxy
- serenity
curl -L -X POST 'https://indexer-v2.staging.aurascan.io/api/v2/graphql' \
-H 'Content-Type: application/json' \
--data-raw '{
"operationName": "queryTransaction",
"query": "query queryTransaction( $limit: Int = 100 $order: order_by = desc $value: String = null $hash: String = null $height: Int = null $offset: Int = 0 $fromHeight: Int = null $toHeight: Int = null ) { euphoria { transaction( limit: $limit offset: $offset where: { hash: { _eq: $hash } height: { _eq: $height } event_attribute_index: { value: { _eq: $value} block_height: {_lt: $toHeight _gt: $fromHeight} } } order_by: [{ height: $order}, {index: $order}] ) { id height hash timestamp code gas_used gas_wanted data } } }",
"variables": {
"limit": 5,
"offset": 0,
"order": "desc",
"value": "aura1pxl99s8h4g5mg564zrp4qz9k8h64l24ffa6vc6",
"height": null,
"fromHeight": 4990000,
"toHeight": 5000000
}
}'
curl -L -X POST 'https://horoscope.aura.network/api/v2/graphql' \
-H 'Content-Type: application/json' \
--data-raw '{
"operationName": "queryTransaction",
"query": "query queryTransaction( $limit: Int = 100 $order: order_by = desc $value: String = null $hash: String = null $height: Int = null $offset: Int = 0 $fromHeight: Int = null $toHeight: Int = null ) { xstaxy { transaction( limit: $limit offset: $offset where: { hash: { _eq: $hash } height: { _eq: $height } event_attribute_index: { value: { _eq: $value} block_height: {_lt: $toHeight _gt: $fromHeight} } } order_by: [{ height: $order}, {index: $order}] ) { id height hash timestamp code gas_used gas_wanted data } } }",
"variables": {
"limit": 5,
"offset": 0,
"order": "desc",
"value": "aura194ytn50yhh67rdha8akhs7c6zulnz4n2jp7pw6",
"height": null,
"fromHeight": 1900000,
"toHeight": 2000000
}
}'
curl -L -X POST 'https://indexer-v2.dev.aurascan.io/api/v2/graphql' \
-H 'Content-Type: application/json' \
--data-raw '{
"operationName": "queryTransaction",
"query": "query queryTransaction( $limit: Int = 100 $order: order_by = desc $value: String = null $hash: String = null $height: Int = null $offset: Int = 0 $fromHeight: Int = null $toHeight: Int = null ) { serenity { transaction( limit: $limit offset: $offset where: { hash: { _eq: $hash } height: { _eq: $height } event_attribute_index: { value: { _eq: $value} block_height: {_lt: $toHeight _gt: $fromHeight} } } order_by: [{ height: $order}, {index: $order}] ) { id height hash timestamp code gas_used gas_wanted data } } }",
"variables": {
"limit": 5,
"offset": 0,
"order": "desc",
"value": "aura1jlp9ge244um2v7mdm7xwamwsv9z9vhpej6wjh7",
"height": null,
"fromHeight": 14794439,
"toHeight": 14894439
}
}'
Output:
{
"code": 200,
"message": "Successful",
"data": {
"euphoria": {
"transaction": [
{
"id": 2817050,
"height": 4999978,
"hash": "BE3818C381B7FAEDCF896DE1A1104EC7D0F5ACB7B82FD911A863E51F96E3827F",
"timestamp": "2023-06-07T17:54:59.252+00:00",
"code": 0,
"gas_used": 150210,
"gas_wanted": 196385,
"data": {
"tx": {
"body": {
"memo": "",
"messages": [
{
"@type": "/cosmos.staking.v1beta1.MsgDelegate",
"amount": {
"denom": "ueaura",
"amount": "30300524"
},
"delegator_address": "aura1pxl99s8h4g5mg564zrp4qz9k8h64l24ffa6vc6",
"validator_address": "auravaloper1pxl99s8h4g5mg564zrp4qz9k8h64l24fj0tyqy"
}
],
"timeout_height": {
"low": 0,
"high": 0,
"unsigned": true
},
"extension_options": [],
"non_critical_extension_options": []
},
"auth_info": {
"fee": {
"payer": "",
"amount": [
{
"denom": "ueaura",
"amount": "197"
}
],
"granter": "",
"gas_limit": {
"low": 196385,
"high": 0,
"unsigned": true
}
},
"signer_infos": [
{
"sequence": "185336",
"mode_info": {
"single": {
"mode": 1
}
},
"public_key": {
"key": "AnHQJhyhajUXlaIZOnkXiF82xv56UvdltkICXsMAhbRD",
"@type": "/cosmos.crypto.secp256k1.PubKey"
}
}
]
},
"signatures": [
"WqCfQl/8f+9VlJH2MdP1pEx1dh7/CEf1iKTES3DsjNtrae7ivQSnkkbKVSt3k5bV6Z/gW9eosAlcM1BOeOUClw=="
]
},
"tx_response": {
"tx": "Cp8BCpwBCiMvY29zbW9zLnN0YWtpbmcudjFiZXRhMS5Nc2dEZWxlZ2F0ZRJ1CithdXJhMXB4bDk5czhoNGc1bWc1NjR6cnA0cXo5azhoNjRsMjRmZmE2dmM2EjJhdXJhdmFsb3BlcjFweGw5OXM4aDRnNW1nNTY0enJwNHF6OWs4aDY0bDI0ZmowdHlxeRoSCgZ1ZWF1cmESCDMwMzAwNTI0EmkKUgpGCh8vY29zbW9zLmNyeXB0by5zZWNwMjU2azEuUHViS2V5EiMKIQJx0CYcoWo1F5WiGTp5F4hfNsb+elL3ZbZCAl7DAIW0QxIECgIIARj4pwsSEwoNCgZ1ZWF1cmESAzE5NxCh/gsaQFqgn0Jf/H/vVZSR9jHT9aRMdXYe/whH9YikxEtw7Izba2nu4r0Ep5JGylUrd5OW1emf4FvXqLAJXDNQTnjlApc=",
"code": 0,
"data": "CiUKIy9jb3Ntb3Muc3Rha2luZy52MWJldGExLk1zZ0RlbGVnYXRl",
"info": "",
"logs": [
{
"events": [
{
"type": "coin_received",
"attributes": [
{
"key": "receiver",
"value": "aura1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3wd7dmw"
},
{
"key": "amount",
"value": "30300524ueaura"
}
]
}
]
}
],
"index": 1,
"events": [
{
"type": "coin_spent",
"msg_index": 0,
"attributes": [
{
"key": "c3BlbmRlcg==",
"index": true,
"value": "YXVyYTFweGw5OXM4aDRnNW1nNTY0enJwNHF6OWs4aDY0bDI0ZmZhNnZjNg=="
},
{
"key": "YW1vdW50",
"index": true,
"value": "MTk3dWVhdXJh"
}
]
},
{
"type": "coin_received",
"attributes": [
{
"key": "cmVjZWl2ZXI=",
"index": true,
"value": "YXVyYTE3eHBmdmFrbTJhbWc5NjJ5bHM2Zjg0ejNrZWxsOGM1bHQwNXpmeQ=="
},
{
"key": "YW1vdW50",
"index": true,
"value": "MTk3dWVhdXJh"
}
]
},
{
"type": "message",
"msg_index": 0,
"attributes": [
{
"key": "bW9kdWxl",
"index": true,
"value": "c3Rha2luZw=="
},
{
"key": "c2VuZGVy",
"index": true,
"value": "YXVyYTFweGw5OXM4aDRnNW1nNTY0enJwNHF6OWs4aDY0bDI0ZmZhNnZjNg=="
}
]
}
],
"height": "4999978",
"txhash": "BE3818C381B7FAEDCF896DE1A1104EC7D0F5ACB7B82FD911A863E51F96E3827F",
"raw_log": "[{\"events\":[{\"type\":\"coin_received\",\"attributes\":[{\"key\":\"receiver\",\"value\":\"aura1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3wd7dmw\"},{\"key\":\"amount\",\"value\":\"30300524ueaura\"}]},{\"type\":\"coin_spent\",\"attributes\":[{\"key\":\"spender\",\"value\":\"aura1pxl99s8h4g5mg564zrp4qz9k8h64l24ffa6vc6\"},{\"key\":\"amount\",\"value\":\"30300524ueaura\"}]},{\"type\":\"delegate\",\"attributes\":[{\"key\":\"validator\",\"value\":\"auravaloper1pxl99s8h4g5mg564zrp4qz9k8h64l24fj0tyqy\"},{\"key\":\"amount\",\"value\":\"30300524ueaura\"},{\"key\":\"new_shares\",\"value\":\"30606589.446204834682934805\"}]},{\"type\":\"message\",\"attributes\":[{\"key\":\"action\",\"value\":\"/cosmos.staking.v1beta1.MsgDelegate\"},{\"key\":\"module\",\"value\":\"staking\"},{\"key\":\"sender\",\"value\":\"aura1pxl99s8h4g5mg564zrp4qz9k8h64l24ffa6vc6\"}]},{\"type\":\"withdraw_rewards\",\"attributes\":[{\"key\":\"amount\",\"value\":\"0ueaura\"},{\"key\":\"validator\",\"value\":\"auravaloper1pxl99s8h4g5mg564zrp4qz9k8h64l24fj0tyqy\"}]}]}]",
"gas_used": "150210",
"codespace": "",
"timestamp": "2023-06-07T17:54:59.252Z",
"gas_wanted": "196385"
}
}
}
]
}
}
}
2. Using LCD
To use LCD, you must decide which event condition you want to query. It's based on Tendermint events and you can view here to use. You cannot query involved address tx like using Horoscope.
Search Tx by event by LCD/RPC you can use:
LCD/cosmos/tx/v1beta1/txs
RPC/tx_search?
Input:
- query: {eventType}.{eventAttrKey} = {eventAttrValue}
Output:
"txs": [
{
"body": {
"messages": [
{
"@type": "/cosmwasm.wasm.v1.MsgExecuteContract",
"sender": "aura1ja249ang2pm6df08j534w4ezwqnuqh7lj44yf8",
"contract": "aura13yteqcgwn6ha8lusep6zgm3p6thssquk739x658gzt5e3c42jruqamdvau",
"msg": {"mint":{}},
"funds": [
]
}
],
"memo": "",
"timeout_height": "0",
"extension_options": [
],
"non_critical_extension_options": [
]
},
"auth_info": {
"signer_infos": [
{
"public_key": {
"@type": "/cosmos.crypto.secp256k1.PubKey",
"key": "ArvoHnTblv5lKhjwOO3IedrxDuDlXDc5uosEo6tDQVqT"
},
"mode_info": {
"single": {
"mode": "SIGN_MODE_LEGACY_AMINO_JSON"
}
},
"sequence": "0"
}
],
"fee": {
"amount": [
{
"denom": "ueaura",
"amount": "691"
}
],
"gas_limit": "276721",
"payer": "",
"granter": ""
}
},
"signatures": [
"nYPqgG5+FGufwyCoZZd8LnM3tVt/Lq3RHwYWpTvcEP4p9MXNXEU4CgZvsUY0D7dZcm8zxHlabxLwS/dQOn3Nlg=="
]
}
],
"tx_responses": [
{
"height": "2831198",
"txhash": "831665260868F4DCACEFCACE320FCC46F93B42742A718D89EDF761C3A7B1E6C5",
"codespace": "",
"code": 0,
"data": "0A260A242F636F736D7761736D2E7761736D2E76312E4D736745786563757465436F6E7472616374",
"raw_log": "...",
"logs": [
{
"msg_index": 0,
"log": "",
"events": [
{
"type": "execute",
"attributes": [
{
"key": "_contract_address",
"value": "aura13yteqcgwn6ha8lusep6zgm3p6thssquk739x658gzt5e3c42jruqamdvau"
},
{
"key": "_contract_address",
"value": "aura195e2kxde6rrrh0swnlp7ggzy52lljm037w5wjgqg9yhw5n3xfhxst59ygg"
}
]
}
]
}
],
"info": "",
"gas_wanted": "276721",
"gas_used": "227229",
"tx": {
"@type": "/cosmos.tx.v1beta1.Tx",
"body": {
"messages": [
{
"@type": "/cosmwasm.wasm.v1.MsgExecuteContract",
"sender": "aura1ja249ang2pm6df08j534w4ezwqnuqh7lj44yf8",
"contract": "aura13yteqcgwn6ha8lusep6zgm3p6thssquk739x658gzt5e3c42jruqamdvau",
"msg": {"mint":{}},
"funds": [
]
}
],
"memo": "",
"timeout_height": "0",
"extension_options": [
],
"non_critical_extension_options": [
]
},
"auth_info": {
"signer_infos": [...],
"fee": {
"amount": [
{
"denom": "ueaura",
"amount": "691"
}
],
"gas_limit": "276721",
"payer": "",
"granter": ""
}
},
"signatures": [
"..."
]
},
"timestamp": "2023-01-18T11:11:38Z",
"events": [
{
"type": "coin_spent",
"attributes": [
{
"key": "c3BlbmRlcg==",
"value": "YXVyYTFqYTI0OWFuZzJwbTZkZjA4ajUzNHc0ZXp3cW51cWg3bGo0NHlmOA==",
"index": true
},
{
"key": "YW1vdW50",
"value": "NjkxdWVhdXJh",
"index": true
}
]
}
]
}
],
"pagination": {
"next_key": null,
"total": "2"
}
}