ImportJSON VS AmeritradeAPIwGoogleScripts

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

Ameritrade If you have a Think Or Swim you can use Ameritrade's API. I'm a dumb dumb, so I really don't know how this all works, but I used a script written by Koh Joo Beng and was able to get it to work. https://www.youtube.com/watch?v=_KJsx7QD6dM https://github.com/kohjb/AmeritradeAPIwGoogleScripts