nba_api VS ImportJSON

Thanks to the people putting together the open source nba_api, as well as the people at Basketball Reference and the NBA stats page.

NBA Stats API

Yea ref stuff is hard to acquire. NBA api could b helpful tho and this is prob a good place to start

I think you'll find this useful: https://github.com/swar/nba_api.

All data were collected using the nba_api. The dataset consists of per-game stat averages for all teams starting from the 1983-84 season through the 2021-22 season. In total: 1103 regular season teams, 624 of which made the playoffs in their respective years. Traditional stats include: PTS, FGM, FGA, FG_PCT, FG3M, FG3A, FG3_PCT, FTM, FTA, FT_PCT, OREB, DREB, REB, AST, STL, BLK, TOV, PF, PLUS_MINUS. Advanced stats include: NET_RATING, OFF_RATING, DEF_RATING, EFG_PCT, TS_PCT, PACE, OREB_PCT, DREB_PCT, REB_PCT, AST_PCT, AST_TO, AST_RATIO, TM_TOV_PCT. Note: for plus/minus and all of the advanced stats, I could only get data beginning from the 1997-98 season onwards, which resulted in 743 total regular season teams, 400 of which made the playoffs.

Is it not on the nba api? https://github.com/swar/nba_api/tree/master/docs/nba_api/stats/endpoints

The following scripts leverage the UrlFetchApp library and are less likely to cross rate limits at the scale you're operating at. I'd start with importRegex but if that doesn't work try the much more powerful ImportJSON

I use ImportJSON to put it the sheet: https://github.com/bradjasper/ImportJSON

You may also be able to use something as simple as the import json custom function https://github.com/bradjasper/ImportJSON

Here's a link to the GitHub repo: https://github.com/bradjasper/ImportJSON/blob/master/ImportJSON.gs

Thanks for the tip, I'll try running just one script and see if that fixes it. As far as precision, I'm using a free script created by Brad Jasper and it works great. https://github.com/bradjasper/ImportJSON/blob/master/ImportJSON.gs

are you talking about Brad jasper's custom function?

I've been using the public api https://www.pathofexile.com/character-window/get-characters?&accountName=vindoq to get my characters on a google spread sheet and it doesn't work anymore since a little more than one month (using a third party script : https://github.com/bradjasper/ImportJSON). I've been trying to get around it using my own github project (https://github.com/antilogos/SimpleFiltre/blob/master/DataTranslate/characters.html) to try getting the content of the public api with an additional step, using github.io, but the fetch is receiving a null body in the response (https://antilogos.github.io/SimpleFiltre/DataTranslate/characters.html).