documentation - google places xml in google docs -
i have xml google places, analyze in google docs. xml looks that
<autocompletionresponse> <status>ok</status> <prediction> <description> chinatown restaurant, washington street, san francisco, ca, united states </description> <type>establishment</type> <reference>...</reference> <id>9bcb9788e5e5f0c5713da18f8075eee2c07024e1</id> <term>...</term> <term>...</term> <term>...</term> <term>...</term> <term>...</term> <matched_substring>...</matched_substring> </prediction> <prediction>...</prediction> <prediction>...</prediction> <prediction>...</prediction> <prediction>...</prediction> </autocompletionresponse>
but error command. insteade of mysecretid, use api key google.
=importxml("https://maps.googleapis.com/maps/api/place/autocomplete/xml?input=restaurant&types=establishment&location=37.76999,-122.44696&radius=500&sensor=true&key=mysecretkey", "//prediction[@description='"&indirect("a"&row())&"']/item")
Comments
Post a Comment