Appsmith

Appsmith is an open-source framework for building internal tools.

Here's a short video guide on how to connect Appsmith to Cube.

Connect from Cube Cloud

Navigate to the Integrations page, click <Btn>Connect to Cube</Btn>, and choose <Btn>Appsmith</Btn> to get detailed instructions.

Connect from Cube Core

You can connect a Cube deployment to Appsmith using the REST API.

For a Cube instance publicly available at a specific HOST, the REST API URL would be HOST/cubejs-api/v1. Please refer to the REST API page for details.

You will also need to generate a JSON Web Token that would be used to authenticate requests to Cube.

Please check the Security page to learn how to generate a token. We suggest generating a long-lived JWT that won't expire soon.

Connecting from Appsmith

Create a new data source

Copy and paste the REST API URL and the Authorization token to create a new data source in Appsmith.

Create a POST request

Get your Cube query in the JSON query format ready. You can copy it from Cube’s Playground or compose manually:

Create a POST request, paste the JSON query in the Body. Make sure to add a query parameter for your JSON query.

Because you saved the data source as HOST/cubejs-api/v1, don't forget to add a /load endpoint to the end of the data source API.

Next, hit Run.

Display the data

You have many options to display the data in Appsmith. For instance, you can display the data in a table widget. Also, you can create a chart widget and map the values to x and y coordinates accordingly, give a title and names to the axis.