rpc_call scalar function

Example

Needs RPC · RPC required

-- Fetch the current gas price via eth_gasPrice

SELECT rpc_call(

$client,

'eth_gasPrice',

'[]'::JSON

) AS response;

Enable JavaScript to run this sample in the notebook. The SQL preview above is still available for reference.

Exact signatures with descriptions, requirements, inputs, returns, and examples.

rpc_call(CLIENT, VARCHAR, JSON) # RPC required

Sends one method call with params in provider order and returns only the JSON-RPC result field.

Name	Type	Use
`client`	CLIENT Attached live CLIENT used for the JSON-RPC request.	required positional
`method`	VARCHAR Method name such as eth_blockNumber or eth_getBalance.	required positional
`params`	JSON JSON array of method parameters in provider order.	required positional

Name	Type
`result`	JSON

Raw JSON-RPC result. Returns the JSON result field from the provider response. RPC errors are raised as SQL errors.

rpc_call is the escape hatch for methods that do not have a typed Determica function.

Prefer typed functions such as get_block, get_logs, or read_contract when you want validated inputs and typed SQL results.
Pass params as a JSON array in the exact order required by the RPC method.
The response envelope is not returned; provider and transport errors become SQL errors.