---
title: "List pull request creators"
method: GET
path: "/repos/{owner}/{repo}/pull_request_creators/"
tags: ["Pull Request Creators"]
---

# List pull request creators

`GET /repos/{owner}/{repo}/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 on `prs` 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 on `first_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

- `owner` string, required
- `repo` string, required

## Query parameters

- `sort` 'login' | 'prs' | 'prs-desc' | 'first_pr_opened_at' | 'first_pr_opened_at-desc' | 'first_pr_merged_at' | 'first_pr_merged_at-desc'
- `exclude_bots` boolean
- `page` integer
- `page_size` integer

## Response `200`

Default Response

- object
  - `type` 'sql_endpoint', required — The type of the endpoint.
  - `data` object, required
    - `columns` object[], required
      - `col` string, required — The name of the column in the query result.
      - `data_type` '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', required — The data type of the column.
      - `nullable` boolean, required — Whether the column is nullable.
    - `rows` object[], required
      - `id` string — The ID of the pull request creator
      - `login` string — The login (username) of the pull request creator
      - `name` string — The name of the pull request creator
      - `prs` string — The number of pull requests created by the pull request creator
      - `first_pr_opened_at` string — The date of the first pull request created by the pull request creator
      - `first_pr_merged_at` string — The date of the first merged pull request be merged into the repository
    - `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.

---

[API](https://skmtc.net/pingcap/apis/ossinsight-public-api.md) · [All operations](https://skmtc.net/pingcap/apis/ossinsight-public-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/pingcap/ossinsight-public-api/versions/9eeddbadc4bb/schema)