Hi, I want to display all the test sets along with their folder hierarchy in sorted order in a excel sheet. I am using http://api.inflectra.com/Spira/Services/v5_0/SoapService.aspx for fetching the data. There are two ways to do this. Approach 1 : By fetching testset folders , and then looping through them and check if testsets exists or not and print them If exists along with the folder. Approach 2 : By fetching testsets and then looping through each one of them and print them along with their container folders. Drawbacks : Approach 1 : Testsets can exist independently. So if we loop through only folders then we won’t be able to print those independent testsets. Approach 2 : If we loop through the testsets and then check if testset can exist in a folder. Then print the folder first and then testsets associated. In this way we won’t be able to print the folders which don’t have any testsets. Any help would be highly appreciated. Thanks, Abhijit 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/1579.aspxthreadId=1579Abhijit Banerjee (abanerjee@onenetwork.com)api soap Hi, I want to display all the test sets along with their folder hierarchy in sorted order in a excel sheet. I am using http://api.inflectra.com/Spira/Services/v5_0/SoapService.aspx for fetching the data. There are two ways to do this. Approach 1 : By fetching testset folders , and then looping through them and check if testsets exists or not and print them If exists along with the folder. Approach 2 : By fetching testsets and then looping through each one of them and print them along with their container folders. Drawbacks : Approach 1 : Testsets can exist independently. So if we loop through only folders then we won’t be able to print those independent testsets. Approach 2 : If we loop through the testsets and then check if testset can exist in a folder. Then print the folder first and then testsets associated. In this way we won’t be able to print the folders which don’t have any testsets. Any help would be highly appreciated. Thanks, Abhijit Mon, 21 Nov 2016 12:35:56 -05002016-11-21T17:46:39-05:00/Support/Forum/spiratest/issues-questions/1579.aspxmessageId=2826Jim R (donotreply5@kronodesk.net) Hi Abhijit If you use Approach 1, you can then query the test sets with a NULL folder Id to get the list of test sets that are in the root folder (i.e. not in a folder). If you use Approach 2, then you'd need to separately query the folders beforehand to find those that are never used and print those. Regards Jim Mon, 21 Nov 2016 17:46:39 -05002016-11-21T17:46:39-05:00/Support/Forum/spiratest/issues-questions/1579.aspx#reply2826