I’m trying to send GET Request to the Orchestrator based on what I have found on Swagger to get to know how many machines I have with licenses allocated currently.
I found request on swagger and it works when I try it from chrome.
But unfortunately it doesn’t work when I try it from VBA, I got a message “You are not authenticated!”. I think it is because of SSL certificate
in VBA in (“WinHttp.WinHttpRequest.5.1”) I can indicate where SSL is stored. but the point is, I don’t know where should I find it.
My code is
Dim wr As String
Dim MyRequest As Object
Set MyRequest = CreateObject(“WinHttp.WinHttpRequest.5.1”)
’ Open an HTTP connection. ’
MyRequest.Open “GET”, “https://SomeServer/odata/LicensesNamedUser/UiPath.Server.Configuration.OData.GetLicensesNamedUser(robotType=‘Unattended’)”, False
’ Select a client certificate. ’
MyRequest.SetClientCertificate (“CURRENT_USER\Personal\My Certificate”)
’ Send the HTTP Request. ’
MyRequest.send
wr = Nz(MyRequest.responseText, “”)
Debug.Print wr
I have tried it also with path LOCAL_MACHINE\Personal\My Certificate
and got same results
So I guess the path indicated in MyRequest.SetClientCertificate is wrong, where should I find proper certificate to send request to Orchestrator?