ServiceNow

Interact with the ServiceNow API using SQL Server

Signup and Obtain an API UserName and Password for your domain from ServiceNow
Create the stored procedure documented below
Execute the following SQL statement:


EXEC usp_ServiceNow_Auth_Init	@Profile = 'enter-profile-name-of-your-choosing',
				@UserName = 'enter-your-api-username-here',
				@Password = 'enter-your-api-password-here',
				@Domain = 'enter your domain here'

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

@UserName = 'enter-your-api-username-here',

@Password = 'enter-your-api-password-here',

@Domain = 'enter your domain here'



Stored Procedures:


CREATE PROCEDURE usp_ServiceNow_Auth_Init(	@Profile nvarchar(100),
						@UserName varchar(100), 
						@Password varchar(100), 
						@Domain varchar(200))
AS

EXEC SQLHTTP.net.AuthParamSet @Profile = @Profile, @Name = 'UserName', @Value = @UserName
EXEC SQLHTTP.net.AuthParamSet @Profile = @Profile, @Name = 'Password', @Value = @Password
EXEC SQLHTTP.net.AuthParamSet @Profile = @Profile, @Name = 'Domain', @Value = @Domain
GO

CREATE PROCEDURE usp_ServiceNow_Auth_Init( @Profile nvarchar(100),

@UserName varchar(100),

@Password varchar(100),

@Domain varchar(200))

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

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

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



Available API Calls:

API Library > ServiceNow

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.