Here's a short video guide on how to connect Appsmith to Cube.
Click the “How to connect” link on the Overview page, navigate to the REST API tab. You should see the screen below with your connection credentials (the REST API URL and the authorization token):
For a Cube instance publicly available at a specific
HOST, the REST API URL
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.
Copy and paste the REST API URL and the Authorization token to create a new data source in Appsmith.
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.
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.