Hi! Welcome to RStudio Community!
Is the code you are using not working or are you looking for a more efficient solution? If the code is not working please share the error message that you are getting.
From the documentation of the
The amount of queries you can make to Google's APIs is dependent on both the service and the API you are using.
Each API has specific quotas and limits. Check Google's API documentation for details.
View your usage at the Google Cloud Console https://console.cloud.google.com/
Each API can only accept and return one request at a time. If you write a loop to make multiple API calls you should ensure you don't go over your quota / limits during the loop.
So if you are having issues with fulfilling all of your requests it is likely that it has to do with your allotted quota
In addition, it looks like your code was not formatted correctly to make it easy to read for people trying to help you. Formatting code allows for people to more easily identify where issues may be occurring, and makes it easier to read, in general. I have edited you post to format the code properly.
In the future please put code that is inline (such as a function name, like
filter) inside of backticks (
`mutate`) and chunks of code (including error messages and code copied from the console) can be put between sets of three backticks:
example <- foo %>%
filter(a == 1)
This process can be done automatically by highlighting your code, either inline or in a chunk, and clicking the
</> button on the toolbar of the reply window!
This will help keep our community tidy and help you get the help you are looking for!
For more information, please take a look at the community's FAQ on formating code