Connections

Status

API endpoint: /api/v1/connections/status
Type: GET
Description: Returns connection info and status for all connections
Parameters: none
Result

[
  {
    "connectionName": "Crypto",
    "connectionType": "rest",
    "connected": true,
    "connectionUrl": "https://api.coinlore.net/api/tickers/?start=1&limit=1000"
  },
  {
    "connectionName": "Genome_public",
    "connectionType": "mariadb",
    "connected": true,
    "connectionUrl": "jdbc:mariadb://genome-euro-mysql.soe.ucsc.edu:3306/hgcentral"
  },
  {
    "connectionName": "RNAcentral_public",
    "connectionType": "postgresql",
    "connected": true,
    "connectionUrl": "jdbc:postgresql://hh-pgsql-public.ebi.ac.uk:5432/pfmegrnargs"
  },
  {
    "connectionName": "Rfam_public",
    "connectionType": "mysql",
    "connected": true,
    "connectionUrl": "jdbc:mysql://mysql-rfam-public.ebi.ac.uk:4497/Rfam"
  }
]

File upload

API endpoint: /api/v1/connections/files
Type: POST
Description: Uploads/overwrites a file in application file system
Parameters:
- file - CSV/Excel file to upload
- path - directory path to upload to
Sample cUrl:

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 endpoint: /api/v1/connections/files
Type: DELETE
Description: Deletes a file from application file system
Parameters:
- path - File full path to delete
Sample cUrl:

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

Last modified: 15 January 2025