Consuming the Google Maps API using OLE Automation in SQL Server

Views: 0
Reading Time: 2 minutes

Hello people,
Good night!

In this post I will give you a quick tip on how to consume the Google Maps API using OLE Automation in SQL Server to retrieve more information about a city just by its name.

Not sure how to enable OLE Automation on your instance? See more in the post Enabling OLE Automation via T-SQL on SQL Server.

Stored Procedure Implementation:

Using the created Stored Procedure:
SQL Server - OLE Automation - Google Maps API

XML Returned by API Call:

That's it folks!
Until the next post.