I am trying to build a master leaderboard for all 40+ Arena tournaments my chess club has held using Google Sheets. I have managed to get the URL for every tournament using ImportXML in Google Sheets. Now what I cannot figure for my life is how to get any data from the resulting arena tourney link. https://lichess.org/tournament/2bHOVix0
If I go directly to this link it downloads the Json file http://lichess.org/api/tournament/NguuB8pO/results
If I try to use the "ImportJSON" custom function I get a "unexpected token error". Am I supposed to add my Public Token to the link and if so how would I do that. Any help would be much appreciated.
-Mike
I am trying to build a master leaderboard for all 40+ Arena tournaments my chess club has held using Google Sheets. I have managed to get the URL for every tournament using ImportXML in Google Sheets. Now what I cannot figure for my life is how to get any data from the resulting arena tourney link. https://lichess.org/tournament/2bHOVix0
If I go directly to this link it downloads the Json file http://lichess.org/api/tournament/NguuB8pO/results
If I try to use the "ImportJSON" custom function I get a "unexpected token error". Am I supposed to add my Public Token to the link and if so how would I do that. Any help would be much appreciated.
-Mike