API Question
-
Hi, I'm trying to access the API (Item) using Excel but I'm only getting a null JSON file. Is there anyone out there that is willing to help me figure out what I'm doing wrong?
This is the address I'm using for the query:
https://mlb21.theshow.com/apis/item.json?uuid=bb00d1c8cf377a49b8e5bac839ced4e9
-
Okay - I switched to the Items API because I realized the uuid is the primary key for a single card. I was able to download the first page of the data (I guess there are 98 pages?) and was able to open it in Firefox to view the data. Now...how do I get that into Excel? Tab delimited?
-
Okay...again. I was able to open an Items JSON file in Excel and get it into a table. Is there a way to get Excel to pull the data automatically so I don't have to download all 98 pages and import them individually after each roster update?
-
Using a VBA macro inside your Excel document to parse the JSON into the columns and rows your desiring or a manual approach might be using one of the free online JSON to CSV/Excel tools then manually load it back into Excel. Hope this helps!
-