This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have been using Google Maps API in my Alteryx workflow in order to get results with longitude and latitude for specific search queries, however, I am only able to get 20 results maximum per run while I am supposed to be getting 60 max.
I figured that the problem is that Google API shows 20 results per page and to access the next page you would have to use their next page token as seen in the picture below:
Unfortunately, I was not able to think of a way to add this to my workflow or my link.
If anyone is familiar or used Google API's before and was able to add this, please help!
@Faresghnaim You can also create a new column with the next_page_token in it. You can then create a final url in the formula tool into a download tool. This will grab the API response per line. You can then use the json parse tool to parse the json results to grab the actual lat/long.
Side note - Google maps API charges per request so depending on the the amount, the cost can really add up. Depending on the size of the data, you can think about the location insights dataset Alteryx offers.
@Faresghnaim additionally, you will want to set your number of iterations to 3. The Google Maps API can respond 60 results total, but in batches of 20 at a time. Therefore, it can iterate 3 times per query to return the full 60 results.