Connect to Service Desk API from Excel [E901]

I am attempting to connect to the service desk using Excel VBA. The goal is to pull ticket information from Service Desk and put it into an excel spreadsheet for Manager to view. 

The code is using winhttp.winhttprequest.5.1 from
winhttp.dll.

 

===

Set req = CreateObject("winhttp.winhttprequest.5.1")

===

 

We're adding two headers to the request per the API documentation. Authentication and Content-Type. We've specified the authentication as Basic authentication per the API documentation.

 

===

req.setRequestHeader "Authentication", "Basic x:3a5f240c1498288e3942859ac6dda58f"

req.setRequestHeader "Content-Type", "application/json"

===

 

Upon sending that request, we get the 901 response of Unknown OAuth signature method which is nowhere to be found in the documentation. 



Is this type of connection even possible? There is no documentation in the API doc for using VBA authentication. 



Side Note:

I originally went directly to Service Desk Support with this question. They were unable to help so they sent me to the developers portal to post there. "I would recommend heading over to our dev center so our experts can assist you through the forums and support teams there. You can reach them at https://goto-developer.logmeininc.com/ ." 

At the Dev center I was told "I guess you are not using the REST API documented in this forum. This portal is not about the service desk api.

The API documentation might be helpful and can be found here: http://support.citrixonline.com/s/G2ASD/Help/APIDocs(link is external)

If this does not answer your questions you can get support for the GoToAssist Service Desk here: http://support.citrixonline.com/en_US/GoToAssistServiceDesk/contactsearch(link is external) "

Now I am posting here to see if anyone can help.