filtered_transaction_events

Creates, updates, deletes, gets or lists a filtered_transaction_events resource.

Overview

Name	filtered_transaction_events
Type	Resource
Id	aws.managedblockchain_query.filtered_transaction_events

Fields

The following fields are returned by SELECT queries:

list_filtered_transaction_events

Name	Datatype	Description
blockchain_instant	object	The container for time.
confirmation_status	string	This container specifies whether the transaction has reached Finality. (FINAL, NONFINAL)
contract_address	string	The blockchain address for the contract (pattern: <code>[-A-Za-z0-9]{13,74}</code>)
event_type	string	The type of transaction event. (ERC20_TRANSFER, ERC20_MINT, ERC20_BURN, ERC20_DEPOSIT, ERC20_WITHDRAWAL, ERC721_TRANSFER, ERC1155_TRANSFER, BITCOIN_VIN, BITCOIN_VOUT, INTERNAL_ETH_TRANSFER, ETH_TRANSFER)
from	string	The wallet address initiating the transaction. It can either be a public key or a contract. (pattern: <code>[-A-Za-z0-9]{13,74}</code>)
network	string	The blockchain network where the transaction occurred. (ETHEREUM_MAINNET, ETHEREUM_SEPOLIA_TESTNET, BITCOIN_MAINNET, BITCOIN_TESTNET)
spent_vout_index	integer	The position of the spent transaction output in the output list of the creating transaction. This is only returned for BITCOIN_VIN event types.
spent_vout_transaction_hash	string	The transactionHash that created the spent transaction output. This is only returned for BITCOIN_VIN event types.
spent_vout_transaction_id	string	The transactionId that created the spent transaction output. This is only returned for BITCOIN_VIN event types.
to	string	The wallet address receiving the transaction. It can either be a public key or a contract. (pattern: <code>[-A-Za-z0-9]{13,74}</code>)
token_id	string	The unique identifier for the token involved in the transaction. (pattern: <code>[a-zA-Z0-9]{1,66}</code>)
transaction_hash	string	The hash of a transaction. It is generated when a transaction is created. (pattern: <code>(0x[A-Fa-f0-9]{64}|[A-Fa-f0-9]{64})</code>)
transaction_id	string	The identifier of a Bitcoin transaction. It is generated when a transaction is created.
value	string	The value that was transacted.
vout_index	integer	The position of the transaction output in the transaction output list.
vout_spent	boolean	Specifies if the transaction output is spent or unspent. This is only returned for BITCOIN_VOUT event types. This is only returned for BITCOIN_VOUT event types.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_filtered_transaction_events	select	region		Lists all the transaction events for an address on the blockchain. This operation is only supported on the Bitcoin networks.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

list_filtered_transaction_events

Lists all the transaction events for an address on the blockchain. This operation is only supported on the Bitcoin networks.

SELECT
blockchain_instant,
confirmation_status,
contract_address,
event_type,
from,
network,
spent_vout_index,
spent_vout_transaction_hash,
spent_vout_transaction_id,
to,
token_id,
transaction_hash,
transaction_id,
value,
vout_index,
vout_spent
FROM aws.managedblockchain_query.filtered_transaction_events
WHERE region = '{{ region }}' -- required
;