List collections

List collections.

Responses

• 200

---

Default Response

application/json

Schema

Example (from schema)

---

Schema

type string required

Possible values: [sql_endpoint]

The type of the endpoint.

data object required
columns object[] required
Array [
col string required
The name of the column in the query result.
data_type string required
Possible values: [CHAR, BIGINT, DECIMAL, INT, UNSIGNED BIGINT, TINYINT, TIMESTAMP, TEXT, VARCHAR, DATETIME, DOUBLE, FLOAT, DATE, TIME, YEAR, MEDIUMINT, SMALLINT, BIT, BINARY, VARBINARY, JSON, ENUM, SET, TINYTEXT, MEDIUMTEXT, LONGTEXT, TINYBLOB, MEDIUMBLOB, BLOB, LONGBLOB]
The data type of the column.
nullable boolean required
Whether the column is nullable.
]
rows object[] required
Array [
repo_id string
Repository ID
repo_name string
Repository name
]
result object required
code number
The code of the response.
message string
The message of the response.
start_ms number
The start time of the query in milliseconds.
end_ms number
The end time of the query in milliseconds.
latency string
The latency of the query.
row_count number
The number of rows in the query result.
row_affect number
The number of rows affected by the query.
limit number
The maximum number of rows in the query result.
databases string[]
The databases used in the query.
property name* any

{
  "type": "sql_endpoint",
  "data": {
    "columns": [
      {
        "col": "id",
        "data_type": "BIGINT",
        "nullable": false
      },
      {
        "col": "name",
        "data_type": "VARCHAR",
        "nullable": false
      }
    ],
    "rows": [
      {
        "id": "1",
        "name": "Static Site Generator"
      },
      {
        "id": "2",
        "name": "Open Source Database"
      },
      {
        "id": "10001",
        "name": "CSS Framework"
      },
      {
        "id": "10002",
        "name": "Google Analytics Alternative"
      },
      {
        "id": "10003",
        "name": "Low Code Development Tool"
      }
    ],
    "result": {
      "code": 200,
      "message": "Query OK!",
      "start_ms": 1690957407469,
      "end_ms": 1690957407499,
      "latency": "30ms",
      "row_count": 5,
      "row_affect": 0,
      "limit": 50,
      "databases": [
        "gharchive_dev"
      ]
    }
  }
}

Loading...