simPRO API Forum

Hi,

I am new to use Simpro API . I need your advice. How do I call simpro API in my excel - VBA application?
I have registered my application and got the API key to use. Now not sure how to use it. I have used as below as a test code.
BUt the response is blank. Please help. Thank you.


Set objXML = CreateObject("MSXML2.XMLHTTP")
With objXML
.Open "GET","https://companyname.simprosuite.com/api ... gs/",False, "Authorisation", "Bearer <API Key>"
.setRequestHeader "Content-Type", "application/json"
.send

Do While .ReadyState <> 4
DoEvents
Loop
strText = .responsetext

End With

Regards,
Sam

Manged to crack it.
Works fine now.