v11

OpenAPI 3.0.3raw.githubusercontent.com2024-01-1200163.6 KB
Issue Creators

List issue creators

Querying the issue creators for a given repository.

get/repos/{owner}/{repo}/issue_creators/

Path parameters

ownerstring required

The owner of the repo.

repostring required

The name of the repo.

Query parameters

sort'issues' | 'issues-desc' | 'first_issue_opened_at' | 'first_issue_opened_at-desc' | 'login'

Specify the field by which to sort the issue creators list (values with a -desc suffix indicate descending sorting)

exclude_botsboolean

Whether to exclude robot accounts (includes GitHub App and normal users whose username matches the pattern, for example: ti-chi-bot).

pageinteger

Page number of the results to fetch.

page_sizeinteger

The number of results per page (max 100).

Response

Default Response

type'sql_endpoint' required

The type of the endpoint.

Example response

{
  "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"
      ]
    }
  }
}