Hi all, I am using onedrive metadata to recreate my folderstructure. I started with this:
[tempFiles]: LOAD name as [Items.name], parentReference_path as [Items.parentReference_path], folder_childCount as [Items.folder_childCount], webUrl as [Items.webUrl];
SELECT name, parentReference_path, folder_childCount, webUrl FROM Items WITH PROPERTIES ( driveId='', folderId='', path='/Nick', maxResults='' );
Which provides me with a list of the folder names within the first folder, "Nick". Great!
Now, based on that list, I want to have it look inside EACH folder and give me the names of THOSE files/folders. I think it would be basically the same code as above except with a "path" that is a variable, assigned to the file names from the table above.
Additional info: this is what the code above gives me:
These "Item Names" are the names of subfolders. i then want to generate a list of the 4 folders within the Matthew_court_cmaj folder, and then the 3 folders within TalkTooMuchProject folder, and so on.