Open Source Benchmark

Open Source Benchmark · Actions GPT

GPT-PK

API Interface for GPT PK Action, response GitHub repo metrics and hackernews mentions count data

  • GET /github/repo/star_history/github/repo/star_history

    GitHub repo star history

  • GET /github/repo/stargazers_company/github/repo/stargazers_company
  • GET /github/repo/stargazers_country/github/repo/stargazers_country

    github repo stargazers country

  • GET /hackernews/mentions_count/hackernews/mentions_count

    Total counts for keyword in hackernews

  • GET /hackernews/mentions_per_year/hackernews/mentions_per_year

    keyword mentions per year in hackernews

Schéma original API
{
  "openapi": "3.0.3",
  "components": {
    "schemas": {
      "getGithubRepoStar_historyResponse": {
        "properties": {
          "data": {
            "properties": {
              "columns": {
                "items": {
                  "properties": {
                    "col": {
                      "type": "string"
                    },
                    "data_type": {
                      "type": "string"
                    },
                    "nullable": {
                      "type": "boolean"
                    }
                  },
                  "type": "object"
                },
                "type": "array"
              },
              "result": {
                "properties": {
                  "code": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "end_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "latency": {
                    "type": "string"
                  },
                  "limit": {
                    "maximum": 18446744073709552000,
                    "minimum": 0,
                    "type": "integer"
                  },
                  "message": {
                    "type": "string"
                  },
                  "row_affect": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "row_count": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "start_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "warn_count": {
                    "type": "integer"
                  },
                  "warn_messages": {
                    "items": {
                      "type": "string"
                    },
                    "type": "array"
                  }
                },
                "type": "object"
              },
              "rows": {
                "items": {
                  "properties": {
                    "date": {
                      "type": "string"
                    },
                    "stargazers": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "date",
                    "stargazers"
                  ],
                  "type": "object"
                },
                "type": "array"
              }
            },
            "required": [
              "columns",
              "rows",
              "result"
            ],
            "type": "object"
          },
          "type": {
            "type": "string"
          }
        },
        "required": [
          "type",
          "data"
        ],
        "type": "object"
      },
      "getGithubRepoStargazers_companyResponse": {
        "properties": {
          "data": {
            "properties": {
              "columns": {
                "items": {
                  "properties": {
                    "col": {
                      "type": "string"
                    },
                    "data_type": {
                      "type": "string"
                    },
                    "nullable": {
                      "type": "boolean"
                    }
                  },
                  "type": "object"
                },
                "type": "array"
              },
              "result": {
                "properties": {
                  "code": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "end_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "latency": {
                    "type": "string"
                  },
                  "limit": {
                    "maximum": 18446744073709552000,
                    "minimum": 0,
                    "type": "integer"
                  },
                  "message": {
                    "type": "string"
                  },
                  "row_affect": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "row_count": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "start_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "warn_count": {
                    "type": "integer"
                  },
                  "warn_messages": {
                    "items": {
                      "type": "string"
                    },
                    "type": "array"
                  }
                },
                "type": "object"
              },
              "rows": {
                "items": {
                  "properties": {
                    "company_name": {
                      "type": "string"
                    },
                    "proportion": {
                      "type": "string"
                    },
                    "stargazers": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "company_name",
                    "stargazers",
                    "proportion"
                  ],
                  "type": "object"
                },
                "type": "array"
              }
            },
            "required": [
              "columns",
              "rows",
              "result"
            ],
            "type": "object"
          },
          "type": {
            "type": "string"
          }
        },
        "required": [
          "type",
          "data"
        ],
        "type": "object"
      },
      "getGithubRepoStargazers_countryResponse": {
        "properties": {
          "data": {
            "properties": {
              "columns": {
                "items": {
                  "properties": {
                    "col": {
                      "type": "string"
                    },
                    "data_type": {
                      "type": "string"
                    },
                    "nullable": {
                      "type": "boolean"
                    }
                  },
                  "type": "object"
                },
                "type": "array"
              },
              "result": {
                "properties": {
                  "code": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "end_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "latency": {
                    "type": "string"
                  },
                  "limit": {
                    "maximum": 18446744073709552000,
                    "minimum": 0,
                    "type": "integer"
                  },
                  "message": {
                    "type": "string"
                  },
                  "row_affect": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "row_count": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "start_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "warn_count": {
                    "type": "integer"
                  },
                  "warn_messages": {
                    "items": {
                      "type": "string"
                    },
                    "type": "array"
                  }
                },
                "type": "object"
              },
              "rows": {
                "items": {
                  "properties": {
                    "country_code": {
                      "type": "string"
                    },
                    "percentage": {
                      "type": "string"
                    },
                    "stargazers": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "country_code",
                    "stargazers",
                    "percentage"
                  ],
                  "type": "object"
                },
                "type": "array"
              }
            },
            "required": [
              "columns",
              "rows",
              "result"
            ],
            "type": "object"
          },
          "type": {
            "type": "string"
          }
        },
        "required": [
          "type",
          "data"
        ],
        "type": "object"
      },
      "getHackernewsMentions_countResponse": {
        "properties": {
          "data": {
            "properties": {
              "columns": {
                "items": {
                  "properties": {
                    "col": {
                      "type": "string"
                    },
                    "data_type": {
                      "type": "string"
                    },
                    "nullable": {
                      "type": "boolean"
                    }
                  },
                  "type": "object"
                },
                "type": "array"
              },
              "result": {
                "properties": {
                  "code": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "end_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "latency": {
                    "type": "string"
                  },
                  "limit": {
                    "maximum": 18446744073709552000,
                    "minimum": 0,
                    "type": "integer"
                  },
                  "message": {
                    "type": "string"
                  },
                  "row_affect": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "row_count": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "start_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "warn_count": {
                    "type": "integer"
                  },
                  "warn_messages": {
                    "items": {
                      "type": "string"
                    },
                    "type": "array"
                  }
                },
                "type": "object"
              },
              "rows": {
                "items": {
                  "properties": {
                    "count": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "count"
                  ],
                  "type": "object"
                },
                "type": "array"
              }
            },
            "required": [
              "columns",
              "rows",
              "result"
            ],
            "type": "object"
          },
          "type": {
            "type": "string"
          }
        },
        "required": [
          "type",
          "data"
        ],
        "type": "object"
      },
      "getHackernewsMentions_per_yearResponse": {
        "properties": {
          "data": {
            "properties": {
              "columns": {
                "items": {
                  "properties": {
                    "col": {
                      "type": "string"
                    },
                    "data_type": {
                      "type": "string"
                    },
                    "nullable": {
                      "type": "boolean"
                    }
                  },
                  "type": "object"
                },
                "type": "array"
              },
              "result": {
                "properties": {
                  "code": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "end_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "latency": {
                    "type": "string"
                  },
                  "limit": {
                    "maximum": 18446744073709552000,
                    "minimum": 0,
                    "type": "integer"
                  },
                  "message": {
                    "type": "string"
                  },
                  "row_affect": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "row_count": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "start_ms": {
                    "format": "int64",
                    "type": "integer"
                  },
                  "warn_count": {
                    "type": "integer"
                  },
                  "warn_messages": {
                    "items": {
                      "type": "string"
                    },
                    "type": "array"
                  }
                },
                "type": "object"
              },
              "rows": {
                "items": {
                  "properties": {
                    "count": {
                      "type": "string"
                    },
                    "date": {
                      "type": "string"
                    }
                  },
                  "required": [
                    "count",
                    "date"
                  ],
                  "type": "object"
                },
                "type": "array"
              }
            },
            "required": [
              "columns",
              "rows",
              "result"
            ],
            "type": "object"
          },
          "type": {
            "type": "string"
          }
        },
        "required": [
          "type",
          "data"
        ],
        "type": "object"
      }
    },
    "securitySchemes": {
      "basicAuth": {
        "description": "Enter your public key for the username field and private key for the password field",
        "scheme": "basic",
        "type": "http"
      }
    }
  },
  "info": {
    "description": "API Interface for GPT PK Action, response GitHub repo metrics and hackernews mentions count data",
    "title": "GPT-PK",
    "version": "1.0.0"
  },
  "paths": {
    "/github/repo/star_history": {
      "get": {
        "description": "GitHub repo star history",
        "operationId": "getGithubRepoStar_history",
        "parameters": [
          {
            "description": "The time interval of the data points",
            "in": "query",
            "name": "per",
            "schema": {
              "default": "month",
              "enum": [
                "day",
                "week",
                "month"
              ],
              "example": "month",
              "type": "string"
            }
          },
          {
            "description": "The owner of the repo. For example: `pingcap`",
            "in": "query",
            "name": "owner",
            "required": true,
            "schema": {
              "default": "",
              "example": "",
              "type": "string"
            }
          },
          {
            "description": "The name of the repo. For example: `tidb`",
            "in": "query",
            "name": "repo",
            "required": true,
            "schema": {
              "default": "",
              "example": "",
              "type": "string"
            }
          },
          {
            "description": "The start date of the range",
            "in": "query",
            "name": "from",
            "schema": {
              "default": "2000-01-01",
              "example": "2000-01-01",
              "type": "string"
            }
          },
          {
            "description": "The end date of the range",
            "in": "query",
            "name": "to",
            "schema": {
              "default": "2099-12-31",
              "example": "2099-12-31",
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStar_historyResponse"
                }
              }
            },
            "description": "OK"
          },
          "400": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 400,
                      "message": "param check failed! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStar_historyResponse"
                }
              }
            },
            "description": "Bad request"
          },
          "401": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 401,
                      "message": "auth failed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStar_historyResponse"
                }
              }
            },
            "description": "Unauthorized request"
          },
          "404": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 404,
                      "message": "endpoint not found",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStar_historyResponse"
                }
              }
            },
            "description": "The requested resource was not found"
          },
          "405": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 405,
                      "message": "method not allowed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStar_historyResponse"
                }
              }
            },
            "description": "The requested method is not supported for the specified resource"
          },
          "408": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 408,
                      "message": "request timeout",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStar_historyResponse"
                }
              }
            },
            "description": "The server timed out waiting for the request"
          },
          "429": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 429,
                      "message": "The request exceeded the limit of 100 times per apikey per minute. For more quota, please contact us: https://support.pingcap.com/hc/en-us/requests/new?ticket_form_id=7800003722519",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStar_historyResponse"
                }
              }
            },
            "description": "The user has sent too many requests in a given amount of time"
          },
          "500": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 500,
                      "message": "internal error! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStar_historyResponse"
                }
              }
            },
            "description": "Internal server error"
          }
        },
        "summary": "/github/repo/star_history",
        "tags": [
          "Default"
        ]
      }
    },
    "/github/repo/stargazers_company": {
      "get": {
        "operationId": "getGithubRepoStargazers_company",
        "parameters": [
          {
            "in": "query",
            "name": "owner",
            "schema": {
              "default": "",
              "example": "",
              "type": "string"
            }
          },
          {
            "in": "query",
            "name": "repo",
            "schema": {
              "default": "",
              "example": "",
              "type": "string"
            }
          },
          {
            "in": "query",
            "name": "from",
            "schema": {
              "default": "2000-01-01",
              "example": "2000-01-01",
              "type": "string"
            }
          },
          {
            "in": "query",
            "name": "to",
            "schema": {
              "default": "2099-01-01",
              "example": "2099-01-01",
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_companyResponse"
                }
              }
            },
            "description": "OK"
          },
          "400": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 400,
                      "message": "param check failed! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_companyResponse"
                }
              }
            },
            "description": "Bad request"
          },
          "401": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 401,
                      "message": "auth failed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_companyResponse"
                }
              }
            },
            "description": "Unauthorized request"
          },
          "404": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 404,
                      "message": "endpoint not found",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_companyResponse"
                }
              }
            },
            "description": "The requested resource was not found"
          },
          "405": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 405,
                      "message": "method not allowed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_companyResponse"
                }
              }
            },
            "description": "The requested method is not supported for the specified resource"
          },
          "408": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 408,
                      "message": "request timeout",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_companyResponse"
                }
              }
            },
            "description": "The server timed out waiting for the request"
          },
          "429": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 429,
                      "message": "The request exceeded the limit of 100 times per apikey per minute. For more quota, please contact us: https://support.pingcap.com/hc/en-us/requests/new?ticket_form_id=7800003722519",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_companyResponse"
                }
              }
            },
            "description": "The user has sent too many requests in a given amount of time"
          },
          "500": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 500,
                      "message": "internal error! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_companyResponse"
                }
              }
            },
            "description": "Internal server error"
          }
        },
        "summary": "/github/repo/stargazers_company",
        "tags": [
          "Default"
        ]
      }
    },
    "/github/repo/stargazers_country": {
      "get": {
        "description": "github repo stargazers country",
        "operationId": "getGithubRepoStargazers_country",
        "parameters": [
          {
            "in": "query",
            "name": "owner",
            "schema": {
              "default": "",
              "example": "",
              "type": "string"
            }
          },
          {
            "in": "query",
            "name": "repo",
            "schema": {
              "default": "",
              "example": "",
              "type": "string"
            }
          },
          {
            "in": "query",
            "name": "from",
            "schema": {
              "default": "2000-01-01",
              "example": "2000-01-01",
              "type": "string"
            }
          },
          {
            "in": "query",
            "name": "to",
            "schema": {
              "default": "2099-01-01",
              "example": "2099-01-01",
              "type": "string"
            }
          },
          {
            "in": "query",
            "name": "exclude_unknown",
            "schema": {
              "default": "true",
              "example": "true",
              "type": "boolean"
            }
          }
        ],
        "responses": {
          "200": {
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_countryResponse"
                }
              }
            },
            "description": "OK"
          },
          "400": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 400,
                      "message": "param check failed! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_countryResponse"
                }
              }
            },
            "description": "Bad request"
          },
          "401": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 401,
                      "message": "auth failed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_countryResponse"
                }
              }
            },
            "description": "Unauthorized request"
          },
          "404": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 404,
                      "message": "endpoint not found",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_countryResponse"
                }
              }
            },
            "description": "The requested resource was not found"
          },
          "405": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 405,
                      "message": "method not allowed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_countryResponse"
                }
              }
            },
            "description": "The requested method is not supported for the specified resource"
          },
          "408": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 408,
                      "message": "request timeout",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_countryResponse"
                }
              }
            },
            "description": "The server timed out waiting for the request"
          },
          "429": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 429,
                      "message": "The request exceeded the limit of 100 times per apikey per minute. For more quota, please contact us: https://support.pingcap.com/hc/en-us/requests/new?ticket_form_id=7800003722519",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_countryResponse"
                }
              }
            },
            "description": "The user has sent too many requests in a given amount of time"
          },
          "500": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 500,
                      "message": "internal error! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getGithubRepoStargazers_countryResponse"
                }
              }
            },
            "description": "Internal server error"
          }
        },
        "summary": "/github/repo/stargazers_country",
        "tags": [
          "Default"
        ]
      }
    },
    "/hackernews/mentions_count": {
      "get": {
        "description": "Total counts for keyword in hackernews",
        "operationId": "getHackernewsMentions_count",
        "parameters": [
          {
            "in": "query",
            "name": "keyword",
            "schema": {
              "default": "",
              "example": "",
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_countResponse"
                }
              }
            },
            "description": "OK"
          },
          "400": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 400,
                      "message": "param check failed! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_countResponse"
                }
              }
            },
            "description": "Bad request"
          },
          "401": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 401,
                      "message": "auth failed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_countResponse"
                }
              }
            },
            "description": "Unauthorized request"
          },
          "404": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 404,
                      "message": "endpoint not found",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_countResponse"
                }
              }
            },
            "description": "The requested resource was not found"
          },
          "405": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 405,
                      "message": "method not allowed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_countResponse"
                }
              }
            },
            "description": "The requested method is not supported for the specified resource"
          },
          "408": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 408,
                      "message": "request timeout",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_countResponse"
                }
              }
            },
            "description": "The server timed out waiting for the request"
          },
          "429": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 429,
                      "message": "The request exceeded the limit of 100 times per apikey per minute. For more quota, please contact us: https://support.pingcap.com/hc/en-us/requests/new?ticket_form_id=7800003722519",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_countResponse"
                }
              }
            },
            "description": "The user has sent too many requests in a given amount of time"
          },
          "500": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 500,
                      "message": "internal error! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_countResponse"
                }
              }
            },
            "description": "Internal server error"
          }
        },
        "summary": "/hackernews/mentions_count",
        "tags": [
          "Default"
        ]
      }
    },
    "/hackernews/mentions_per_year": {
      "get": {
        "description": "keyword mentions per year in hackernews",
        "operationId": "getHackernewsMentions_per_year",
        "parameters": [
          {
            "in": "query",
            "name": "keyword",
            "schema": {
              "default": "",
              "example": "",
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_per_yearResponse"
                }
              }
            },
            "description": "OK"
          },
          "400": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 400,
                      "message": "param check failed! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_per_yearResponse"
                }
              }
            },
            "description": "Bad request"
          },
          "401": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 401,
                      "message": "auth failed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_per_yearResponse"
                }
              }
            },
            "description": "Unauthorized request"
          },
          "404": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 404,
                      "message": "endpoint not found",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_per_yearResponse"
                }
              }
            },
            "description": "The requested resource was not found"
          },
          "405": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 405,
                      "message": "method not allowed",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_per_yearResponse"
                }
              }
            },
            "description": "The requested method is not supported for the specified resource"
          },
          "408": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 408,
                      "message": "request timeout",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_per_yearResponse"
                }
              }
            },
            "description": "The server timed out waiting for the request"
          },
          "429": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 429,
                      "message": "The request exceeded the limit of 100 times per apikey per minute. For more quota, please contact us: https://support.pingcap.com/hc/en-us/requests/new?ticket_form_id=7800003722519",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_per_yearResponse"
                }
              }
            },
            "description": "The user has sent too many requests in a given amount of time"
          },
          "500": {
            "content": {
              "application/json": {
                "example": {
                  "type": "sql_endpoint",
                  "data": {
                    "columns": [],
                    "rows": [],
                    "result": {
                      "code": 500,
                      "message": "internal error! {detailed error}",
                      "start_ms": 0,
                      "end_ms": 0,
                      "latency": "",
                      "row_count": 0,
                      "row_affect": 0,
                      "limit": 0
                    }
                  }
                },
                "schema": {
                  "$ref": "#/components/schemas/getHackernewsMentions_per_yearResponse"
                }
              }
            },
            "description": "Internal server error"
          }
        },
        "summary": "/hackernews/mentions_per_year",
        "tags": [
          "Default"
        ]
      }
    }
  },
  "security": [
    {
      "basicAuth": []
    }
  ],
  "servers": [
    {
      "url": "https://us-west-2.data.tidbcloud.com/api/v1beta/app/dataapp-RfFKcZFu/endpoint"
    }
  ]
}

