Re: nhl 21 api for stats?

Thanks for the tip!  This works great on getting the club data.  I was wondering... Do you know what the URL is to get data from Private Match history? https://www.ea.com/games/nhl/nhl-21/pro-clubs/match-history?clubId=39855&platform=ps4

For our WoCHL league it would be great if I could import all of the games with date/timestamp and select the game that was the scheduled season game - and then import that data only.  

Any ideas would be VERY helpful!

@lounatic99 Glad I could help!

I haven't tried to do anything besides individual stats - your post is the first I'm hearing of the possibility for match history. Did some playing and digging and was able to get the matchHistory call to work. I haven't looked at the data beyond a quick scroll through it:

curl --referer www.ea.com "https://proclubs.ea.com/api/nhl/clubs/matches?clubIds=39855&platform=ps4&matchType=gameType10"

I found on Reddit that gameType10 is playoffs and gameType5 is regular season. Hopefully that helps you. Let me know if you come up with anything else.

@Georgeandpfunk thank you so much!  This is great.  It solves for the Regular and Playoff matches - but any idea how to get the Private match data?  See attached.  Again, thank you so much!

@lounatic99 I'm sorry, I haven't solved for that. Have you looked into the data from matchType5 and matchType10 to confirm that the private matches you've played don't show up there? It looks like these only return the last five games played in each category. I tried plugging in "matchType0" through "matchType20" and 5 & 10 are the only two that have worked. Maybe a dumb question but can you view your private match history in the NHL 21 app? I'm curious whether EA even record that data on their servers.

I found a project on github from 2016 that seems to imply you can specify the number of matches to return in your results, but haven't gotten that to work yet either.

@lounatic99 You’re welcome. Curious which page source you inspected to find that? I really would like to see if the match history data can return more than five games.

Thanks for the tips guys, will work on this for my team. Already lost track of this ticket!

Did you ever find a way to see more than the last five matches?

Got it.  I was hoping to get the entire history, but I guess getting the info for games moving forward will have to do.  Thanks!

I'm looking to find data on Players but without having the ClubID. Basically just pulling the data from this page: https://www.ea.com/games/nhl/nhl-21/pro-clubs/players

When I viewed source I found this URL https://proclubs.ea.com/api/nhl/members/search but I can't figure out the rest to return the user data. Any help would be appreciated!

I am trying to figure out a way to essentially scrape all the club match history into a google sheet. I am super new to coding and this whole curl and query java script. If you could let me toward the right direction that would be great!

Match history is challenging because you can only get the last five results, so you’ll have to archive the data every five games or less.

You can open a command prompt in windows and simply copy and paste the cURL command above, substituting your team ID. Obtain your team ID by searching for your club on the official EASHL ranking page. You also have to change the match type in the command to either 10 or 5. 5 is for normal games and 10 is for the club championship games (I think the window for those just closed)

The data comes back as a JSON string which you can paste into a JSON formatter online to see how the data is structured.

Also, you can save the data as a file with a .json extension and excel can process it for you; but I haven’t spent much time doing that myself 

So i took your idea and went a different route a bit and it worked. I want to thank you from the bottom of my heart for helping me out with this. There is only one small problem which I need to work on. All of this is manual. I am trying to look up a script where it can do this for me automatically. Thank you for leading me in the right place with your line code. This is helped the league I'm a part of out a ton! 

here is the URL to the google sheets doc https://docs.google.com/spreadsheets/d/1Uk8hVjL0yCxU4u7Xt5NqHRnsNLB9QXPSmY9RqNELe6k

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.

Anyone know how to do api stats as I'd like to do it for a 30 us team league that has been going for 12 seasons any help be greatly appreciated. Is there a cost or is it free any derails be awesome 

Hey,
I was reading threw the threads, and I also was wondering if anyone has found out how to get the raw date out of private matches only for a league that I'm in?

Thanks