how to loop the files from the documents folder

Murali Kris

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Murali Kris6y ago
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 Ahmed6y ago
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