Custom Sql Database Controller
post
Authorizations
Path parameters
datasourceIdstringRequired
Body
stringOptional
Responses
200
OK
*/*
400
Bad Request
*/*
403
Forbidden
*/*
404
Not Found
*/*
409
Conflict
*/*
500
Internal Server Error
*/*
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
*/*
400
Bad Request
*/*
403
Forbidden
*/*
404
Not Found
*/*
409
Conflict
*/*
500
Internal Server Error
*/*
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
*/*
400
Bad Request
*/*
403
Forbidden
*/*
404
Not Found
*/*
409
Conflict
*/*
500
Internal Server Error
*/*
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
*/*
400
Bad Request
*/*
403
Forbidden
*/*
404
Not Found
*/*
409
Conflict
*/*
500
Internal Server Error
*/*
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
*/*
400
Bad Request
*/*
403
Forbidden
*/*
404
Not Found
*/*
409
Conflict
*/*
500
Internal Server Error
*/*
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
*/*
400
Bad Request
*/*
403
Forbidden
*/*
404
Not Found
*/*
409
Conflict
*/*
500
Internal Server Error
*/*
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
*/*
400
Bad Request
*/*
403
Forbidden
*/*
404
Not Found
*/*
409
Conflict
*/*
500
Internal Server Error
*/*
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
*/*
400
Bad Request
*/*
403
Forbidden
*/*
404
Not Found
*/*
409
Conflict
*/*
500
Internal Server Error
*/*
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"
}