how to loop the files from the documents folder

Question

Hi mates, how to loop files inside document folder string siteUrl = "https://Contoso.sharepoint.com/sites/EagleWipro" ; string clientId = "de356957be31" ; string clientSecret = "SI1UCNW2rrnHoow=" ; using (var clientContext = new OfficeDevPnP.Core.AuthenticationManager().GetAppOnlyAuthenticatedContext(siteUrl, clientId, clientSecret)) { try { Web oWebsite = clientContext.Web; clientContext.Load(oWebsite); clientContext.ExecuteQuery(); List targetlist = oWebsite.Lists.GetByTitle( "Documents" ); CamlQuery query = new CamlQuery(); query.FolderServerRelativeUrl = "/sites/EagleTest/Shared Documents" ; ListItemCollection itemColl = targetlist.GetItems(query); clientContext.Load(itemColl); clientContext.Load(itemColl, d => d.Include(o => o[ "DisplayName" ], o => o.File)); clientContext.ExecuteQuery(); foreach (ListItem listitem in itemColl) { Console.WriteLine(listitem.displayName); } Here issue is itemColl returning count :0 infact files are there in the Documents folder how to load files from Share Documents folder Infact same code i tried with SPO authentication(userName/Password) its working fine, but as per requirement i tried ClientId, ClientSecreatID , but it returns Count 0. your help would be highly appreciated

Murali Kris · Answer

It seems like something wrong with this ..? I can able to loop Alllists but not list items, Document library files. if you see below code i can able to get all lists but not list items,in fact list has 3 items already. but it show count 0 string siteUrl = "https://Contoso.sharepoint.com/sites/Eagle" ; string clientId = "c-48a5-8027-de356957be31" ; string clientSecret = "DV2y9jRwpSI1UCNW2rrnHoow=" ; using (var clientContext = new OfficeDevPnP.Core.AuthenticationManager().GetAppOnlyAuthenticatedContext(siteUrl, clientId, clientSecret)) { try { Web oWebsite = clientContext.Web; clientContext.Load(oWebsite); clientContext.Load(oWebsite.Lists); clientContext.ExecuteQuery(); ListCollection lists = oWebsite.Lists; clientContext.Load(lists); clientContext.ExecuteQuery(); foreach (List list in lists) //this foreach means looping working as excepted { if (list.Title == "TestList" ) { Console.WriteLine( "List Name: " + list.Title); List olist = oWebsite.Lists.GetByTitle(list.Title); //trying to get list items CamlQuery query = CamlQuery.CreateAllItemsQuery(); ListItemCollection itemColl = list.GetItems(query); clientContext.Load(itemColl); clientContext.ExecuteQuery(); foreach (ListItem item in itemColl) // itemColl returing count :0 { if (itemColl.Count != 0) { Console.WriteLine(item[ "Title" ].ToString()); } What is the issue with Client Id, Client Secrete ...? can we get list content ..?

Farhan Ahmed · Answer

https://docs.microsoft.com/en-us/dotnet/api/system.io.directory.getfiles?redirectedfrom=MSDN&view=netcore-3.1#System_IO_Directory_GetFiles_System_String_System_String_System_IO_SearchOption_ https://forums.asp.net/t/1760280.aspx?loop+through+folder+and+examine+all+file+names+in+that+folder