This targets a current performance issue in our solution. The getChildItems() method only returns the library items inside a given folder. If we need to look into all folders inside the given folder, we need to make another call to getChildItems. Basically, for every folder inside the original, we need to place another SOAP request. Depending how many folder are inside the original, this might take a long time. Ideally a new service should be created to return all items recursively inside a given folder, so that only one SOAP request is made.
I still would recommend using the database since it's much faster than using an API. We have a big library and found the APIs not really suitable for large scale deployments.
Thank you for considering this request. The web service SearchItems in the LibraryService comes close to what we needed, if the folder path string were to be part of LibraryItem we would be all set.
Thank you!
This can easily be done by querying the Spotfire Admin database.