Monkeybread Software - MBS FileMaker Plugin: Files.ListAsJSON

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 10.1 10.2 10.3 10.4 10.5 11.0 11.1 11.2 11.3 11.4 Statistic FMM Blog

Files.ListAsJSON

Queries list of file names in folder as JSON.

Component	Version	macOS	Windows	Linux	Server	iOS SDK
Files	10.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

MBS( "Files.ListAsJSON"; Path { ; Keys; filter; ExtensionFilter } ) More

Parameters

Parameter Description Example Flags

Path Native path to the directory. "C:\Test"

Keys The keys to retrieve.
Pass a list of values including Size, CreationTimeStamp, AccessTimeStamp, ModificationTimeStamp, Visible.
Name, Directory and Type can be passed, but are always included.
If keys is "All", we include all keys. Optional

filter Optional, limits what is returned. Default is 0 to report all files. Pass a combination of 1 for showing only files, 2 for showing only directories and 4 for showing only visible items.
Add 8 if the path includes the file name specification with wildcards.
Combined pass 4+1 for visible files or 2+1 for visible directories. 5 Optional

ExtensionFilter Optional, a filter for getting only files with matching file extension. ".txt" Optional

Parameter	Description	Example	Flags
Path	Native path to the directory.	"C:\Test"
Keys	The keys to retrieve. Pass a list of values including Size, CreationTimeStamp, AccessTimeStamp, ModificationTimeStamp, Visible. Name, Directory and Type can be passed, but are always included. If keys is "All", we include all keys.		Optional
filter	Optional, limits what is returned. Default is 0 to report all files. Pass a combination of 1 for showing only files, 2 for showing only directories and 4 for showing only visible items. Add 8 if the path includes the file name specification with wildcards. Combined pass 4+1 for visible files or 2+1 for visible directories.	5	Optional
ExtensionFilter	Optional, a filter for getting only files with matching file extension.	".txt"	Optional

Result

Returns JSON array or error.

Description

Queries list of file names in folder as JSON.
This function needs a native path. Please use Path.FileMakerPathToNativePath function in order to convert a FileMaker style path to a native path.

With filter parameter being 8 on Windows, you can pass a path with wildcards directly and ExtensionFilter parameter is ignored. This is not supported on macOS.

TimeStamps are returned in the FileMaker formatting. On Windows a key AlternateFileName may be included in result if the file has an alternative file name for DOS.
If you need sorting, please check JSON.SortWithEvaluate function.

We can add more Keys if needed. Let us know if you need another value for all files.

Examples

List files on desktop:

MBS( "Files.ListAsJSON"; MBS("Folders.UserDesktop"); "Size¶CreationTimeStamp¶AccessTimeStamp¶ModificationTimeStamp¶Visible" )

Example result:
[
{
"Name": "Projects",
"Directory": true,
"Type": "Directory",
"Visible": true,
"Size": 64,
"CreationTimeStamp": "28.09.2020 15:52",
"AccessTimeStamp": "28.09.2020 15:51:58",
"ModificationTimeStamp": "28.09.2020 15:51:58"
}
]

List files and sort by name:

MBS( "JSON.SortWithEvaluate";
MBS( "Files.ListAsJSON";
MBS("Folders.UserDesktop");
"Size" );
"JSONGetElement ( leftJSON; \"Name\") < JSONGetElement ( rightJSON; \"Name\")" )

List files and sort by size descending:

MBS( "JSON.SortWithEvaluate";
MBS( "Files.ListAsJSON";
MBS("Folders.UserDesktop");
"Size" );
"JSONGetElement ( leftJSON; \"Size\") > JSONGetElement ( rightJSON; \"Size\")" )

Release notes

Version 10.5
- Added Files.ListAsJSON function to list files and return it as JSON.

Blog Entries

FileMaker Magazin

Ausgabe 6/2020, Seite 26, PDF

Created 28th September 2020, last changed 29th September 2020

Files.List - Files.ListRecursive

Feedback: Report problem or ask question.