A RuPaul's Drage Race API for accessing all the queens, and all the seasons for the beloved show. This API is deployed live here!
This api was almost written entirely in JavScript use the following libraries and frameworks
- Node.js
- Express.js
- Knex
- Postgresql for database management
Use this api to get a list of all numerical seasons of RuPaul's Drag Race (Allstar seasons not included). See all the queens and which season they participated in. Endpoints and their corresponding responses are listed below:
GET all the queens
example request : GET /api/v1/queens
example response:
[
{
"name": "Victoria `Porkchop' Parker",
"queen_id": 1,
"winner": false,
"miss_congeniality": false,
"quote": "Would you do me? I'd do me.",
"season": 1,
"season_id": 1,
"created_at": "2019-11-21T20:20:24.538Z",
"updated_at": "2019-11-21T20:20:24.538Z"
},
{
"name": "Tammie Brown",
"queen_id": 2,
"winner": false,
"miss_congeniality": false,
"quote": "I'm not a slut, I'm a lady. You look under my skirt, and it will stick you in the eye though.",
"season": 1,
"season_id": 1,
"created_at": "2019-11-21T20:20:24.540Z",
"updated_at": "2019-11-21T20:20:24.540Z"
},
{..}
] GET all the seasons
example request : GET /api/v1/seasons
example response:
[
{
"id": 1,
"number": 1,
"winner": "Bebe Zahara Benet",
"image_url": "https://vignette3.wikia.nocookie.net/logosrupaulsdragrace/images/8/81/Rpdr_season1.jpg",
"created_at": "2019-11-21T20:20:24.515Z",
"updated_at": "2019-11-21T20:20:24.515Z"
},
{
"id": 2,
"number": 2,
"winner": "Tyra Sanchez",
"image_url": "https://vignette1.wikia.nocookie.net/logosrupaulsdragrace/images/c/c0/Season2cast.png",
"created_at": "2019-11-21T20:20:24.519Z",
"updated_at": "2019-11-21T20:20:24.519Z"
},
{
"id": 3,
"number": 3,
"winner": "Raja",
"image_url": "https://vignette2.wikia.nocookie.net/logosrupaulsdragrace/images/e/e7/RPDRS3.jpg",
"created_at": "2019-11-21T20:20:24.521Z",
"updated_at": "2019-11-21T20:20:24.521Z"
},
{..}
] GET a specific queen using their queen_id
example request : GET /api/v1/queens/49
example response:
{
"name": "Vivacious",
"queen_id": 49,
"winner": false,
"miss_congeniality": false,
"quote": "Liza Minelli lies.",
"season": 6,
"season_id": 6,
"created_at": "2019-11-21T20:20:24.571Z",
"updated_at": "2019-11-21T20:20:24.571Z"
} GET a specific season using its id
example request : GET /api/v1/season/10
example response:
{
"id": 10,
"number": 10,
"winner": "Aquaria",
"image_url": "https://vignette.wikia.nocookie.net/logosrupaulsdragrace/images/a/af/RPDR_S10_Banner.jpeg",
"created_at": "2019-11-21T20:20:24.535Z",
"updated_at": "2019-11-21T20:20:24.535Z"
}Adding a new queen to the database
example request : POST /api/v1/queens
body: (must be in JSON)
{
"name": "Virginia Beach",
"winner": false,
"miss_congeniality": false,
"quote": "Life's a beach",
"season": 10
}example response:
{
"queen_id": 154,
"name": "Virginia Beach",
"winner": false,
"miss_congeniality": false,
"quote": "Life's a beach",
"season": 10,
"season_id": 10
}| Key | Datatype |
|---|---|
| name | <string> |
| winner | <boolean> |
| miss_congeniality | <string> |
| season | <integer> |
| quote | <string> |
The body of the request above MUST be in JSON format
Adding a new season to the database
example request : POST /api/v1/seasons
body: (must be in JSON)
{
"number": 20,
"winner": "Bianca del Rio",
"image_url": "logos.com/log.png"
}example response:
{
"id": 14,
"number": 20,
"winner": "Bianca del Rio",
"image_url": "logos.com/log.png"
}Required properties for the season object in the body of the request:
| Key | Datatype |
|---|---|
| number | <integer> |
| winner | <string> |
| image_url | <string> |
The body of the request above MUST be in JSON format
Removing a queen from the database using their queen_id
example request : DELETE /api/v1/queens/:queen_id
example response:
"Queen with queen_id of 155 successfully deleted"If you have come across any issues or have questions about my process, you can how see issues are tracked, and the workflow was handled at the GitHub Projects Page for this API.