Sure thing. I marked each iteration of the process of a level so you can see how deep into the folder structure you're getting.
First you create an array for each level you want to go down into a folder structure. Level 0 would be the root folder, level one the subfolder, level to the subfolder of that subfolder and so on.
This step is where most of the work happens.
Then you point List folder to the root folder, create a condition on whether the file in the current iteration is a folder. If Yes, use the ID of that current file in a new List Folder and append the results to the array variable corresponding to that next level.
For my purposes I was pulling data from the file if it was not a folder (the no column).
For your purposes you'd probably have some method of adding to a variable that tracks the list for each folder and subfolder under but the yes & no columns of the condition so you can list all the files & folders. Or you could have it write the name to a spreadsheet. Lots of options there.
Then you use Parse JSON on your array for the next folder level to get the metadata. Then you add the Body of that parse JSON to the next loop and repeat the whole cycle over again. I got this Parse JSON from pulling the output of List folder, clicking Generate from Sample, and pasting it in there. I've pasted my parse JSON below but if, for some reason, you have different information, you can follow the same process to get a customize Parse JSON to use for your directory.
This gives you minimal nesting with a linear process to chain together folder information as you go deeper into your folder structure.
Parse JSON I used:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"Id": {
"type": "string"
},
"Name": {
"type": "string"
},
"DisplayName": {
"type": "string"
},
"Path": {
"type": "string"
},
"LastModified": {
"type": "string"
},
"Size": {
"type": "integer"
},
"IsFolder": {
"type": "boolean"
}
},
"required": [
"Id",
"Name",
"DisplayName",
"Path",
"LastModified",
"Size",
"IsFolder"
]
}
}
