Forum Discussion

Sundaytwins's avatar
Sundaytwins
Occasional Contributor
9 years ago

Integration TestRail and TestComplete

Hi, Is there anyone who has succesfully integrated the TestRail API into TestComplete?   I'm working with the VBScripts in TestComplete, but was not yet able to report my results back to TestRail u...
  • HKosova's avatar
    HKosova
    9 years ago

    I'm not a TestRails expert, but try passing the login/password in the Authorization header:

     

    Dim o, user, password

    user = "user"
password = "password"
    
Set o = Sys.OleObject("MSXML2.XMLHTTP")
o.open "GET","https://site.testrail.net/index.php?/api/v2/get_case/1", False
o.setRequestHeader "Content-Type", "application/json" 
o.setRequestHeader "Authorization", "Basic " & Base64Encode(user & ":" & password)
o.send
Log.Message(o.status)

    The code of the Base64Encode function is in this post on Stack Overflow.

     

    UPD: fixed typos in the example

Sundaytwins's avatar
Sundaytwins
Occasional Contributor

Hi Marsha,

 

This is the piece of code i tried to start with:

  Dim o
  Set o = CreateObject("MSXML2.XMLHTTP")
  o.open "GET","https://site.testrail.net/index.php?/api/v2/get_case/1",False,"user","password"
  o.setRequestHeader "Content-Type", "application/json" 
  o.send
  log.message(o.status)

The response is:

HTTP/1.1 401 Unauthorized
Content-Type: application/json; charset=utf-8
Date: Thu, 16 Jun 2016 06:45:46 GMT
Server: Apache
Set-Cookie: tr_rememberme=deleted; expires=Thu, 01-Jan-1970 00:00:01 GMT; Max-Age=0
Content-Length: 87
Connection: keep-alive

{"error":"Authentication failed: invalid or missing user\/password or session cookie."}

I'm pretty sure the user/password is ok ;-)

 

Thanks for helping!

HKosova's avatar
HKosova
SmartBear Alumni (Retired)
9 years ago

I'm not a TestRails expert, but try passing the login/password in the Authorization header:

 

Dim o, user, password

user = "user"
password = "password"

Set o = Sys.OleObject("MSXML2.XMLHTTP")
o.open "GET","https://site.testrail.net/index.php?/api/v2/get_case/1", False
o.setRequestHeader "Content-Type", "application/json" 
o.setRequestHeader "Authorization", "Basic " & Base64Encode(user & ":" & password)
o.send
Log.Message(o.status)

The code of the Base64Encode function is in this post on Stack Overflow.

 

UPD: fixed typos in the example

  • Sundaytwins's avatar
    Sundaytwins
    Occasional Contributor
    9 years ago

    Hi Helen, 

     

    The code snippet you sent is giving an VBScript error on 

     

    Base64Encode(user + ":" password)

    The base64Encode is expecting another type of variable.... (types don't match)

     

    Thanks for helping!

     

     

    • Sundaytwins's avatar
      Sundaytwins
      Occasional Contributor
      9 years ago

      Hi Helen, 

       

      You brought me on the right track. He doesn't understand the "+", he needs a "&"

       

      I got this working: 

       

      Sub TRCom2()

Dim o, TCuser, TCpassword, TClogin, TCpassphrase

TCuser = "user"
TCpassword = "password"
TClogin = TCuser&":"&TCpassword
TCpassphrase = "Basic " & Base64Encode(TClogin)

Set o = CreateObject("MSXML2.XMLHTTP")
o.open "GET","https://site.testrail.net/index.php?/api/v2/get_case/1", False
o.setRequestHeader "Content-Type", "application/json" 
o.setRequestHeader "Authorization", TCpassphrase
o.send
Log.Message(o.status)

End sub

      Thanks for your help. Now next step: getting things to read the JSON and POST stuf to TestRail....

      • Vallalarasu_P's avatar
        Vallalarasu_P
        Frequent Contributor
        8 years ago

        I have log message as 200. Success. But the application is not opened. Please let me know how to proceed after that