Spreadsheet Functions

MBADDRESS(address, headers, code)

Retrieve the details of a blockchain address.

Parameters

• address Ethereum address or label.
• headers (Optional) Include column headers. TRUE/FALSE, defaults to TRUE.
• code (Optional) Include the smart contract bytecode deployed at the address, if any. TRUE/FALSE, defaults to FALSE.

Return

Address details.

Example

=MBADDRESS("0xe9f2E2B0105B683b436Fd0d7A2895BE25c310Af7", "", false) in the cell. The structure of the return value is as follows:

MBBLOCK(numberOrHash, headers, txHashes)

Retrieve the details of a block.

Parameters

• numberOrHash Block 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.

Example

=MBBLOCK(12) in the cell. The structure of the return value is as follows:

MBCOMPOSE(address, contract, method, from, signer, value, ...args)

Compose an unsigned transaction to call a smart contract function.

Parameters

• address Ethereum address or label.
• contract Smart contract label, must be associated with the address.
• method Smart contract function name.
• from From address.
• signer (Optional) Signer address. Defaults to the 'from' address.
• value (Optional) Value for amount of ETH sent.
• args (Optional) Arguments to pass to the function.

Return

An unsigned transaction, suitable for signing and submitting to the blockchain.

Example

=MBCOMPOSE("multibaasfaucet", "multibaasfaucet", "deposit", "0xA616eEd6aD7A0cF5d2388301a710c273ca955e05", "0xA616eEd6aD7A0cF5d2388301a710c273ca955e05", 100000000000000000) in the cell. The structure of the return value is as follows:

{"from":"0xA616eEd6aD7A0cF5d2388301a710c273ca955e05","to":"0x317570b8c43feCaDb8Ebaf765044Ad9626F4848e","value":"100000000000000000","gas":22774,"gasPrice":"20000000000","data":"0xd0e30db0","nonce":6,"hash":"0x72f0a63bc24503d1b71e93729c7787891633aa192dadb999f87b0f343a8ecbf4"}

‍

MBCUSTOMQUERYTEMPLATE(numSelects, numFilters)

Create a template to be used with a custom MultiBaas Event Query.

Parameters

• numberOfSelects (Optional) Number of 'select' groups to create. Default is 1.
• numberOfFilters (Optional) Number of 'filter' groups to create. Default is 1.

Return

A two dimensional array that can be used as the starting point for a custom Event Query.

Example

=MBCUSTOMQUERYTEMPLATE(2, 0) in the cell. The structure of the return value is as follows:

MBCUSTOMQUERY(events, groupBy, orderBy, limit, offset)

Retrieve the results of a custom MultiBaas Event Query. You can use MBCUSTOMQUERYTEMPLATE to generate a useful template.

Parameters

• events Two dimensional array of event names, selectors and filters.
• groupBy (Optional) Field to group by.
• orderBy (Optional) Field to order by.
• limit (Optional) Number of results to return.
• offset (Optional) Offset from the 0th result to return.

Return

A two dimensional array with the results of the Event Query.

Example

Let's say the given B35:H36 consists of MBCUSTOMQUERYTEMPLATE example above.

=MBCUSTOMQUERY(B35:H36, "", "", 3, 0) in the cell. The structure of the return value is as follows:

MBEVENTLIST(contract, filter)

Retrieve a detailed list of a smart contract's events.

Parameters

• contract Smart contract label, must be associated with the address.
• filter (Optional) Regular expression (regex) to filter function names on.

Return

Array of smart contract functions and their inputs and outputs.

Example

=MBEVENTLIST("multibaasfaucet") in the cell. The structure of the return value is as follows:

MBEVENTS(address, limit, offset)

Retrieve blockchain events. Address must be associated with one or more contracts in MultiBaas.

Parameters

• address Ethereum address or label.
• limit (Optional) Number of results to return.
• offset (Optional) Offset from the 0th result to return.

Return

A two dimensional array of events.

Example

=MBEVENTS("privatefaucet", 1, 2) in the cell.  The structure of the return value is as follows:

MBFUNCTIONLIST(contract, filter)

Retrieve a detailed list of a smart contract's functions.

Parameters

• contract Smart contract label, must be associated with the address.
• filter (Optional) Regular expression (regex) to filter function names on.

Return

Array of smart contract functions and their inputs and outputs.

Example

=MBFUNCTIONLIST("erc20interface") in the cell. The structure of the return value is as follows:

MBGET(address, contract, method, ...args)

Retrieve the results of a smart contract function call.

Parameters

• address Ethereum address or label.
• contract Smart contract label, must be associated with the address.
• method Smart contract function name.
• args (Optional) Arguments to pass to the function.

Return

One or more values returned from the function.

Example

=MBGET("privatefaucet", "multibaasfaucet", "getOperator") in the cell. The structure of the return value is as follows:

0x005080F78567F8001115F1eee835DD0151BEA476

MBPOSTTEMPLATE(numberOfArgs)

Create a template to be used with calling a smart contract method (function) that will write to the blockchain.

Parameters

• numberOfArgs (Optional) Number of arguments (parameters) to pass to the method (function). Default is 0.

Return

A two dimensional array that can be used as the starting point for calling a smart contract method.

Example

=MBPOSTTEMPLATE(1) in the cell.  The structure of the return value is as follows:

MBTX(hash, headers)

Retrieve the details of a blockchain transaction.

Parameters

• hash Transaction hash.
• headers (Optional) Include column headers. TRUE/FALSE, defaults to TRUE.

Return

Transaction details.

Example

=MBTX("0xfe9e4b800d14c36f2e8c26ab44ffcfcbf55ac71d6f0d5f2ac95b3d63c7f71569") in the cell. The structure of the return value is as follows:

MBQUERY(query, limit, offset)

Retrieve the results of a MultiBaas Event Query.

Parameters

• query Event Query name to return results from.
• limit (Optional) Number of results to return.
• offset (Optional) Offset from the 0th result to return.

Return

A two dimensional array with the results of the Event Query.

Example

=MBQUERY("Faucet", 2, 1) in the cell. The structure of the return value is as follows:

Post to the blockchain

Compose, sign, and submit a transaction to the blockchain. An enterprise wallet (Hardware Security Module or HSM) must be configured in the MultiBaas deployment. An HSM address will be used to sign the transaction (web3 browsers such as MetaMask will not work to sign transactions in Google Sheet).

• For example, MBPOSTTEMPLATE might output:

• Enter parameters under each column name as follows. Multiple rows can be entered for multiple transactions.

• Drag and select all of the parameters entered, across one or more rows. Go to Add-ons > MultiBaas for Google Sheet > Post to the blockchain
• The txHash (output) will be filled in as each transaction is submitted to the blockchain:

Refresh current cell

This is a convenience function to refresh the current cell's custom function.

• Select a cell which has a custom function. For example, =MBQUERY("Faucet", 2, 1) might be in the cell.
• Go to Add-ons > MultiBaas for Google Sheet > Refresh current cell

‍