topic List all files in a File Repository (TXW 9.1) in ThingWorx Developers

List all files in a File Repository (TXW 9.1)

SB_9732186 — Thu, 04 Mar 2021 11:27:36 GMT

I need an infotable that has the path & filenames of all the files in a file repository, irrespective of the path.

Re: List all files in a File Repository (TXW 9.1)

mnarang — Thu, 04 Mar 2021 11:40:01 GMT

Did you try using BrowseFileSystem service of File Repository?

Re: List all files in a File Repository (TXW 9.1)

SB_9732186 — Thu, 04 Mar 2021 13:21:46 GMT

Hi @mnarang

I have used BrowseFileSystem but that doesn't fit my use case.

Let me give you an example:

The service should return an infotable:

Path Filename

/one file1

/one file2

/one file3

/two file1

/two file2

/two file3

/three file1

/three file2

/three file3

Thanks.

Re: List all files in a File Repository (TXW 9.1)

DmitryTsarev — Fri, 02 Apr 2021 20:26:15 GMT

Is it what you're looking for?

Re: List all files in a File Repository (TXW 9.1)

mnarang — Thu, 04 Mar 2021 14:29:21 GMT

I think direct API is not there for your use case, but you can use existing API to create your service which can give you desired result. For example, BrowseDirectory or BrowseFileSystem will give you everything which is there in the repo on path /, then you need to iterate the previous output and whenever you find fileType as D, you need to execute the service again to get file listing in the directories. At the end you need to have a logic for combining the data/representation as per your use case. There can be other combination as well like ListDirectories+ListFiles, as you will be iterating data and calling this API in the loop, you need to test this solution from performance standpoint.

One more point if you have huge hierarchy of directories then this approach might not work, as you have to deep dive in the directories and execute the service in inner loops.

Re: List all files in a File Repository (TXW 9.1)

mnarang — Thu, 04 Mar 2021 14:31:24 GMT

if the approach mentioned by @DmitryTsarev works for you, then it is good as it seems to be more simpler and straight forward.

Re: List all files in a File Repository (TXW 9.1)

DmitryTsarev — Fri, 05 Mar 2021 14:27:27 GMT

The one above was a quick and dirty code.

Here is the sleeker version (no "init" step in the beginning and thus no "if" inside the loop):

Re: List all files in a File Repository (TXW 9.1)

SB_9732186 — Fri, 05 Mar 2021 10:57:19 GMT

Hi @DmitryTsarev ,

The codes that you have provided will only work for a 2-level directory structure, am I correct?

I need it for n-level directory structure.

Thanks.

Re: List all files in a File Repository (TXW 9.1)

DmitryTsarev — Fri, 05 Mar 2021 14:25:59 GMT

@SB_9732186 It works for arbitrary directory hierarchy.

The code gets the hierarchy from the GetDirectoryStructure and then just iterates over it. Here is the InfoTable returned by GetDirectoryStructure.

Here is a bit better commented code

The final result returned by the service:

Re: List all files in a File Repository (TXW 9.1)

slangley — Tue, 16 Mar 2021 21:02:03 GMT

Hi @SB_9732186.

If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.

Regards.

--Sharon