Custom Sql Database Controller

post
Authorizations
Path parameters
datasourceIdstringRequired
Body
stringOptional
Responses
200
OK
*/*
post
POST /api/custom-sql-database/{datasourceId}/sql HTTP/1.1
Host: inscada.cloud
Content-Type: text/plain
Accept: */*
Content-Length: 6

"text"
{
  "results": [
    {
      "type": "text"
    }
  ],
  "size": 1
}
get
Authorizations
Path parameters
datasourceIdstringRequired
Responses
200
OK
*/*
get
GET /api/custom-sql-database/{datasourceId}/schema HTTP/1.1
Host: inscada.cloud
Accept: */*
[
  {
    "procedures": [
      {
        "type": "text",
        "columns": [
          {
            "precision": 1,
            "length": 1,
            "isNullable": true,
            "scale": 1,
            "remarks": "text",
            "name": "text",
            "type": "text",
            "kind": 1,
            "radix": 1
          }
        ],
        "name": "text",
        "remarks": "text"
      }
    ],
    "name": "text",
    "tables": [
      {
        "name": "text",
        "columns": [
          {
            "isNullable": true,
            "isKey": true,
            "size": 1,
            "scale": 1,
            "type": "text",
            "name": "text"
          }
        ],
        "indices": [
          {
            "isNonUnique": true,
            "cardinality": 1,
            "filterCondition": "text",
            "name": "text",
            "qualifier": "text",
            "ordinalPosition": 1,
            "pages": 1,
            "column": "text",
            "sortOrder": "text",
            "type": "text"
          }
        ],
        "type": "text",
        "remarks": "text"
      }
    ],
    "functions": [
      {
        "name": "text",
        "columns": [
          {
            "precision": 1,
            "length": 1,
            "isNullable": true,
            "scale": 1,
            "remarks": "text",
            "name": "text",
            "type": "text",
            "kind": 1,
            "radix": 1
          }
        ],
        "remarks": "text",
        "type": "text"
      }
    ]
  }
]
get
Authorizations
Path parameters
datasourceIdstringRequired
schemaNamestringRequired
Responses
200
OK
*/*
get
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/table HTTP/1.1
Host: inscada.cloud
Accept: */*
[
  {
    "name": "text",
    "columns": [
      {
        "isNullable": true,
        "isKey": true,
        "size": 1,
        "scale": 1,
        "type": "text",
        "name": "text"
      }
    ],
    "indices": [
      {
        "isNonUnique": true,
        "cardinality": 1,
        "filterCondition": "text",
        "name": "text",
        "qualifier": "text",
        "ordinalPosition": 1,
        "pages": 1,
        "column": "text",
        "sortOrder": "text",
        "type": "text"
      }
    ],
    "type": "text",
    "remarks": "text"
  }
]
get
Authorizations
Path parameters
datasourceIdstringRequired
schemaNamestringRequired
tableNamestringRequired
Responses
200
OK
*/*
get
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/table/{tableName} HTTP/1.1
Host: inscada.cloud
Accept: */*
{
  "name": "text",
  "columns": [
    {
      "isNullable": true,
      "isKey": true,
      "size": 1,
      "scale": 1,
      "type": "text",
      "name": "text"
    }
  ],
  "indices": [
    {
      "isNonUnique": true,
      "cardinality": 1,
      "filterCondition": "text",
      "name": "text",
      "qualifier": "text",
      "ordinalPosition": 1,
      "pages": 1,
      "column": "text",
      "sortOrder": "text",
      "type": "text"
    }
  ],
  "type": "text",
  "remarks": "text"
}
get
Authorizations
Path parameters
datasourceIdstringRequired
schemaNamestringRequired
Responses
200
OK
*/*
get
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/procedure HTTP/1.1
Host: inscada.cloud
Accept: */*
[
  {
    "type": "text",
    "columns": [
      {
        "precision": 1,
        "length": 1,
        "isNullable": true,
        "scale": 1,
        "remarks": "text",
        "name": "text",
        "type": "text",
        "kind": 1,
        "radix": 1
      }
    ],
    "name": "text",
    "remarks": "text"
  }
]
get
Authorizations
Path parameters
datasourceIdstringRequired
schemaNamestringRequired
procedureNamestringRequired
Responses
200
OK
*/*
get
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/procedure/{procedureName} HTTP/1.1
Host: inscada.cloud
Accept: */*
{
  "type": "text",
  "columns": [
    {
      "precision": 1,
      "length": 1,
      "isNullable": true,
      "scale": 1,
      "remarks": "text",
      "name": "text",
      "type": "text",
      "kind": 1,
      "radix": 1
    }
  ],
  "name": "text",
  "remarks": "text"
}
get
Authorizations
Path parameters
datasourceIdstringRequired
schemaNamestringRequired
Responses
200
OK
*/*
get
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/function HTTP/1.1
Host: inscada.cloud
Accept: */*
[
  {
    "name": "text",
    "columns": [
      {
        "precision": 1,
        "length": 1,
        "isNullable": true,
        "scale": 1,
        "remarks": "text",
        "name": "text",
        "type": "text",
        "kind": 1,
        "radix": 1
      }
    ],
    "remarks": "text",
    "type": "text"
  }
]
get
Authorizations
Path parameters
datasourceIdstringRequired
schemaNamestringRequired
functionNamestringRequired
Responses
200
OK
*/*
get
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/function/{functionName} HTTP/1.1
Host: inscada.cloud
Accept: */*
{
  "name": "text",
  "columns": [
    {
      "precision": 1,
      "length": 1,
      "isNullable": true,
      "scale": 1,
      "remarks": "text",
      "name": "text",
      "type": "text",
      "kind": 1,
      "radix": 1
    }
  ],
  "remarks": "text",
  "type": "text"
}