Pony API

Finally, the REST API for information about your favorite animated series - My Little Pony: Friendship is Magic.

Manually corrected data mined from MLP fandom wiki. Last update on April 30, 2020.

http://ponyapi.net/v1/
Download SQLite DB Download API source files

Character

Get name, images, kind, occupation, residence and more. You can search based on many properties (name, kind, occupation and residence) or get all characters.

Episode

Get name, thumbnail image, airdate, authors and more. You can search based on name, season, overall episode, authors or get all episodes.

Song

Get name, length, authors, key signatures, video url, wiki url and more. You can search based on name, episode and authors or get all songs.

Comics story

Get name, authors, cover image url, wiki url, which issues it contains and more. You can search based on name, series and issue number, authors or get all comics stories.

Kind

Minor feature. For developmental usage.
Get name, comment and wiki url.

Image

Minor feature. For developmental usage.
Get image name, description and url.

Comics issue

Minor feature. For developmental usage.
Get comics issue name, annotation, publishing date, etc.

Changelog

2020-04-30

2020-04-14

2020-04-10

2020-04-05

2020-04-02

2020-03-29

Documentation

Global behavior

Every string search is based on SQL case insensitive LIKE query. If the string is not clearly specified, every result that contain the query is returned.

Response 

{
  "status": 200,
  "data": [],
  "warning": "warning message",
  "error": "error message"
}

HTTP status codes

Pony API returns these HTTP codes:

Global parameters

Character

Response 

"data": [
  {
    "id": 1,
    "name": "Twilight Sparkle",
    "alias": "Princess Twilight Sparkle",
    "url": "https://mlp.fandom.com/wiki/Twilight_Sparkle",
    "sex": "Female",
    "residence": "Canterlot (S1E1, S9E26)\nCastle of Friendship, Ponyville (seasons 5-9)\nGolden Oak Library, Ponyville (seasons 1-4)\nCrystal Princess Palace (toy line)",
    "occupation": "Ruler of Equestria (S9E26)\nFounder/leader of the Council of Friendship (S9E26)\nRuler of the Castle of Friendship (S4E26-S9E26)\nFounder/principal of the School of Friendship (S8E1-S9E20)\nStarlight Glimmer's teacher (S5E26-S7E1)\nGolden Oak Library librarian (seasons 1-4)\nPrincess Celestia's student (seasons 1-3)\nStudent at Celestia's School for Gifted Unicorns (formerly)",
    "kind": [
      "Alicorn",
      "Unicorn",
      "Human"
    ],
    "image": [
      "https://vignette.wikia.nocookie.net/mlp/images/b/bc/Princess_Twilight_Sparkle_ID_S4E26.png/revision/latest?cb=20160207045127",
      "https://vignette.wikia.nocookie.net/mlp/images/6/6c/Twilight_S2E25_cropped.png/revision/latest?cb=20160315121005",
      "https://vignette.wikia.nocookie.net/mlp/images/9/97/Twilight_filly_crop_S2E25.png/revision/latest?cb=20140108015837",
      "https://vignette.wikia.nocookie.net/mlp/images/1/18/Twilight_Sparkle_infant_ID_MLPS2.png/revision/latest?cb=20190823095629",
      "https://vignette.wikia.nocookie.net/mlp/images/e/ef/Future_Twilight_Sparkle_ID_S9E26.png/revision/latest?cb=20191013013633",
      "https://vignette.wikia.nocookie.net/mlp/images/0/0c/Twilight_Sparkle_human_at_lockers_EG.png/revision/latest?cb=20141211040145"
    ]
  }
]

Query type

Parameters

Episode

Response 

"data": [
  {
    "id": 136,
    "name": "The Fault in Our Cutie Marks",
    "image": "https://vignette.wikia.nocookie.net/mlp/images/2/23/CMC_moving_their_legs_and_Gabby_moving_her_body_as_the_song_begins_S6E19.png/revision/latest?cb=20160911170309",
    "url": "https://mlp.fandom.com/wiki/The_Fault_in_Our_Cutie_Marks",
    "season": 6,
    "episode": 19,
    "overall": 136,
    "airdate": "2016-09-10",
    "storyby": "Josh Haber\nMeghan McCarthy",
    "writtenby": "Ed Valentine",
    "storyboard": "Karine Charlebois\nPatricia Ross\nNicole Wang",
    "song": [
      "Find the Purpose in Your Life"
    ]
  }
]

Query type

Parameters

Song

Response 

"data": [
  {
    "id": 21,
    "name": "Find A Pet Song",
    "video": "https://youtube.com/watch?v=eutPvpczpLY",
    "length": "00:03:40",
    "url": "https://mlp.fandom.com/wiki/Find_A_Pet_Song",
    "episode": "May the Best Pet Win!",
    "musicby": "Daniel Ingram\nSteffan Andrews (orchestration)",
    "lyricsby": "Charlotte Fullerton\nKevin Rubio",
    "keysignature": "D-flat major\nB major"
  }
]

Query type

Parameters

Comics story

Response 

{
  "status": 200,
  "data": [
    {
      "id": 7,
      "name": "Reflections",
      "series": "My Little Pony: Friendship is Magic",
      "image": "https://vignette.wikia.nocookie.net/mlp/images/6/6f/IDW_comics_issue_18-19_combined.png/revision/latest?cb=20140219194058",
      "url": "https://mlp.fandom.com/wiki/Reflections",
      "writer": "Katie Cook\nMatt Anderson (#19 pp. 26-29)",
      "artist": "Andy Price\nKatie Cook (#17 pp. 23-24, #18 pp. 23-24, #19 pp. 23-24, #20 pp. 24-25)\nAntonio Campo (#19 pp. 26-29)",
      "colorist": "Heather Breckel\nDiego Rodriguez (#19 pp. 26-29)",
      "letterer": "Neil Uyetake\nTom B. Long (#19 pp. 26-29)",
      "editor": "Bobby Curnow",
      "issue": [
        17,
        18,
        19,
        20
      ]
    }
  ]
}

Query type

Parameters

issue=id/number/full, series=none/id/name

Kind

Response 

{
  "status": 200,
  "data": [
    {
      "id": 1,
      "name": "Alicorn",
      "url": "https://mlp.fandom.com/wiki/Alicorns",
      "comment": "(S9E24-S9E25)"
    }
  ]
}

Query type

Image

Response 

{
  "status": 200,
  "data": [
    {
      "id": 821,
      "name": "Lavender Bloom",
      "url": "https://vignette.wikia.nocookie.net/mlp/images/7/77/Lavender_Bloom_ID_S8E4.png/revision/latest?cb=20180419170234",
      "comment": "Lavender Bloom in Fake It 'Til You Make It"
    }
  ]
}

Query type

Comics issue

Response 

{
  "status": 200,
  "data": [
    {
      "id": 158,
      "issue": 2,
      "story": "Ponyville Mysteries Issue 2",
      "date": "2018-06-20",
      "annotation": "There's a major mystery at the... bowling alley? Ponyville's team is set to break a bowling record, but the alley keeps being ransacked by a mystery criminal! Will the Cutie Mark Crusaders be able to set the pins right and solve the caper?"
    }
  ]
}

Query type

Parameters

License

Database

Because the data comes from the MLP fandom wiki, this database is licensed under CC BY-SA 3.0.

Source files

Source files of this API is licensed under MIT license.

Contact

If you have any question, idea or you want to contribute, send me an email to cloudcolt@protonmail.com.