FormDataBuilder

Constructs a Form Data (Body) String from various parameters

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

Syntax:

EXEC SQLHTTP.net.FormDataBuilder @FormData, @Profile, @FormDataSegment1_Name, @FormDataSegment1_Value, [@FormDataSegment2_Name], [@FormDataSegment2_Value] … @FormDataSegment20_Name], [@FormDataSegment20_Value]



Arguments:

Name	Type	Description
@FormData	nvarchar(MAX)	Required. Output parameter. The FormData (Body) constructed by executing this stored procedure
@Profile	nvarchar(100)	Required. The Profile under which Authorization Parameters were saved
@FormDataSegment1_Name	nvarchar(MAX)	Required. First FormData (Body) parameter name to be appended to @FormData
@FormDataSegment1_Value	nvarchar(MAX)	Required. First FormData (Body) parameter value to be appended to @FormData. A value beginning with # will be retrieved as an AuthParam of the provided Profile. See example below.
@FormDataSegment2_Name	nvarchar(MAX)	Optional. Second FormData (Body) parameter name to be appended to @QueryString
@FormDataSegment2_Value	nvarchar(MAX)	Optional. Second FormData (Body) parameter value to be appended to @QueryString. A value beginning with # will be retrieved as an AuthParam of the provided Profile. See example below
. . .
@FormDataSegment20_Name	nvarchar(MAX)	Optional. Twentieth FormData (Body) parameter name to be appended to @FormData
@FormDataSegment20_Value	nvarchar(MAX)	Optional. Twentieth FormData (Body) parameter value to be appended to @FormData. A value beginning with # will be retrieved as an AuthParam of the provided Profile. See example below.



Sample Usage:


DECLARE @FormData nvarchar(MAX)

EXEC SQLHTTP.net.FormDataBuilder        @FormData OUTPUT,
					'Box', --Profile
					'grant_type', 'refresh_token', --First FormDataSegment Name/Value pair
					'refresh_token', '#RefreshToken', --Second FormDataSegment Name/Value pair
					'client_id', '#ClientID', --Third FormDataSegment Name/Value pair
					'client_secret', '#ClientSecret' --Fourth FormDataSegment Name/Value pair

SELECT @FormData

DECLARE @FormData nvarchar(MAX)

EXEC SQLHTTP.net.FormDataBuilder @FormData OUTPUT,

'Box', --Profile

'grant_type', 'refresh_token', --First FormDataSegment Name/Value pair

'refresh_token', '#RefreshToken', --Second FormDataSegment Name/Value pair

'client_id', '#ClientID', --Third FormDataSegment Name/Value pair

'client_secret', '#ClientSecret' --Fourth FormDataSegment Name/Value pair

SELECT @FormData

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

grant_type=refresh_token&refresh_token=K44LmWiag8ceKIhdBTXSqXu8lYw9vE3b&client_id=l85mmtb2ev1lmqme923nb&client_secret=uqaUVYnejPuQfggFCCYx



FormDataBuilder

Featured API Wrapper Code / SQL Server