Custom Sql Database Controller
Access token provided as a cookie named 'ins_access_token'. This token is obtained after successful login and is valid for x minutes. It can be refreshed using the ins_refresh_token cookie at the /refresh endpoint.
Required active space header
OK
Bad Request
Forbidden
Not Found
Conflict
Internal Server Error
POST /api/custom-sql-database/{datasourceId}/sql HTTP/1.1
Host: inscada.cloud
X-Space: YOUR_API_KEY
Content-Type: text/plain
Accept: */*
Content-Length: 6
"text"{
"results": [
{
"type": "text"
}
],
"size": 1
}Access token provided as a cookie named 'ins_access_token'. This token is obtained after successful login and is valid for x minutes. It can be refreshed using the ins_refresh_token cookie at the /refresh endpoint.
Required active space header
OK
Bad Request
Forbidden
Not Found
Conflict
Internal Server Error
GET /api/custom-sql-database/{datasourceId}/schema HTTP/1.1
Host: inscada.cloud
X-Space: YOUR_API_KEY
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"
}
]
}
]Access token provided as a cookie named 'ins_access_token'. This token is obtained after successful login and is valid for x minutes. It can be refreshed using the ins_refresh_token cookie at the /refresh endpoint.
Required active space header
OK
Bad Request
Forbidden
Not Found
Conflict
Internal Server Error
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/table HTTP/1.1
Host: inscada.cloud
X-Space: YOUR_API_KEY
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"
}
]Access token provided as a cookie named 'ins_access_token'. This token is obtained after successful login and is valid for x minutes. It can be refreshed using the ins_refresh_token cookie at the /refresh endpoint.
Required active space header
OK
Bad Request
Forbidden
Not Found
Conflict
Internal Server Error
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/table/{tableName} HTTP/1.1
Host: inscada.cloud
X-Space: YOUR_API_KEY
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"
}Access token provided as a cookie named 'ins_access_token'. This token is obtained after successful login and is valid for x minutes. It can be refreshed using the ins_refresh_token cookie at the /refresh endpoint.
Required active space header
OK
Bad Request
Forbidden
Not Found
Conflict
Internal Server Error
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/procedure HTTP/1.1
Host: inscada.cloud
X-Space: YOUR_API_KEY
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"
}
]Access token provided as a cookie named 'ins_access_token'. This token is obtained after successful login and is valid for x minutes. It can be refreshed using the ins_refresh_token cookie at the /refresh endpoint.
Required active space header
OK
Bad Request
Forbidden
Not Found
Conflict
Internal Server Error
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/procedure/{procedureName} HTTP/1.1
Host: inscada.cloud
X-Space: YOUR_API_KEY
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"
}Access token provided as a cookie named 'ins_access_token'. This token is obtained after successful login and is valid for x minutes. It can be refreshed using the ins_refresh_token cookie at the /refresh endpoint.
Required active space header
OK
Bad Request
Forbidden
Not Found
Conflict
Internal Server Error
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/function HTTP/1.1
Host: inscada.cloud
X-Space: YOUR_API_KEY
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"
}
]Access token provided as a cookie named 'ins_access_token'. This token is obtained after successful login and is valid for x minutes. It can be refreshed using the ins_refresh_token cookie at the /refresh endpoint.
Required active space header
OK
Bad Request
Forbidden
Not Found
Conflict
Internal Server Error
GET /api/custom-sql-database/{datasourceId}/schema/{schemaName}/function/{functionName} HTTP/1.1
Host: inscada.cloud
X-Space: YOUR_API_KEY
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"
}Last updated