POST /connections
{
"connectionName": "ClickHouse#1",
"description": "get data from clickhouse",
"host": "localhost",
"port": 8123,
"database": "test",
"userName": "default",
"password": "",
"connectionProperties": []
}
- Show all connections with pagination:
GET /connections?page=0&size=10
POST /models
{
"name": "ontime",
"description": "Flight data",
"connectionId": 1,
"tableName": "ontime",
"criteria": {
"eq": {
"fieldName": "Origin",
"value": "JFK"
}
}
}
- Show all data models with pagination:
GET /models?page=0&size=10
POST /reports
{
"name": "report1",
"description": "The number of flights per day",
"modelId": 1,
"outputs": [
"DayOfWeek",
"count(*)"
],
"groupBy": "DayOfWeek",
"criteria": {
"and": [
{
"ge": {
"fieldName": "Year",
"value": "1988"
}
},
{
"le": {
"fieldName": "Year",
"value": "1990"
}
}
]
}
}
GET /reports?page=0&size=10