transactions

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

Overview

Name	transactions
Type	Resource
Id	aws.managedblockchain_query.transactions

Fields

The following fields are returned by SELECT queries:

list_transactions

Name	Datatype	Description
confirmation_status	string	Specifies whether to list transactions that have not reached Finality. (FINAL, NONFINAL)
network	string	The blockchain network where the transaction occurred. (ETHEREUM_MAINNET, ETHEREUM_SEPOLIA_TESTNET, BITCOIN_MAINNET, BITCOIN_TESTNET)
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. (pattern: <code>(0x[A-Fa-f0-9]{64}|[A-Fa-f0-9]{64})</code>)
transaction_timestamp	string (date-time)	The time when the transaction occurred.

get_transaction

Name	Datatype	Description
block_hash	string	The block hash is a unique identifier for a block. It is a fixed-size string that is calculated by using the information in the block. The block hash is used to verify the integrity of the data in the block. (pattern: <code>(0x[A-Fa-f0-9]{64}|[A-Fa-f0-9]{64})</code>)
block_number	string	The block number in which the transaction is recorded.
confirmation_status	string	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>)
cumulative_gas_used	string	The amount of gas used up to the specified point in the block.
effective_gas_price	string	The effective gas price.
execution_status	string	Identifies whether the transaction has succeeded or failed. (FAILED, SUCCEEDED)
from	string	The initiator of the transaction. It is either in the form a public key or a contract address. (pattern: <code>[-A-Za-z0-9]{13,74}</code>)
gas_used	string	The amount of gas used for the transaction.
network	string	The blockchain network where the transaction occurred. (ETHEREUM_MAINNET, ETHEREUM_SEPOLIA_TESTNET, BITCOIN_MAINNET, BITCOIN_TESTNET)
number_of_transactions	integer (int64)	The number of transactions in the block.
signature_r	string	The signature of the transaction. The X coordinate of a point R.
signature_s	string	The signature of the transaction. The Y coordinate of a point S.
signature_v	integer	The signature of the transaction. The Z coordinate of a point V.
to	string	The identifier of the transaction. It is generated whenever a transaction is verified and added to the blockchain. (pattern: <code>[-A-Za-z0-9]{13,74}</code>)
transaction_fee	string	The transaction fee.
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.
transaction_index	integer (int64)	The index of the transaction within a blockchain.
transaction_timestamp	string (date-time)	The Timestamp of the transaction.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_transactions	select	region		Lists all the transaction events for a transaction.
get_transaction	select	region		Gets the details of a transaction. This action will return transaction details for all transactions that are confirmed on the blockchain, even if they have not reached finality.

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_transactions

Lists all the transaction events for a transaction.

SELECT
confirmation_status,
network,
transaction_hash,
transaction_id,
transaction_timestamp
FROM aws.managedblockchain_query.transactions
WHERE region = '{{ region }}' -- required
;

get_transaction

Gets the details of a transaction. This action will return transaction details for all transactions that are confirmed on the blockchain, even if they have not reached finality.

SELECT
block_hash,
block_number,
confirmation_status,
contract_address,
cumulative_gas_used,
effective_gas_price,
execution_status,
from,
gas_used,
network,
number_of_transactions,
signature_r,
signature_s,
signature_v,
to,
transaction_fee,
transaction_hash,
transaction_id,
transaction_index,
transaction_timestamp
FROM aws.managedblockchain_query.transactions
WHERE region = '{{ region }}' -- required
;