IMPORTJSONAPI VS ImportJSON

You can access the API with IMPORTJSONAPI or a custom script.

I used https://github.com/qeet/IMPORTJSONAPI to bring it in to Google Sheets -- but there are a lot of ways to get it.

IMPORTJSONAPI or just a direct API call with Apps Script would probably be easier.

IMPORTJSONAPI has graphQL support.

Try IMPORTJSONAPI() and this url:

Well you can check out https://github.com/qeet/IMPORTJSONAPI as a script solution. Or just grab the data yourself with UrlFetchApp.

You can use tcgplayers api (https://docs.tcgplayer.com/docs/getting-started) and IMPORTJSONAPI (https://github.com/qeet/IMPORTJSONAPI)

Use https://github.com/qeet/importjsonapi. However, that url seems to require a url key or some form of authentication so you'll have to pass those parameters.

I usually use this script for interacting with APIs: https://github.com/qeet/IMPORTJSONAPI/

I also tried using the IMPORTJSONAPI from https://github.com/qeet/importjsonapi but I am not sure if I can find the correct path and parameters.

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).