getBlockByHash view

Column Type Required

hash

String

Yes

transactionDetailsFlag

Boolean

Yes

difficulty

String

No

extraData

String

No

transactionsRoot

String

No

miner

String

No

nonce

String

No

sha3Uncles

String

No

gasLimit

String

No

size

String

No

timestamp

String

No

logsBloom

String

No

stateRoot

String

No

gasUsed

String

No

mixHash

String

No

number

String

No

parentHash

String

No

receiptsRoot

String

No

transactions

Array

No

uncles

Array

No

Examples

SELECT number, transactions FROM getBlockByHash WHERE hash = '0xb3b20624f8f0f86eb50dd04688409e5cea4bd02d700bf6e79e9384d47d6a5a35' AND transactionDetailsFlag = false

Microsoft Excel

  1. In the Excel Data tab, choose Get Data > From Other Source > Blank Query (or New Query > From Other Source > Blank Query for older versions of Excel).

  2. In the Power Query Editor formula bar, enter:

    = Odbc.Query("dsn=Ethereum", "SELECT number, transactions FROM getBlockByHash WHERE hash = '0xb3b20624f8f0f86eb50dd04688409e5cea4bd02d700bf6e79e9384d47d6a5a35' AND transactionDetailsFlag = false")

    replace Ethereum with the name of your Easysoft ODBC-Ethereum Driver data source.

  3. Press the tick button.

  4. In the Query Settings > Properties > Name field, enter:

    getBlockByHash

  5. Select the transactions column.

  6. Choose Transform > Parse > JSON.

  7. Right-click List and choose Drill Down.

  8. Choose Home > Advanced Editor.

  9. In the Advanced Editor window, change the line:

    transactions = #"Parsed JSON"{0}[transactions]

    to:

    transactions = Table.Column(Source,"number") & #"Parsed JSON"{0}[transactions]

  10. Choose Close and Load.