OSS Insight star history chart API

OSS Insight star history chart API.

  • GET /widgets/official/analyze-repo-stars-history/manifest.jsonRetrieve repository star history analysis

    Fetches the star history and analysis for specified repositories.

Schéma original API
{
  "openapi": "3.0.0",
  "info": {
    "title": "OSS Insight star history chart API",
    "version": "1.0.0",
    "description": "OSS Insight star history chart API."
  },
  "servers": [
    {
      "url": "https://next.ossinsight.io"
    }
  ],
  "paths": {
    "/widgets/official/analyze-repo-stars-history/manifest.json": {
      "get": {
        "operationId": "Star History",
        "summary": "Retrieve repository star history analysis",
        "description": "Fetches the star history and analysis for specified repositories.",
        "parameters": [
          {
            "name": "repo_id",
            "in": "query",
            "required": true,
            "description": "The ID of the primary repository.",
            "schema": {
              "type": "integer"
            }
          },
          {
            "name": "vs_repo_id",
            "in": "query",
            "required": true,
            "description": "The ID of the repository to compare with.",
            "schema": {
              "type": "integer"
            }
          }
        ],
        "responses": {
          "200": {
            "description": "Successful response with star history data.",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "imageUrl": {
                      "type": "string",
                      "format": "uri",
                      "description": "URL of the thumbnail image."
                    },
                    "title": {
                      "type": "string",
                      "description": "Title of the analysis."
                    },
                    "description": {
                      "type": "string",
                      "description": "Description of the analysis."
                    }
                  }
                }
              }
            }
          },
          "400": {
            "description": "Bad request - parameters missing or invalid."
          },
          "404": {
            "description": "Resource not found."
          },
          "500": {
            "description": "Internal server error."
          }
        }
      }
    }
  }
}

