Issue creators history

Querying the historical trend of the number of issue creators in a given repository.

Path Parameters

owner string required
The owner of the repo.
Example: pingcap
repo string required
The name of the repo.
Example: tidb

Query Parameters

per string

Possible values: [day, week, month]

Default value: month

The time interval of the data points.

from string

Default value: 2000-01-01

The start date of the time range.

to string

Default value: 2099-01-01

The end date of the time range.

Responses

• 200

---

Default Response

application/json

Schema

Example (from schema)

---

Schema

type string required

Possible values: [sql_endpoint]

The type of the endpoint.

data object required
columns object[] required
Array [
col string required
The name of the column in the query result.
data_type string required
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.
nullable boolean required
Whether the column is nullable.
]
rows object[] required
Array [
date string
The date of the data point
issue_creators string
The number of issue creators on the date point
]
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.
property name* any

{
  "type": "sql_endpoint",
  "data": {
    "columns": [
      {
        "col": "date",
        "data_type": "VARCHAR",
        "nullable": true
      },
      {
        "col": "issue_creators",
        "data_type": "DECIMAL",
        "nullable": true
      }
    ],
    "rows": [
      {
        "date": "2023-04-01",
        "issue_creators": "1546"
      },
      {
        "date": "2023-05-01",
        "issue_creators": "1560"
      },
      {
        "date": "2023-06-01",
        "issue_creators": "1568"
      },
      {
        "date": "2023-07-01",
        "issue_creators": "1579"
      },
      {
        "date": "2023-08-01",
        "issue_creators": "1580"
      }
    ],
    "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"
      ]
    }
  }
}

Loading...