Jump to content
Sign in to follow this  
iamtheky

JSON queries for Google API

Recommended Posts

iamtheky

The following is an example that fetches name/address/phone number for places of your criteria. If you needed to poll many different locations and aggregate the data, a solution as such may prove useful.

As always my hopes is that people see this pile i left, fix the inefficiencies, and the result weeks from now is far finer than this initial offering.

You need an API key from google (which is free), in your api console make sure you kick on both maps and places

and JSMN from

#Include "JSMN.au3"
#Include <Array.au3>
#Include <File.au3>

Global $aFarray
Global $aDarray

$input1 = inputbox("What Place?" , "Enter the Place Name or Type of Place" , "University")
$input2 = inputbox("Where At?" , "Enter the Zip or City" , "76504")
$radius = inputbox("Prioritize Returns" , "Priority is given to places within this many meters" , "10000")
$sInputs = $input1 & " " & $input2
$location = stringreplace($sInputs , " " , "+")

Local $Json = BinaryToString(InetRead("https://maps.googleapis.com/maps/api/place/textsearch/json?query=" & $location & "&radius=" & $radius & "&sensor=false&key=YourKeyHere"), 4)
Local $Obj = Jsmn_Decode($Json)

$file = fileopen(@ScriptDir & "\JSON_RADIUS_OUTPUT.txt" , 2)
filewrite($file , Jsmn_Encode($Obj, $JSMN_PRETTY_PRINT))
fileclose($file)

_FileReadToArray(@ScriptDir & "\JSON_RADIUS_OUTPUT.txt" , $aFarray)

;~ _ArrayDisplay($aFarray)

For $i = $aFarray[0] to 1 step -1
If stringinstr($aFarray[$i] , '"formatted_address": ') or stringinstr($aFarray[$i] , '"name": ') or stringinstr($aFarray[$i] , '"reference": ') Then
ContinueLoop
Else
_ArrayDelete($aFarray , $i)
Endif
next

_ArrayDelete($aFarray , 0)

For $i = 2 to ubound($aFarray) - 1 step 3
$aFarray[$i] = stringtrimright(stringtrimleft($aFarray[$i], 17),2)
Local $Json2 = BinaryToString(InetRead("https://maps.googleapis.com/maps/api/place/details/json?reference="& $aFarray[$i] &"&sensor=false&key=YourKeyHere"), 4)
Local $Obj2 = Jsmn_Decode($Json2)

$file = fileopen(@ScriptDir & "\JSON_Details_OUTPUT.txt" , 2)
filewrite($file , Jsmn_Encode($Obj2, $JSMN_PRETTY_PRINT))
fileclose($file)

_FileReadToArray(@ScriptDir & "\JSON_Details_OUTPUT.txt" , $aDarray)

For $j = 1 to $aDarray[0]
If stringinstr($aDarray[$j] , '"formatted_phone_number": ') Then
$aFarray[$i] = stringtrimright(stringtrimleft($aDArray[$j], 29),2)
Endif
next

Next

$results = Fileopen(@ScriptDir & "\results.txt" , 2)

for $k = 0 to ubound($aFArray) - 1 step 3
filewrite($results , stringtrimright(stringtrimleft($aFArray[$k+1], 12),2))
filewrite($results , @CRLF)
filewrite($results , stringtrimright(stringtrimleft($aFArray[$k], 25),2))
filewrite($results , @CRLF)
filewrite($results , $aFArray[$k+2])
filewrite($results , @CRLF)
filewrite($results , @CRLF)
Next

FileClose ($results)
shellexecute(@ScriptDir & "\results.txt")
Edited by boththose
  • Like 1

