ImportJSON VS Hoppscotch

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

How can Hoppscotch help you intercept the API calls? 👽

We need you help to constantly improve Hoppscotch so that we can make it easier for you to build better software! Write to us at [email protected] or head over to our GitHub repository if you have any feedback about Hoppscotch 💚!

For the past five years, Hoppscotch 🛸 has been quietly transforming the way developers tackle their work in the API development world. Our mission has always been to make developer's lives easier and their workflows smoother, all from the comfort of their browser. And guess what? We might have evolved and gotten strong, but we are staying true to our goal of simplifying things for developers everywhere. Today, we're here to spill the beans on the simple yet powerful productivity hacks that Hoppscotch offers. Get ready to level up your development game in ways you never imagined.

Hoppscotch is a powerful yet simple-to-use API testing suite. It removes a lot of complexity, making it easy for anyone to get started with API testing. Try Hoppscotch now!

Hoppscotch - HTTP client used for sending notifications through the Google API.

We began as a web-based API client at hoppscotch.io, where anyone can easily initiate API testing. Ever since then the Hoppscotch Desktop app has been a highly requested product by our community. We've been listening and are excited to announce that the day has finally arrived - today marks the launch of the public alpha version of the Hoppscotch Desktop App for macOS, Windows, and Linux!

We’re building an open-source Postman alternative.

1.6m+ users, 100k+ monthly active users, 55k+ GitHub stars.

Web app: https://hoppscotch.io

The collective efforts and commitment of our team has led Hoppscotch towards remarkable improvements on its path to transforming the API development ecosystem. But, the speed of evolution we've experienced wouldn't have been possible without the open-source nature of Hoppscotch. A significant portion of our success is attributed to our dedicated contributors who have resolved existing issues, filed bug reports, authored blogs, created tutorials, and spread the word about Hoppscotch within their networks 🤝 .