UrlBuilder

Constructs a URL string from various parameters and path segments

Stored Procedure
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

EXEC SQLHTTP.net.UrlBuilder @URL, @Profile, [@PathSegment1 … @PathSegment15]

Arguments:

Name	Type	Description

@URL	nvarchar(MAX)	Required. Output parameter. Base URL of a web address which will be appended with path segments.
@Profile	nvarchar(100)	Required. The Profile under which Authorization Parameters were saved. Assign an empty string (”) if not applicable.
@PathSegment1 … @PathSegment15	nvarchar(MAX)	Optional. Fifteen parameters of additional path segments to be appended to the URL. The values will be properly URL Encoded. Additionally, each parameter value beginning with # will be retrieved as an AuthParam of the provided Profile.



Sample Usage:


DECLARE @URL nvarchar(MAX)

SET @URL = 'https://sandbox-quickbooks.api.intuit.com/v3'

EXEC SQLHTTP.net.UrlBuilder   @URL OUTPUT,
			      'Quickbooks',
			      'company', '#RealmID', 'account'

SELECT @URL

DECLARE @URL nvarchar(MAX)

SET @URL = 'https://sandbox-quickbooks.api.intuit.com/v3'

EXEC SQLHTTP.net.UrlBuilder @URL OUTPUT,

'Quickbooks',

'company', '#RealmID', 'account'

SELECT @URL

------------------------------------------------------------------------------

https://sandbox-quickbooks.api.intuit.com/v3/company/823999825374432/account



UrlBuilder

Featured API Wrapper Code / SQL Server