Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.

APIv2 Error



I’m getting the following error when using the V2 get_plan API to retrieve a test plan:

send: b’GET /TestRail/index.php?/api/v2/get_plan/860 HTTP/1.1\r\nHost: localhost\r\nAccept-Encoding: identity\r\nContent-type: application/json\r\nAuthorization: Basic ***\r\n\r\n’
reply: ‘HTTP/1.1 500 Internal Server Error\r\n’
header: Content-Type header: Server header: X-Powered-By header: X-Powered-By
header: Date header: Content-Length <http.client.HTTPResponse object at 0x04C81310>
{“error”:"[Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘config’."}
’{“error”:"[Microsoft][SQL Server Native Client 11.0][SQL Server]Ambiguous column name ‘config’."}’

The plan (850) exists and as far as I can tell, the ‘runs’ table looks ok in the database (with config column present).

Any ideas why this is occurring?



Thanks for your posting. Yes, this is a known issue and will be fixed in the next TestRail update (3.0.1) which will be released shortly (likely tomorrow). I will make sure to email you once this is available.



The new version is now available and can be downloaded from your customer portal account. The release notes can be found here:

One thing I forgot to mention previously: please change your TestRail password as your forum posting contained your password (base64 encoded, but still). I’ve removed the password now but please make sure generate a new one nonetheless.



Thanks. I’ve upgraded and it works great.


Thanks for the confirmation!