Call WebAPI in classic asp

Hello

I am having requirement of changes in very old technology. I need to replace SQL Procedure call with WEB API Call.

I find some code but not sure correct or not. below is code I had put in my classic asp (.asp) page.
---------------------------------------------
dim oConn, strsql, rsGroup, varError, HttpReq, objXMLDoc
dim groupId, Userid

Set oConn = Server.CreateObject("DbConnections2.DataAccess")

Set HttpReq = Server.CreateObject("MSXML2.ServerXMLHTTP")
HttpReq.open "GET", "webapipath", False
HttpReq.send
---------------------------------------------

I am not sure or I don't know how we can do it ?

Please guide here. thanks in advance