cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
New Contributor

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. 

3 REPLIES 3
LogMeIn Manager

Re: Connect to Service Desk API from Excel [E901]

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.

Glenn is a member of the LogMeIn Community Care Team.

Was your question answered? Please mark it as an Accepted Solution.
Was a post helpful or informative? Give it a Kudo!
New Contributor

Re: Connect to Service Desk API from Excel [E901]

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. 

New Contributor

Re: Connect to Service Desk API from Excel [E901]

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.