GitHub Repository Info API

An API for retrieving information about GitHub repositories.

  • GET /repos/{owner}/{repo}Get Repository Info

    Retrieve information about a GitHub repository.

Schéma original API
{
  "openapi": "3.0.0",
  "info": {
    "title": "GitHub Repository Info API",
    "description": "An API for retrieving information about GitHub repositories.",
    "version": "1.0.0"
  },
  "servers": [
    {
      "url": "https://api.github.com",
      "description": "GitHub API Server"
    }
  ],
  "paths": {
    "/repos/{owner}/{repo}": {
      "get": {
        "summary": "Get Repository Info",
        "description": "Retrieve information about a GitHub repository.",
        "operationId": "getRepositoryInfo",
        "parameters": [
          {
            "name": "owner",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "The username or organization name of the repository owner."
          },
          {
            "name": "repo",
            "in": "path",
            "required": true,
            "schema": {
              "type": "string"
            },
            "description": "The name of the repository."
          }
        ],
        "responses": {
          "200": {
            "description": "Successful response with repository information.",
            "content": {
              "application/json": {
                "schema": {
                  "type": "object",
                  "properties": {
                    "id": {
                      "type": "integer"
                    },
                    "name": {
                      "type": "string"
                    },
                    "full_name": {
                      "type": "string"
                    },
                    "owner": {
                      "type": "object",
                      "properties": {
                        "login": {
                          "type": "string"
                        },
                        "id": {
                          "type": "integer"
                        },
                        "avatar_url": {
                          "type": "string"
                        },
                        "html_url": {
                          "type": "string"
                        }
                      }
                    },
                    "private": {
                      "type": "boolean"
                    },
                    "description": {
                      "type": "string"
                    },
                    "fork": {
                      "type": "boolean"
                    },
                    "url": {
                      "type": "string"
                    },
                    "html_url": {
                      "type": "string"
                    },
                    "language": {
                      "type": "string"
                    },
                    "forks_count": {
                      "type": "integer"
                    },
                    "stargazers_count": {
                      "type": "integer"
                    },
                    "watchers_count": {
                      "type": "integer"
                    },
                    "size": {
                      "type": "integer"
                    },
                    "default_branch": {
                      "type": "string"
                    },
                    "open_issues_count": {
                      "type": "integer"
                    },
                    "topics": {
                      "type": "array",
                      "items": {
                        "type": "string"
                      }
                    },
                    "has_issues": {
                      "type": "boolean"
                    },
                    "has_projects": {
                      "type": "boolean"
                    },
                    "has_wiki": {
                      "type": "boolean"
                    },
                    "has_pages": {
                      "type": "boolean"
                    },
                    "has_downloads": {
                      "type": "boolean"
                    },
                    "has_discussions": {
                      "type": "boolean"
                    },
                    "archived": {
                      "type": "boolean"
                    },
                    "disabled": {
                      "type": "boolean"
                    },
                    "visibility": {
                      "type": "string"
                    },
                    "pushed_at": {
                      "type": "string",
                      "format": "date-time"
                    },
                    "created_at": {
                      "type": "string",
                      "format": "date-time"
                    },
                    "updated_at": {
                      "type": "string",
                      "format": "date-time"
                    },
                    "license": {
                      "type": "object",
                      "properties": {
                        "key": {
                          "type": "string"
                        },
                        "name": {
                          "type": "string"
                        },
                        "spdx_id": {
                          "type": "string"
                        },
                        "url": {
                          "type": "string"
                        }
                      }
                    }
                  }
                }
              }
            }
          }
        }
      }
    }
  }
}