Track utilization
Retool Platform API provides customers data about the Retool usage and state. To better understand integration with Retool API, the following and a supporting lab is examined.
Retool OpenAPI Resource
Within Retool, the Retool Platform API can be accessed through configuration of an OpenAPI Resource. OpenAPI is a documentation standard that is available here
Once configured in a Retool Resource, queries can easily be defined as seen below. This query leverages the usage summary.
The result of this query is a JSON response with the following information:
{
"success": true,
"data": {
"count_current_page_saves": 9131,
"count_current_page_views": 9569,
"count_current_users": 678,
"count_T30_users": 230,
"percent_growth_page_saves": 6.235340729001585,
"percent_growth_page_views": 7.1299915038232795,
"percent_growth_users": 12.038461538461538,
"percent_growth_T30_users": 0.44654088050314467,
"daily_T30_usage": [
{
"day": "2024-03-11",
"maa": 19,
"mau": 52
},
{
"day": "2024-03-12",
"maa": 21,
"mau": 52
},
{
"day": "2024-03-13",
"maa": 21,
"mau": 54
},
{
"day": "2024-03-14",
"maa": 22,
"mau": 63
}
...
This can then be combined into a chart component within Retool to display increasing utilization. The following image shows the chart configuration:
This results in the following chart, that provides a visual of the daily app utilization.
