| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||
2 | Choose Language | English (United States) | enUS | Example | ||||||||||
3 | "id": "EX1_116", "dbfId": 559, "name": "Leeroy Jenkins", "text": "<b>Charge</b>. <b>Battlecry:</b> Summon two 1/1 Whelps for your opponent.", "flavor": "At least he has Angry Chicken.", "artist": "Gabe from Penny Arcade", "attack": 6, "cardClass": "NEUTRAL", "collectible": true, "cost": 5, "elite": true, "faction": "ALLIANCE", "health": 2, "mechanics": [ "BATTLECRY", "CHARGE" ], "rarity": "LEGENDARY", "set": "EXPERT1", "type": "MINION" | |||||||||||||
4 | Script: | Import JSON Script can be found here: | ||||||||||||
5 | https://github.com/bradjasper/ImportJSON | |||||||||||||
6 | API: | Hearthstone JSON Repository for Collectible Cards: | ||||||||||||
7 | https://api.hearthstonejson.com/v1/latest/enUS/cards.collectible.json | |||||||||||||
8 | Documentation: | The strings used for each part of the data can be found here: | ||||||||||||
9 | https://hearthstonejson.com/docs/cards.html | |||||||||||||
10 | Notes: | On "Output" I capped the ArrayFormulas at 1750 rows. This shouldn't be exceeded until Spring 2019 Set Release. Should be able to do a CTL+F on Row 2 to update. | ||||||||||||
11 | ||||||||||||||
12 | Purchaseable Hero Skins are part of the data set as are Basic. Can't fix. | |||||||||||||
13 | Update Table Output:B2 when new set name is released | |||||||||||||
14 | Have to check Table B33 for new Mechanics when new set is relased. Will be added on the bottom of the table. If values exceed current table, update OutputAA2 to expand table. | |||||||||||||
15 | ||||||||||||||
16 | ||||||||||||||
17 | ~ Created by /u/cgmcnama | |||||||||||||
18 | ||||||||||||||
19 | ||||||||||||||