List issue creators
Querying the issue creators for a given repository.
Path Parameters
The owner of the repo.
The name of the repo.
Query Parameters
Possible values: [issues
, issues-desc
, first_issue_opened_at
, first_issue_opened_at-desc
, login
]
Default value: issues-desc
Specify the field by which to sort the issue creators list (values with a -desc
suffix indicate descending sorting)
Default value: true
Whether to exclude robot accounts (includes GitHub App and normal users whose username matches the pattern, for example: ti-chi-bot
).
Default value: 1
Page number of the results to fetch.
Default value: 30
The number of results per page (max 100).
- 200
Default Response
Schema
- Array [
- ]
- Array [
- ]
Possible values: [sql_endpoint
]
The type of the endpoint.
data object required
columns object[] required
The name of the column in the query result.
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.
Whether the column is nullable.
rows object[] required
The ID of the issue creator
The login (username) of the issue creator
The name of the issue creator
The number of issues created by the issue creator
The date of the first issue created by the issue creator
result object required
The code of the response.
The message of the response.
The start time of the query in milliseconds.
The end time of the query in milliseconds.
The latency of the query.
The number of rows in the query result.
The number of rows affected by the query.
The maximum number of rows in the query result.
The databases used in the query.
{
"type": "sql_endpoint",
"data": {
"columns": [
{
"col": "id",
"data_type": "INT",
"nullable": false
},
{
"col": "login",
"data_type": "VARCHAR",
"nullable": false
},
{
"col": "name",
"data_type": "VARCHAR",
"nullable": false
},
{
"col": "issues",
"data_type": "INT",
"nullable": true
},
{
"col": "first_issue_opened_at",
"data_type": "DATETIME",
"nullable": true
}
],
"rows": [
{
"id": "73684",
"login": "yahonda",
"name": "Yasuo Honda",
"issues": "12",
"first_issue_opened_at": "2022-01-04 02:47:05"
},
{
"id": "1000627",
"login": "lcwangchao",
"name": "王超",
"issues": "211",
"first_issue_opened_at": "2021-06-03 01:06:44"
},
{
"id": "7499936",
"login": "qw4990",
"name": "Yuanjia Zhang",
"issues": "276",
"first_issue_opened_at": "2018-12-24 02:55:49"
},
{
"id": "15825830",
"login": "AilinKid",
"name": "Arenatlx",
"issues": "128",
"first_issue_opened_at": "2019-07-26 14:06:29"
},
{
"id": "21033020",
"login": "glkappe",
"name": "",
"issues": "29",
"first_issue_opened_at": "2020-07-30 08:12:09"
}
],
"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"
]
}
}
}