When using the REST API to create a Test Case in a Project, I get back a general 400 Bad Request error with the message The server encountered an error processing the request. The exception message is Database foreign key violation occurred. See server logs for more details in the response body, followed by some information about an exception stack trace The JSON Im supplying in the body of the POST request is: {Name:This is a the Test Case, TestCaseStatusId:0, TestCaseTypeId:0} Ive also tried supplying the Name field only, and get the same error. If I use the web interface to create a Test Case, I have no problems using the REST API to GET its ID number and then using POST to create Steps inside it, so I cant see what is stopping me from creating Test Cases. en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spiratest/issues-questions/1969.aspxthreadId=1969David Bakkers (david.bakkers@dimensiondata.com)rest api error When using the REST API to create a Test Case in a Project, I get back a general 400 Bad Request error with the message The server encountered an error processing the request. The exception message is Database foreign key violation occurred. See server logs for more details in the response body, followed by some information about an exception stack trace The JSON Im supplying in the body of the POST request is: {Name:This is a the Test Case, TestCaseStatusId:0, TestCaseTypeId:0} Ive also tried supplying the Name field only, and get the same error. If I use the web interface to create a Test Case, I have no problems using the REST API to GET its ID number and then using POST to create Steps inside it, so I cant see what is stopping me from creating Test Cases. Mon, 14 Jan 2019 22:03:47 -05002019-01-30T04:01:08-05:00/Support/Forum/spiratest/issues-questions/1969.aspxmessageId=3494David J (adam.sandman+support@inflectra.com) Hello, Most likely you need to pass additional information required by the API. There is no such test case status as ID = 0 or type = 0, that is probably causing the issue right there. Regards Adam Wed, 16 Jan 2019 17:15:46 -05002019-01-16T17:15:46-05:00/Support/Forum/spiratest/issues-questions/1969.aspx#reply3494messageId=3495David Bakkers (david.bakkers@dimensiondata.com) Hello Adam The SpiraTeam REST API 5.0 reference page for Test Cases says those two properties definitely exist and you definitely can pass the value 0: TestCaseTypeId - The type of test case, pass 0 to use the default value TestCaseStatusId - The status of the test case, pass 0 to use the default value That documentation page also says Creates a new test case in the system. Name, TestCaseStatusId, and TestCaseTypeId are required fields. and even demonstrates the usage of those two fields in the JSON sample. Also, as I said, even if I pass only the Name property, I still get the error. If a required property is not passed in the request body, the API will normally send back a message advising which property has been omitted. So why in this case doesnt it tell me what Ive omitted? Can you be more specific and tell me what additional information is required by the API, as all the criteria specified on the API documentation page seems to have been met. Alternatively, please post a sample JSON formatted body request that youve tested and works. Wed, 16 Jan 2019 21:26:56 -05002019-01-16T21:26:56-05:00/Support/Forum/spiratest/issues-questions/1969.aspx#reply3495messageId=3496David Bakkers (david.bakkers@dimensiondata.com) Hello Adam Ive just made a minor breakthrough. I tried submitting the request to the SpiraTeam v4 REST API as per this V4 REST API documentation page , and using just the Name field only, and it worked.... the Test Case was created. When I inspect the Test Cases via the web interface, the Status shows as Obsolete and the Type as Functional, but all else is fine. So, it seems like the v5 REST API has a bug or the documentation page is incorrect. Wed, 16 Jan 2019 21:50:37 -05002019-01-16T21:50:37-05:00/Support/Forum/spiratest/issues-questions/1969.aspx#reply3496messageId=3497David Bakkers (david.bakkers@dimensiondata.com) Hello Adam Ive just done some further tests and can use the v5 API to create a Project, then create a Test Case Folder. I then switch to the v4 REST API and create the Test Case. I then switch back to the v5 API and create the Test Steps within that Test Case. This works around the bug in the v5 API for the Test Cases, but there is a limit of the v4 API in that it doesnt support the creation Test Cases inside Test Case Folders. Bummer! Please let me know when your developers have had a closer look into the v5 bug that affecting the creation of Test Cases. Wed, 16 Jan 2019 22:40:41 -05002019-01-16T22:40:41-05:00/Support/Forum/spiratest/issues-questions/1969.aspx#reply3497messageId=3498David Bakkers (david.bakkers@dimensiondata.com) Ive noticed that the v4 API does support creating Test Cases inside a Folder, the URL just needs to be different. So, I now have a full workaround for the v5 API bug until it can be resolved. Wed, 16 Jan 2019 22:52:56 -05002019-01-16T22:52:56-05:00/Support/Forum/spiratest/issues-questions/1969.aspx#reply3498messageId=3510David Bakkers (david.bakkers@dimensiondata.com) For anyone reading this thread, the issue turned out to be the API documentation, which says that the two fields TestCaseStatusId and TestCaseTypeId can be set to a value of 0. Those fields need to be set to a value of 1, or higher, where the number correlates to the position of the required value in the drop-down selection on the web interface, as per this example for the Status of a Test Case: Wed, 30 Jan 2019 04:01:08 -05002019-01-30T04:01:08-05:00/Support/Forum/spiratest/issues-questions/1969.aspx#reply3510