Constructs a URL string from various parameters and path segments

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


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


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:

See Also: