I have tried two methods to achieve this: List Files in OneDrive Business and Search for files using path OneDrive for Business. The list option does not recourse beyond the first folder and the search option works but has a limit of 100 results (I suspect that there will be more than 100 files once the project has started).
I would like to delete any file that is found that is more than 30 days old and whose name does not start with "archive_". Before the file is deleted, I would like to append a text log with the date and file path.
I got all of these parts to work as long as there are not too many subfolders or the search result returns less than 100 results. I would appreciate any help on how to overcome these limitations.