Hi all,
I want to be able to use Google Maps API Place data within an app.
I have got a Google Maps API key and am able to ācallā data using a URL - see example below that grabs the rating of a place.
I want to be able to display things like the Google rating of a place within an app but donāt know how to do this with the information I can grab via a URL.
I have seen examples on-line that create a Google Script to extract this data but Iām trying to avoid using scripts (mainly as I donāt want to add things into my app that I canāt fix if they go wrong!). And also Iām not sure if you can legally store Google Maps Data.
Any help appreciated
I think it does. Does that make the output more useable?
Yeah, I imagine it can work with a custom function called importJSON.
Thanks. Iāll have a play to see what that custom function provides and what I can extract from it.
1 Like
Hi.
I have managed to get the IMPORTJSON function to work but only when I insert the URL dorectly into the IMPORTJSON formula.
I want to reference the URL from another column and when I reference a column within the array formula the IMPORTJSON function comes back with a āError getting dataā message.
Copy of formula below.
Any help appreciated.
=ArrayFormula(IF(ROW($A:$A)=1,āRatingā, IF(AE:AE="","",IMPORTJSON(HYPERLINK(CHAR(34)&AF:AF&CHAR(34)),āresult/ratingā))))
I probably wouldnāt use the HYPERLINK function. All it needs is the url text.
Thanks. I did also try it without the hyperlink part and it came up with the same.
=ArrayFormula(IF(ROW($A:$A)=1,āRatingā, IF(AE:AE="","",IMPORTJSON(CHAR(34)&AF:AF&CHAR(34),āresult/ratingā))))