2/13/2023 0 Comments Google maps api vba![]() ![]() Where the constructed URL requests an XML data-feed and the “Addr” variable is URL-safe encoded. The idea is basically summarised in these lines: urlString = "" & Addr & "&client=" & clientid & "&channel=" & channelid signedKey = Base64_HMACSHA1(urlString, keyString) finalURL = urlString & "&signature=" & signedKey Interesting thing about this (looking back) is that it used XML rather than JSON for the output as VBA did not support JSON. However, I felt the VBA was interesting (despite being useless to me now) and wanted to share (especially the cryptography to sign the key). Now these have been superseded (and improved upon) by the JavaScript and Python versions (actually I just use python now). When I first started with the Google Maps API (more than 1.5 years ago) I wrote a VBA function to access both the Geocoding and Directions API.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |