The following query demonstrates the basic usage of LiveQuery by getting the current chain height:

SELECT
  utils.udf_json_rpc_call('eth_blockNumber', []) AS rpc_request,
  live.udf_api(
    'POST','https://rpc.tn.us-east-1.bera.flipside.services', {}, rpc_request
  ):data:result AS rpc_result,
  utils.udf_hex_to_int(rpc_result::string)::int as chainhead;

This query has the three basic building blocks of a LiveQuery query:

1. Use the utils.udf_json_rpc_call function to format an RPC request object.
2. Use the live.udf_ap function to perform the request.
3. Parse the result, stored in rpc_result, which in this case is converting the hexidecimal string to an integer.

Start off by familiarizing yourself with the Flipside Data Studio LiveQuery feature via its documentaton. You will specifically be using the livequery.live.udf_api function, which is documented with examples here.

After you understand how to use LiveQuery, you can use it to access the Berachain fullnode RPC at https://rpc.tn.us-east-1.bera.flipside.services then query the results as though they were tabular data. You can use LiveQuery to query the API as follows:

SELECT
  livequery.live.udf_api(
    'GET', -- Method
    'https://rpc.tn.us-east-1.bera.flipside.services', -- URL
    { 'Content-Type': 'application/json' } -- Headers
    { '...' }) -- JSON Body

A body for a JSON-RPC request might look like:

{ 'jsonrpc': '2.0',
'id': 1,
'method': 'my_rpc_call',
'params': [ ... ] }

Flipside provides free, community access to public RPC nodes for emerging Blockchain networks and those that the community shows interest in. This enables builder and analysts on those networks to develop applications on those chains and gather advanced insights via LiveQuery.

Berachain is a high-performance EVM-identical L1 blockchain built on Proof-of-Liquidity consensus. Build applications on and analyze the bArtio B2 testnet via Flipside's public RPC endpoints.

The RPC endpoint is available at https://rpc.tn.us-east-1.bera.flipside.services