Skip to main content
Version: Python

Use the JS API

In this guide, you'll learn how to create a basic web page and use the JS API to create a table in Deephaven and display it. The Deephaven JS API is used to connect to a Deephaven Community Core instance from a browser or node.js application. It manages all your server connections, table tracking, and server communications. The Deephaven Console experience is created using our JS API.

note

This guide assumes you have Deephaven running locally with Python. You can find the completed example available at http://localhost:10000/jsapi/table_basic.html. There are other examples available at http://localhost:10000/jsapi, but we focus specifically on creating the basic table example step-by-step.

Create a simple web page​

Create a new folder to work out of, add in index.html, and start up a server to host the file:

mkdir api-example
cd api-example
touch index.html
python -m http.server
tip

This example uses a basic Python server to host the index.html file, but you can substitute another server.

You should now be able to navigate to your server (located at at http://0.0.0.0:8000/ by default) to view our index.html. Initially, it will be a blank page - nothing is in the index.html yet!

Open up the index.html file for editing, and add the following:

<!doctype html>
<html>
  <head>
    <meta charset="utf-8" />
    <title>Deephaven JS API example</title>
    <!-- Assumes your server is available at http://localhost:10000. Change as necessary -->
    <script
      src="http://localhost:10000/jsapi/dh-internal.js"
      type="text/javascript"
    ></script>
    <script
      src="http://localhost:10000/jsapi/dh-core.js"
      type="text/javascript"
    ></script>
  </head>

  <body>
    <h3>Table data</h3>
    <table id="simpleTable"></table>

    <script>
      (async () => {
        // Add the rest of the code here
      })();
    </script>
  </body>
</html>

Now, if you refresh the page, you should see "Table data" output. We're also loading the JS API scripts, which creates the global dh object (our main entry point into the JS API). If you do not include these scripts, or the path is incorrect, you will get errors trying to use the dh object.

The inline script doesn't have any actual code yet. Let's add some code to make the page do something. Add all the code below into the inline script in the body element of the page.

First, we need to open a connection to the server:

var connection = new dh.IdeConnection('http://localhost:10000');

After a connection is established, we need to start a session. For this example, we will start a python session (the default):

var ide = await connection.startSession('python');

Next, we need to run the code that will create the table. This code creates a static table called remoteTable with 10 rows and three columns: I, J, and K. Because it's Python code, be careful with indentation when creating the template string.

await ide.runCode(`
from deephaven import empty_table
remoteTable = empty_table(10).update_view(formulas = ["I=i", "J=I*I", "K=i%2==0?\`Hello\`:\`World\`"])
`);

Retrieve the JS Table object:

var table = await ide.getTable('remoteTable');

Create a table header element (thead) with the table columns:

var header = document.createElement('thead');
var headerRow = document.createElement('tr');
table.columns.forEach((column) => {
  var td = document.createElement('td');
  td.innerText = column.name;
  headerRow.appendChild(td);
});
header.appendChild(headerRow);

Set the viewport and extract the data to build the body of the table. Since the bottom of the specified viewport is inclusive and the table is ten rows, we only need 0,9:

table.setViewport(0, 9);
var tbody = document.createElement('tbody');
var viewportData = await table.getViewportData();
var rows = viewportData.rows;
for (var i = 0; i < rows.length; i++) {
  var tr = document.createElement('tr');
  for (var j = 0; j < table.columns.length; j++) {
    var td = document.createElement('td');
    td.textContent = rows[i].get(table.columns[j]);
    tr.appendChild(td);
  }
  tbody.appendChild(tr);
}

Retrieve the table element in our document and append the table to it:

var tableElement = document.getElementById('simpleTable');
tableElement.appendChild(header);
tableElement.appendChild(tbody);

Now refresh the page. After the table loads, you should see the table data output in the browser.

Congratulations! You've successfully used the JS API to create a table and read it.

Final product​

The final product of the HTML page is:

<!doctype html>
<html>
  <head>
    <meta charset="utf-8" />
    <title>Deephaven JS API example</title>
    <!-- Assumes your server is running at http://localhost:10000. Change as necessary -->
    <script
      src="http://localhost:10000/jsapi/dh-internal.js"
      type="text/javascript"
    ></script>
    <script
      src="http://localhost:10000/jsapi/dh-core.js"
      type="text/javascript"
    ></script>
  </head>

  <body>
    <h3>Table data</h3>
    <table id="simpleTable"></table>

    <script>
      (async () => {
        // Add the rest of the code here

        var connection = new dh.IdeConnection('http://localhost:10000');

        var ide = await connection.startSession('python');

        await ide.runCode(`
from deephaven import empty_table
remoteTable = empty_table(10).updateView(formulas = ["I=i", "J=I*I", "K=i%2==0?\`Hello\`:\`World\`"])
      `);

        var table = await ide.getTable('remoteTable');

        var header = document.createElement('thead');
        var headerRow = document.createElement('tr');
        table.columns.forEach((column) => {
          var td = document.createElement('td');
          td.innerText = column.name;
          headerRow.appendChild(td);
        });
        header.appendChild(headerRow);

        table.setViewport(0, 9);
        var tbody = document.createElement('tbody');
        var viewportData = await table.getViewportData();
        var rows = viewportData.rows;
        for (var i = 0; i < rows.length; i++) {
          var tr = document.createElement('tr');
          for (var j = 0; j < table.columns.length; j++) {
            var td = document.createElement('td');
            td.textContent = rows[i].get(table.columns[j]);
            tr.appendChild(td);
          }
          tbody.appendChild(tr);
        }

        var tableElement = document.getElementById('simpleTable');
        tableElement.appendChild(header);
        tableElement.appendChild(tbody);
      })();
    </script>
  </body>
</html>