DayTimeSeby
New Member
- Joined
- May 15, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
That title was quite the task to try to summarize.
I have an ever increasing amount of API keys I can call upon of which each one, obviouslly, has some rate limitting set out on it.
I am looking for a solution/ formula particularly, where I can pull an API key to utilize in my overal project... if said project is required to continue then have the formula to pull a random API key from the collection of keys that I already posses, making sure that that new key hadn't been run in the last 3minutes. By "run", I mean me refreshing the sheet or setting something that loops until the data required is returned complettelly.
The "fresh" API key just gets added to the end of a link, like so(an example, not the real url):
https://somesite.io/?yipey=kaiAye&?yipay/eye/oh?=inthesky-API&=(xxxxxxxxxx API Key here xxxxxxxxx)
I have an ever increasing amount of API keys I can call upon of which each one, obviouslly, has some rate limitting set out on it.
I am looking for a solution/ formula particularly, where I can pull an API key to utilize in my overal project... if said project is required to continue then have the formula to pull a random API key from the collection of keys that I already posses, making sure that that new key hadn't been run in the last 3minutes. By "run", I mean me refreshing the sheet or setting something that loops until the data required is returned complettelly.
The "fresh" API key just gets added to the end of a link, like so(an example, not the real url):
https://somesite.io/?yipey=kaiAye&?yipay/eye/oh?=inthesky-API&=(xxxxxxxxxx API Key here xxxxxxxxx)
Last edited by a moderator:
