I have a document library which contains folders and document sets. I am trying to decide which to use for this case, is there a better option??
So I have the library known as 'TestTracking', which contains folders (or document sets depending which is the best option). I wish there was a way to have different columns for the files that are within the document sets/folders as it gets confusing having to mess with the content type.
Each folder in the library is a name, nested in that folder are files that have a retention date, start date, file type, and name of the file. There is a name value for both the folder as well as the file inside the folder, and when I use REST API, I cannot seem to find that value anywhere in my response. How can I filter/query/expand the results. This is a bit more confusing than normal list operations.
Here is my url for my AJAX call:
var libraryUrl = _spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/getbytitle('TestTracker')/items?select=Files$expand=Children";
What I am trying to access. In the parent(TestTracker Library), each folder has three columns showing relevant to that column. Name (default), Team, and OnBoardingDate. Within that folder, what I need to grab is the Name (default), Type (choice column for what the file is), and isRetained, a calculated column based off the OnBoardingDate.