Query via WinHttpRequest returnes 406 for existing records

[thorsten.nicklaus]

Hi Community,

I'm using the WinHttpRequest libery (in Excel) to query the OpenVuln, but the response is error 406 (no records).

If I query the same in PowerShell or Python; I get plenty of advisories returned.

The Query string: https://api.cisco.com/security/advisories/ios?version=12.2(50)SE5

Should return over 20 advisories!

URI = "https://api.cisco.com/security/advisories/ios?version=" + check
If (asa) Then
  URI = "https://api.cisco.com/security/advisories/iosxe?version=" + check
End If
With Request
     .Open "GET", URI, False
     .SetRequestHeader "Authorization", Token
     .SetRequestHeader "Accept", "application/xml; charset=UTF-8"
      .Send
      .WaitForResponse
End With

I already tried to send the version as payload, no much fun either > 406

Any suggestions, what I'm doing wrong?

Th

[Omar Santos]

Hi!

I am not familiar with that library or have seen anyone used it before. However, maybe you may need to escape the parenthesis like: 12.2\(50\)SE5

I am pretty sure that you already tried that, but wanted to check. I do see tons of advisories being shown via other methods (i.e., curl, openVulnQuery, Python, etc.)

Cheers,

Omar