Connections

All

Get by id

Add

/api/v1/connections

Creates new connection

Request parameters

{
  "type": "example",
  "name": "example",
  "databaseUrl": "example",
  "databaseName": "example",
  "databaseUser": "example",
  "databasePassword": "example",
  "databasePort": 96,
  "maxThreads": 96,
  "maxTimeout": 96,
  "properties": "example"
}

Responses

{
  "id": 96,
  "type": "example",
  "name": "example",
  "databaseUrl": "example",
  "databaseName": "example",
  "databaseUser": "example",
  "databasePort": 96,
  "connected": true,
  "maxThreads": 96,
  "maxTimeout": 96,
  "jdbcUrl": "example",
  "properties": "example"
}

Update

Delete

/api/v1/connections/{id}

Deletes existing connection by id

Request parameters

Responses

Get statuses

/api/v1/connections/status

Get connection info with status details

Responses

[
  {
    "connectionName": "example",
    "connectionType": "example",
    "connected": true,
    "connectionUrl": "example"
  }
]

File upload

Example:

curl \
-H "Authorization: Bearer $SELECTZERO_API_KEY" \
-F "file=@/path/to/your/file.csv" \
-F "path=/destination/directory" \
"https://selectzero_url/api/v1/connections/files"

File delete

/api/v1/connections/files

Deletes a file from application file system

Request parameters

Responses

Example:

curl \
-H "Authorization: Bearer $SELECTZERO_API_KEY" \
-F "path=/destination/directory/my-file.csv" \
"https://selectzero_url/api/v1/connections/files"

01 September 2025