query layer - create

Developing

Develop Env

http://localhost:8080/api/v1

POST

/queryLayer

Request

Body Params application/json

Example

{
    "name" : "Query A",
    "dbType": "starrock",
    "code": "bhov_hadir3",
    "displayType": "table",
    "queryString" : "SELECT sistem, status, dmn_mw, dmp_mw, bp_mw, unit_max_mw, cad_mw, keterangan FROM t_opsis to2 WHERE status != 'Normal';",
    "metadata": 
        [
            {
                "metaKey": "color",
                "metaValue": "#11111"
            }
        ],
    "queryParams" : [],
    "tableIds" : []
}

Request Code Samples

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'http://localhost:8080/api/v1/queryLayer' \
--header 'Content-Type: application/json' \
--data-raw '{
    "name" : "Query A",
    "dbType": "starrock",
    "code": "bhov_hadir3",
    "displayType": "table",
    "queryString" : "SELECT sistem, status, dmn_mw, dmp_mw, bp_mw, unit_max_mw, cad_mw, keterangan FROM t_opsis to2 WHERE status != '\''Normal'\'';",
    "metadata": 
        [
            {
                "metaKey": "color",
                "metaValue": "#11111"
            }
        ],
    "queryParams" : [],
    "tableIds" : []
}'

Responses

🟢200Success

application/json

Body

Example

{}

Modified at 2024-05-12 10:56:26

Get column based selected table

query layer - edit