ImportJSON VS dataconnector

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

I haven't looked at Data Studio in particular but for Google Analytics and other Google data sources you have to use OAuth2 so I'm guessing Data Studio would be the same. There's an OAuth2 library for apps script and you can see how we used it in our code (using React): https://github.com/brentadamson/dataconnector