Blockchain block functions
Helps to retrieve information from the blockchain block number or hash.
MBBLOCK(numberOrHash, headers, txHashes)
Retrieve the details of a block.
Parameters
-
numberOrHashBlock number or hash. -
headers(Optional) Include column headers. TRUE/FALSE, defaults to TRUE. -
txHashes(Optional) Include the transaction hashes. TRUE/FALSE, defaults to TRUE.
Return
Block details.
Exmaple
=MBBLOCK(12) in the cell. The structure of the return value is as follows:
| blockchain | hash | difficulty | gasLimit | number | timestamp | receipt | txHashes |
|---|---|---|---|---|---|---|---|
| ethereum | 0x4ff2fbf3d751c1d7b4af45fb5ebeae4b92b87779ad9713415c7e1c96c7d66c3f | 2 | 9883456 | 12 | 5/24/2020 | 0xbb5ffb2963ae9f743623ec04537705ea7c2c6388ffa0b3fff72c0e27e06f0a55 | 0x9e1d4dea734aa14130a1970c5f5b00f9d0ac401fdf52bb9ba027af9dfe509abc |