Re: nhl 21 api for stats?

You’re welcome! PM me and maybe I can help you take it a step further. I signed up for a free online database where I store my data at jsonbin.io. Once saved there you can at least have an archive.

@GeorgeandpfunkI attempted to PM you but receive an access denied page.

Similar to what others are doing, I have a project (python/postgresql/flask) going to mess with the JSON data from match history. Was wondering if you would be interested in providing some guidance parsing the JSON data?

Of course! I sent you one that seems to have worked, let me know if you got it 

hey, i was wondering if you would be able to point me in the right direction. I converter the json to xml, then used gist for url so that i could importxml in google sheets. I cant figure out how to have the objects listed along with the values. Its just values only.

I would skip the conversion to xml and read this regarding tabulating json data in google sheets. I honestly don’t know much about parsing xml.

https://www.google.com/amp/s/blog.coupler.io/how-to-import-json-to-google-sheets-without-coding/amp/

So did a bunch of learning and actually got it to work pretty nicely using google sheets. Using an add on to fetch the api, and a butt load of formulas to get the data appealing. I also made image buttons so teams can actually do it themselves. Then the league doesnt want to because they are worried something might happen, told them it would never be a big issue, but they are computer illiterate.

Fist shot is the api data collector in its own work book. Then i import the range for the specific team, followed by a bunch of query functions to filter by date state category and combine that data incase of lagouts. This page wont be seen by user, runs in back ground. Then last shot is the one users will see and they only have to click the images.