,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • Burgs
      By Burgs
      Hello,
        I have a website with a Google Map I setup using the Google Map API.  It works and displays just fine.  However to make it useful to me I need to be able to dynamically change the map to display different areas by sending new Latitude and Longitude coordinates.  I am having difficulty making this happen.  Here is my code thus far:
      #include <IE.au3> $oIE3 = _IECreate("http://my_sample_website.html") ;just an example, not an actual site... _IELoadWait($oIE3) $s_word = "lat:" $oInputs = _IETagNameAllGetCollection($oIE3) if @error <> 0 Then MsgBox($MB_SYSTEMMODAL, "ERROR", "Error is: " & @error) EndIf ;@error For $oInput In $oInputs if Number($iPos) == -1 Then $iPos = StringInStr($oInput.innerHTML, String($s_word)) if (Number($iPos) > 0) AND (@error == 0) Then ConsoleWrite("I FOUND IT...! " & String($s_word) & @CRLF) $sHTML = _IEBodyReadHTML($oIE3) $_lat_look = 0 $_lng_look = 0 $_end_look = 0 ;default $_lat_look = StringInStr(String($sHTML), "lat:") if Number($_lat_look) <> 0 Then $_lng_look = StringInStr(String($sHTML), "lng:") if Number($_lng_look) <> 0 Then $_end_look = StringInStr(String($sHTML), "}") if Number($_end_look) <> 0 Then ConsoleWrite("HTML BODY: " & $sHTML & @CRLF) $_old_lat = String(StringMid(String($sHTML), $_lat_look, ($_lng_look - $_lat_look))) $_old_lng = String(StringMid(String($sHTML), $_lng_look, ($_end_look - $_lng_look))) ConsoleWrite("$_old_lat: " & $_old_lat & @CRLF) ConsoleWrite("$_old_lng: " & $_old_lng & @CRLF) $_new_lat = "lat: " & String("-34.397") & ", " $_new_lng = "lng: " & String("150.644") & "}; " ConsoleWrite("...new lat is: " & String($_new_lat) & " new lng is: " & String($_new_lng) & @CRLF) $_LOOK = StringReplace($_old_lat, 1, String($_new_lat)) $_LOOK2 = StringReplace($_old_lng, 1, String($_new_lng)) ConsoleWrite("$_LOOK: " & $_LOOK & "$_LOOK2: " & $_LOOK2 & @CRLF) EndIf ;'$_end_look' NOT "0"... $iPos = -1 EndIf ;'String($s_word)' was found in the collection '$oInputs' EndIf ;'$iPos' is "-1" Next  
        I am having trouble trying to replace the line in the HTML ($sHTML variable in my example) that contains the "lat:" and "lng:" information.  I figure if I can replace that line everything else remains the same, and in theory, the map should cycle to display a map with the new latitude and longitude coordinates...I hope. 
        I have attempted to write the $sHTML to a text document and then use '_IEBodyWriteHTML' to read it back into the webpage HTML however that is not working.  There must be an easier method to accomplish this...what am I missing here...?  Any thoughts greatly appreciated.  Regards.       
    • Dent
      By Dent
      @Blueman @Damein
      Dear all,
      I couldn't find anything that related exactly to what I'm trying to achieve although I did find some examples from the two people I've tagged in which has gotten me so far.
      I understand this topic could be a contentious issue and perhaps that's why there's no threads that I could find that relate directly to it. If the subject is taboo then I'll completely understand it if this thread is deleted.
      I want to write a program that periodically posts the IP address and Geo/GPS location data to me some way e.g. ftp/POST/email - the back-story is below.
      Ok so recently I had a computer stolen from my office, the actual value of the computer is very low as it was 10 years old and just for basic office tasks. Whilst the important files were backed up I never got around to automating this process so I lost a couple of weeks work when it was stolen.
      Anyway, this computer was used mainly by one employee and as I wouldn't be at the office a lot of the time I would use VNC to help when they got stuck with a particular task. As the IP was dynamic I found the dynamic DNS solutions supported by the router not to be very reliable so I wrote a small AutoIt program that called the dynamic DNS update link every 15 minutes, this program was in the Start Menu -> Programs -> Start Up folder and worked fine. This computer was a desktop box with no Wifi so was connected via Ethernet.
      As the accounts on the machine are password protected, whoever ends up with the box is likely to format the HD and put a fresh OS on there so this program is unlikely to run again which is a shame because as it's a desktop box with no Wifi I could use the IP address to give to the Police who could get the users name and address by matching who that IP was assigned to at that time. This is very unlikely to be a coffee shop etc.
      So I'm a lot more security and disaster recovery minded now and have replaced that box with a laptop that the staff member can take home with them each day and it automatically backs up to OneDrive upon log in.
      I've put VNC and the dynamic DNS AutoIt program on there but as this is a laptop with Wifi it's obviously very portable and can be used to get online from more locations.
      What I want to do is create another program that gets the device location as well as the IP and sends it to me every 15 minutes or so. I'd plan to put this program in a Guest account that has no password so if this laptop were ever stolen the next user would actually be able to log in and this program would run. Even better would be for this program to be started as a service so it runs before logging in to an account, just like VNC does. Being a laptop it could be used by a thief or other unauthorised user in a coffee shop etc.
      The solution I have explored so far is have a local .htm file that is opened via AutoIt program which when it has loaded displays the latitude and longitude of the machine, the program then saves this to a file with IP address and date/time stamp and sends it to me somehow (I'll probably implement multiple ways of it notifying me just in case of firewalls). The instance of IE would load minimized and quit after the lat/long is read; as it is such a small page running locally this all happens very quickly so is hard for any user to detect and cancel/intercept.
      My only problem with this implementation is I can't find a way for the page to start the script and obtain the location without user interaction (clicking Allow). I know why this is like this, because it could be used to spy on peoples location so could be open to mis-use.
      So perhaps there is a better way, programmatically within AutoIt using Google Maps API (which I haven't looked into properly yet) to do this where there is no user interaction required?
      There are probably commercial applications to do just this (similar to FindMyiPhone) but I've not investigated the availability of those for Windows and don't see how such a commercial application would be any less open to mis-use so why not create my own little app if possible and avoid the cost.
    • JDGenesis
      By JDGenesis
      I'm having an issue with using google maps in an embedded IE control.  I'm not sure if it is a IE version (v9 on my PC) or AutoIt issue and hope someone can test this on their end.  Below is a simple test program that embeds an IE control and loads a custom marker.  The program works fine with a default icon, but with a custom marker it fails to show the marker and freezes the map after you zoom in or out.  Does someone mind trying it on their end?  Put "//" in front of the icon object to see it work correctly.
      GUICreate("",800, 600) $gmap = _IECreateEmbedded() $gmap_ctrl = GUICtrlCreateObj($gmap, -1, -1, 800, 600) _IENavigate($gmap, "about:blank", 0) $html = _ "<!DOCTYPE html><html><head><style type=""text/css"">" & @CRLF & _ "html, body { height: 100%; margin: 0; padding: 0; overflow:hidden;}" & @CRLF & _ "#map { height: 100%; }" & @CRLF & _ "</style></head><body><div id=""map""></div><script type=""text/javascript"">" & @CRLF & _ " var map;" & @CRLF & _ " function initMap() {" & @CRLF & _ " map = new google.maps.Map(document.getElementById('map'), {" & @CRLF & _ " center: {lat: 26.527387,lng: -83.9892645}," & @CRLF & _ " zoom: 10" & @CRLF & _ " });" & @CRLF & _ " var issueIcon = {" & @CRLF & _ " path: 'M -45,-110 45,-110 45,-25 -45,-25 Z'," & @CRLF & _ " fillColor: 'yellow'," & @CRLF & _ " fillOpacity: 1," & @CRLF & _ " scale: 1," & @CRLF & _ " strokeColor: 'black'," & @CRLF & _ " strokeWeight: 1" & @CRLF & _ " };" & @CRLF & _ " var infowindow = new google.maps.InfoWindow({" & @CRLF & _ " content: 'test'" & @CRLF & _ " });" & @CRLF & _ " var marker = new google.maps.Marker({" & @CRLF & _ " position: map.getCenter()," & @CRLF & _ " map: map," & @CRLF & _ " icon: issueIcon," & @CRLF & _ " title: 'test'" & @CRLF & _ " });" & @CRLF & _ " marker.addListener('click', function() {" & @CRLF & _ " infowindow.open(map, marker);" & @CRLF & _ " });" & @CRLF & _ " }" & @CRLF & _ "</script><script async defer src=""https://maps.googleapis.com/maps/api/js?callback=initMap""></script></body></html>" _IEDocWriteHTML($gmap, $html) ;_IEAction ($gmap, "refresh") GUISetState(@SW_SHOW) While 1 $iMsg = GUIGetMsg() Select Case $iMsg = $GUI_EVENT_CLOSE ExitLoop EndSelect WEnd GUIDelete() Thank you.
×