List pull request creators
Querying the pull request creators list in a given repository.
This API provides multiple ways to sort the query results, for example:
sort=prs-desc
(Default): Sorted in descending order based onprs
field (the number of PRs they have contributed), meaning that the contributor with the most PRs is at the top.sort=first_pr_merged_at-desc
: Sorted in descending order based onfirst_pr_merged_at
field (the time of their first merged PR), which means you can got a list of new code contributors of the repository.
Path Parameters
The owner of the repo.
The name of the repo.
Query Parameters
Possible values: [login
, prs
, prs-desc
, first_pr_opened_at
, first_pr_opened_at-desc
, first_pr_merged_at
, first_pr_merged_at-desc
]
Default value: prs-desc
Specify the field by which to sort the pull request 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 pull request creator
The login (username) of the pull request creator
The name of the pull request creator
The number of pull requests created by the pull request creator
The date of the first pull request created by the pull request creator
The date of the first merged pull request be merged into the repository
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": "prs",
"data_type": "INT",
"nullable": true
},
{
"col": "first_pr_opened_at",
"data_type": "DATETIME",
"nullable": true
},
{
"col": "first_pr_merged_at",
"data_type": "DATETIME",
"nullable": true
}
],
"rows": [
{
"id": "1420062",
"login": "tiancaiamao",
"name": "",
"prs": "1300",
"first_pr_opened_at": "2016-06-20 14:08:39",
"first_pr_merged_at": "2016-06-21 07:45:27"
},
{
"id": "3427324",
"login": "hawkingrei",
"name": "Weizhen Wang",
"prs": "927",
"first_pr_opened_at": "2017-05-17 15:00:50",
"first_pr_merged_at": "2017-05-22 04:47:11"
},
{
"id": "26020263",
"login": "crazycs520",
"name": "crazycs",
"prs": "788",
"first_pr_opened_at": "2018-06-12 05:02:07",
"first_pr_merged_at": "2018-06-29 03:01:35"
},
{
"id": "891222",
"login": "coocood",
"name": "Evan Zhou",
"prs": "779",
"first_pr_opened_at": "2015-09-06 05:58:15",
"first_pr_merged_at": "2015-09-06 07:10:13"
},
{
"id": "4242506",
"login": "zimulala",
"name": "Lynn",
"prs": "774",
"first_pr_opened_at": "2015-09-06 10:51:19",
"first_pr_merged_at": "2015-09-06 12:32:33"
}
],
"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"
]
}
}
}