getTransactionByBlockNumberAndIndex view

Column Type Required

blockParameter

Yes

No

transactionIndexPosition

Yes

No

maxFeePerGas

String

No

gas

String

No

accessList

Array

No

transactionIndex

String

No

value

String

No

blockHash

String

No

gasPrice

String

No

blockNumber

String

No

from

String

No

chainId

String

No

hash

String

No

nonce

String

No

input

String

No

maxPriorityFeePerGas

String

No

r

String

No

type

String

No

s

String

No

to

String

No

yParity

String

No

v

String

No

Examples

SELECT * FROM getTransactionByBlockNumberAndIndex WHERE blockParameter = '0x5BAD55' AND transactionIndexPosition = '0x0'