I was toying with the idea of building a master searchable database/list. There is a decent one at: https://www.wow-petguide.com/Collection but it doesn’t give breed specific stats. There is another through the interface at warcraftpets.com, but the pet search doesn’t give stats and ability tags can only be stacked.
I can use Python, but the API doesn’t seem to indicate that it’s a possibility to get all the info I need (if it does somewhere, I’ve missed it).
For example, I’d like the ability to quickly search for all pets that have a Dodge or Decoy and still have an undead attack. If the info is listed somewhere, I can build a small database that can allow the user to make ad hoc queries (in MS Access or Python, for instance), but I just need to know where all this info is listed. I could scrape it off of wowhead, but that looks painful.
Any ideas would be appreciated.
I think you’re missing something here.
Xu-Fu’s spreadsheet gives Base stats and available breeds. The rest is just formulae.
You will find the API documantation for pets and everything else WoW here: https://develop.battle.net/documentation/world-of-warcraft
That’s where Xu-Fu gets the data.
2 Likes
Ah, I see it now – I was glossing over the base stat columns, but you’re right - I just need to apply the formulas and add a delimiter to all the breeds in the “Available Breed” columns to add entries for all possible breeds.
I can refresh the app I make from an automated import from this sheet. I’ll take another look at the api documentation too eventually, but this is enough for me to get my app started. Thanks!! I can’t believe I missed that.
2 Likes