Example #1
0
        public static void RetrieveInvestigation()
        {
            Console.WriteLine("Retrieving Investigation document");
            string webSPOUrl = SharepointCredentials.SharePointUrl;
            string userName  = SharepointCredentials.UserName;

            InternalInvestigationDocuments.Clear();
            SecureString password = SharepointCredentials.FetchPassword();

            using (var context = new ClientContext(webSPOUrl))
            {
                context.Credentials = new SharePointOnlineCredentials(userName, password);
                Web web = context.Web;
                // Assume the web has a list named "Announcements".
                List announcementsList = context.Web.Lists.GetByTitle("Internal Investigation Case Tracking");

                // This creates a CamlQuery that has a RowLimit of 100, and also specifies Scope="RecursiveAll"
                // so that it grabs all list items, regardless of the folder they are in.
                CamlQuery          query = CamlQuery.CreateAllItemsQuery(100);
                ListItemCollection items = announcementsList.GetItems(query);

                // Retrieve all items in the ListItemCollection from List.GetItems(Query).
                context.Load(items);
                context.ExecuteQuery();
                foreach (ListItem listItem in items)
                {
                    InternalInvestigationDocuments.Add(new InternalInvestigationDocument(listItem));
                }
            }
        }
Example #2
0
        public static void Browser()
        {
            Console.WriteLine("Retrieving Litigation document");
            string       webSPOUrl = SharepointCredentials.SharePointUrl;
            string       userName  = SharepointCredentials.UserName;
            SecureString password  = SharepointCredentials.FetchPassword();

            using (ClientContext ctx = new ClientContext(webSPOUrl))
            {
                ctx.Credentials = new SharePointOnlineCredentials(userName, password);
                var web = ctx.Web;

                var list = ctx.Web.Lists.GetByTitle("Outlook Flow");
                ctx.Load(ctx.Web.Lists);
                ctx.ExecuteQuery();

                CamlQuery camlQuery = new CamlQuery();
                camlQuery.ViewXml =
                    @"<View>
                       
                              </View>";
                ListItemCollection listItems = list.GetItems(camlQuery);
                ctx.Load(listItems);
                ctx.ExecuteQuery();


                foreach (ListItem listItem in listItems)
                {
                    if (listItem.FileSystemObjectType == FileSystemObjectType.File)
                    {
                    }

                    //listitem["ID"]
                    //listitem["Name"]
                }
            }

            using (var context = new ClientContext(webSPOUrl))
            {
                context.Credentials = new SharePointOnlineCredentials(userName, password);

                List             sharedDocumentsList = context.Web.Lists.GetByTitle("Shared Documents");
                FolderCollection collFolder          = context.Web.Folders;
                context.Load(collFolder);
                context.ExecuteQuery();

                Console.WriteLine("The current site contains the following folders:\n\n");
                foreach (Folder myFolder in collFolder)
                {
                    Console.WriteLine(myFolder.Name);
                }

                Web web = context.Web;
                var k   = web.Folders;
                // Assume the web has a list named "Announcements".
                List announcementsList = context.Web.Lists.GetByTitle("Outlook Flow");

                // This creates a CamlQuery that has a RowLimit of 100, and also specifies Scope="RecursiveAll"
                // so that it grabs all list items, regardless of the folder they are in.
                CamlQuery          query = CamlQuery.CreateAllItemsQuery(100);
                ListItemCollection items = announcementsList.GetItems(query);

                // Retrieve all items in the ListItemCollection from List.GetItems(Query).
                context.Load(items);
                context.ExecuteQuery();
                foreach (ListItem listItem in items)
                {
                    if (listItem.FileSystemObjectType == FileSystemObjectType.File)
                    {
                    }

                    Console.WriteLine("first");    //)
                    //LitigationDocuments.Add(new LitigationDocument(listItem));
                }
            }
        }