MS SQL HTTP read text resposne large than 8000 characters

I am sending a request for json data and put all records into a table. I am having an issue because the response is greater than 8000 characters. And when checking the length it does not return a value Test URL : Test SQL BEGIN SET NOCOUNT ON; DECLARE @sUrl VARCHAR(200) ,@Data VARCHAR(MAX) ,@UserAgent VARCHAR(100) ,@Object as Int ,@ResponseText as Varchar(MAX) ,@Status int SET @Data = '' /* api/Account/Balance/{id} */ DECLARE @len INT = len(@Data) set @sUrl = '[login to view URL]' EXEC sp_OACreate 'WinHttp.WinHttpRequest.5.1', @Object OUT; EXEC sp_OAMethod @Object, 'Open', NULL, 'GET', @sUrl, 'false' EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Content-Type','application/json' EXEC sp_OAMethod @Object, 'setRequestHeader', null, 'Content-Length', @len EXEC sp_OAMethod @Object, 'send', null, @Data Exec sp_OAGetProperty @Object, 'responseText', @ResponseText OUTPUT EXEC sp_OAGetProperty @Object, 'Status', @Status OUT EXEC sp_OADestroy @Object Select LEN(@ResponseText) as Length -- Return no value PRINT @Status PRINT @ResponseText