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

Marsha_R's avatar
Marsha_R
Moderator
9 years ago

Okay, can you show us some of your code?   What happens when you try the integration?

  • Sundaytwins's avatar
    Sundaytwins
    Occasional Contributor
    9 years ago

    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!

         

         

    • Marsha_R's avatar
      Marsha_R
      Moderator
      9 years ago

      Okay TanyaYatskovska who is the TestRail expert?   :smileyvery-happy: