List organizations of PR creators
List organizations of pull request creators for the specified repository.
Notice: In the overall data, about 5.62% of GitHub users has valid organization information.
Note: By default, the API does not count users without valid organization information. If you need to count these users, you can set the
exclude_unknown
parameter tofalse
.
Path Parameters
The owner of the repo.
The name of the repo.
Query Parameters
Default value: true
Whether to exclude PR creators with unknown organization information
Default value: 2000-01-01
The start date of the range.
Default value: 2099-01-01
The end date of the range.
- 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
Name of the organization
Percentage of pull request creators from the organization
Number of pull request creators from the organization
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": "org_name",
"data_type": "VARCHAR",
"nullable": true
},
{
"col": "pull_request_creators",
"data_type": "BIGINT",
"nullable": true
},
{
"col": "percentage",
"data_type": "DECIMAL",
"nullable": true
}
],
"rows": [
{
"org_name": "pingcap",
"percentage": "0.3064",
"pull_request_creators": "106"
},
{
"org_name": "bytedance",
"percentage": "0.0318",
"pull_request_creators": "11"
},
{
"org_name": "alibaba",
"percentage": "0.0260",
"pull_request_creators": "9"
},
{
"org_name": "tencent",
"percentage": "0.0173",
"pull_request_creators": "6"
}
],
"result": {
"code": 200,
"message": "Query OK!",
"start_ms": 1690957407469,
"end_ms": 1690957407499,
"latency": "30ms",
"row_count": 4,
"row_affect": 0,
"limit": 50,
"databases": [
"gharchive_dev"
]
}
}
}