Forum Discussion

Emilio1's avatar
Emilio1
New Member
7 years ago

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. 

  • GlennD's avatar
    GlennD
    GoTo Manager
    Hi Emilio,

    I apologize for the frustration. I have checked with other in our Support team and currently our API does not have support for what you are wanting to do.

  • Thank you for the quick response. Although which part of what we're trying to do isn't supported? So far, all we’ve tried to do is build an HTTP request that GETs data from the API. 

  • Thank you for the quick response. Although which part of what we're trying to do isn't supported? So far, all we’ve tried to do is build an HTTP request that GETs data from the API.