Constructs a URL string from various parameters and path segments

Stored ProcedureSQL Server Compatibility:
2008, 2008 R2, 2012, 2014, 2016

Syntax

EXEC UrlBuilder @URL, @Profile, [@PathSegment1 … @PathSegment15]

Arguments

@URL
Required. Output parameter. Base URL of a web address which will be appended with path segments.

@Profile
Required. The Profile under which Authorization Parameters were saved. Assign an empty string (”) if not applicable.

@PathSegment1 … @PathSegment15
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.

Example

Result:

See Also

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 ZZZZZ Required. Output parameter. Base URL of a web address which will be appended with path segments.

@Profile ZZZZZ Required. The Profile under which Authorization Parameters were saved. Assign an empty string (”) if not applicable.

@PathSegment1 … @PathSegment15 ZZZZZ 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: