List updated files

The following example shows you how to use query options to make filter to list only existing files updated/edited after the specified time. It will not list new created files.

C# example

using System;
using System.Net;
using System.Threading;
using System.Collections.Generic;
using Independentsoft.Share;
using Independentsoft.Share.QueryOptions;

namespace Sample
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                Service service = new Service("https://independentsoft.sharepoint.com", "username", "password");

                DateTime queryTime = DateTime.Now;
                Thread.CurrentThread.Join(30000); //wait 30 seconds

                while (true)
                {
                    Independentsoft.Share.QueryOptions.IsGreaterThanOrEqualTo restriction1 = new IsGreaterThanOrEqualTo(FilePropertyName.LastModifiedTime, queryTime);
                    Independentsoft.Share.QueryOptions.IsLessThan restriction2 = new IsLessThan(FilePropertyName.CreatedTime, queryTime);
                    Independentsoft.Share.QueryOptions.And restriction3 = new And(restriction1, restriction2);

                    Filter filter = new Filter(restriction3);

                    IList<IQueryOption> queryOption = new List<IQueryOption>();
                    queryOption.Add(filter);

                    IList<Independentsoft.Share.File> files = service.GetFiles("/Shared Documents", queryOption);

                    queryTime = DateTime.Now;

                    if (files.Count > 0)
                    {
                        Console.WriteLine("UPDATED FILES ....");

                        for (int i = 0; i < files.Count; i++)
                        {
                            Console.WriteLine("Name: " + files[i].Name);
                            Console.WriteLine("Path: " + files[i].ServerRelativeUrl);
                            Console.WriteLine("Length: " + files[i].Length);
                            Console.WriteLine("CreatedTime: " + files[i].CreatedTime);
                            Console.WriteLine("LastModifiedTime: " + files[i].LastModifiedTime);
                            Console.WriteLine("---------------------------------------------");
                        }
                    }
                    else
                    {
                        Console.WriteLine("NO UPDATED FILES ...");
                    }

                    Thread.CurrentThread.Join(30000); //wait 30 seconds
                }
            }
            catch (ServiceException ex)
            {
                Console.WriteLine("Error: " + ex.Message);
                Console.WriteLine("Error: " + ex.ErrorCode);
                Console.WriteLine("Error: " + ex.ErrorString);
                Console.WriteLine("Error: " + ex.RequestUrl);
                Console.Read();
            }
            catch (WebException ex)
            {
                Console.WriteLine("Error: " + ex.Message);
                Console.Read();
            }
        }
    }
}

VB example

Imports System
Imports System.Net
Imports System.Threading
Imports Independentsoft.Share
Imports Independentsoft.Share.QueryOptions

Namespace Sample
    Class Module1
        Shared Sub Main(ByVal args As String())

            Try
                Dim service As New Service("https://independentsoft.sharepoint.com", "username", "password")

                Dim queryTime As DateTime = DateTime.Now
                Thread.CurrentThread.Join(30000) ''wait 30 seconds

                While (True)

                    Dim restriction1 As Independentsoft.Share.QueryOptions.IsGreaterThanOrEqualTo = New Independentsoft.Share.QueryOptions.IsGreaterThanOrEqualTo(FilePropertyName.LastModifiedTime, queryTime)
                    Dim restriction2 As Independentsoft.Share.QueryOptions.IsLessThan = New Independentsoft.Share.QueryOptions.IsLessThan(FilePropertyName.CreatedTime, queryTime)
                    Dim restriction3 As Independentsoft.Share.QueryOptions.And = New Independentsoft.Share.QueryOptions.And(restriction1, restriction2)

                    Dim filter As New Filter(restriction3)

                    Dim queryOption As New List(Of IQueryOption)()
                    queryOption.Add(filter)

                    Dim files As IList(Of Independentsoft.Share.File) = service.GetFiles("/Shared Documents", queryOption)

                    queryTime = DateTime.Now

                    If (files.Count > 0) Then

                        Console.WriteLine("UPDATED FILES ....")

                        For i As Integer = 0 To files.Count - 1
                            Console.WriteLine("Name: " & files(i).Name)
                            Console.WriteLine("Path: " & files(i).ServerRelativeUrl)
                            Console.WriteLine("Length: " & files(i).Length)
                            Console.WriteLine("CreatedTime: " & files(i).CreatedTime)
                            Console.WriteLine("LastModifiedTime: " & files(i).LastModifiedTime)
                            Console.WriteLine("---------------------------------------------")
                        Next
                    Else
                        Console.WriteLine("NO UPDATED FILES ....")
                    End If

                    Thread.CurrentThread.Join(30000) ''wait 30 seconds

                End While

            Catch ex As ServiceException
                Console.WriteLine("Error: " + ex.Message)
                Console.WriteLine("Error: " + ex.ErrorCode)
                Console.WriteLine("Error: " + ex.ErrorString)
                Console.WriteLine("Error: " + ex.RequestUrl)
                Console.Read()
            Catch ex As WebException
                Console.WriteLine("Error: " + ex.Message)
                Console.Read()
            End Try

        End Sub
    End Class
End Namespace

Independentsoft - any library, any programming language

Share .NET > Tutorial > List updated files

Need help? Ask our developers: