Places (Google)

Interact with the Google Places API using SQL Server

Install the SQLHTTP database on your SQL Server
Obtain an API Key from Google Places
Create the stored procedure documented below
Execute the following SQL statement:


EXEC usp_Google_Places_Auth_Init	@Profile = 'enter-profile-name-of-your-choosing',
					@APIKey = 'your-google-places-api-key-here'

EXEC usp_Google_Places_Auth_Init @Profile = 'enter-profile-name-of-your-choosing',

@APIKey = 'your-google-places-api-key-here'



Stored Procedures:


CREATE PROCEDURE usp_Google_Places_Auth_Init(	@Profile nvarchar(100),
						@APIKey varchar(100))
AS

EXEC SQLHTTP.net.AuthParamSet 	@Profile = @Profile, 
				@Name = 'APIKey', 
				@Value = @APIKey
GO

CREATE PROCEDURE usp_Google_Places_Auth_Init( @Profile nvarchar(100),

@APIKey varchar(100))

EXEC SQLHTTP.net.AuthParamSet @Profile = @Profile,

@Name = 'APIKey',

@Value = @APIKey



Available API Calls:

API Library > Places (Google)

Install Now Free

IMPORTANT DISCLAIMER

CODE/SQL ON THESE PAGES ARE PROVIDED AS-IS AND ARE AVAILABLE FOR ILLUSTRATIVE PURPOSES ONLY.

USERS ARE REQUIRED TO ABIDE BY THE TERMS AND CONDITIONS FOR USING REFERENCED THIRD PARTY WEBSITES AND/OR APIs FROM THEIR RESPECTIVE WEBSITES. WE DO NOT CONDONE ANY VIOLATION OF THIRD PARTY WEBSITES AND/OR APIs TERMS AND CONDITIONS USING OUR SOFTWARE.

USERS SHALL BE SOLELY RESPONSIBLE AND BE SOLELY LIABLE FOR VIOLATION OF ANY RULES SPECIFIED BY THIRD PARTIES FOR USING THEIR WEBSITES AND/OR APIs, OR INFRINGEMENT OF RIGHTS OF SUCH THIRD PARTIES.