SQL Server Multipart/Form-Data
Budget: $10 – $30 USD
I have a project that requires me to send multipart/form data the current I can connect; however the data fields are no being seen
Code
EXEC sp_OACreate 'WinHttp.WinHttpRequest.5.1', @Object OUT;
EXEC sp_OAMethod @Object, 'Open', NULL, 'PUT', @sUrl, 'false'
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Authorization', @Token
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Content-Type','multipart/form-data; boundary=MyBoundary'
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Content-Length', @len
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Accept', 'application/json'
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Content-Disposition', 'form-data;MyBoundary,firstname="Steve'
EXEC sp_OAMethod @Object, 'send',null,@Data
EXEC sp_OAGetProperty @Object, 'Status', @Status OUT
INSERT into @json (Json_Table) exec sp_OAGetProperty @Object, 'responseText'
EXEC @ResponseText = sp_OAGetProperty @Object, 'responseText'
EXEC sp_OADestroy @Object
Code
EXEC sp_OACreate 'WinHttp.WinHttpRequest.5.1', @Object OUT;
EXEC sp_OAMethod @Object, 'Open', NULL, 'PUT', @sUrl, 'false'
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Authorization', @Token
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Content-Type','multipart/form-data; boundary=MyBoundary'
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Content-Length', @len
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Accept', 'application/json'
EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Content-Disposition', 'form-data;MyBoundary,firstname="Steve'
EXEC sp_OAMethod @Object, 'send',null,@Data
EXEC sp_OAGetProperty @Object, 'Status', @Status OUT
INSERT into @json (Json_Table) exec sp_OAGetProperty @Object, 'responseText'
EXEC @ResponseText = sp_OAGetProperty @Object, 'responseText'
EXEC sp_OADestroy @Object