Search for new files

The following example shows you how to search entire site for files created after the specified time.

C# example

using System;
using System.Net;
using Independentsoft.Share;

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

                //Query restriction created with KQL (Keyword Query Language). Has only day precision when searching date/time properties
                Independentsoft.Share.Kql.IsGreaterThan restriction1 = new Independentsoft.Share.Kql.IsGreaterThan(SearchResultPropertyName.CreatedTime, DateTime.Today);

                //Query restriction created with FQL (Fast Query Language). Has second/millisecond precision when searching date/time properties
                //Independentsoft.Share.Fql.IsGreaterThan restriction1 = new Independentsoft.Share.Fql.IsGreaterThan(SearchResultPropertyName.CreatedTime, DateTime.Today);

                SearchQuery query = new SearchQuery(restriction1);
                query.SelectProperties.Add(SearchResultPropertyName.Title);
                query.SelectProperties.Add(SearchResultPropertyName.Path);
                query.SelectProperties.Add(SearchResultPropertyName.CreatedTime);

                SearchResult searchResult = service.Search(query);

                SimpleDataTable table = searchResult.PrimaryQueryResult.RelevantResult.Table;

                foreach (SimpleDataRow row in table.Rows)
                {
                    foreach (KeyValue cell in row.Cells)
                    {
                        if (cell.Key == SearchResultPropertyName.Title)
                        {
                            Console.WriteLine("Title: " + cell.Value);
                        }
                        else if (cell.Key == SearchResultPropertyName.Path)
                        {
                            Console.WriteLine("Path: " + cell.Value);
                        }
                        else if (cell.Key == SearchResultPropertyName.CreatedTime)
                        {
                            DateTime localTime = DateTime.Parse(cell.Value);
                            Console.WriteLine("CreatedTime: " + localTime);
                        }
                    }
                }

                Console.Read();
            }
            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 Independentsoft.Share

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

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

                ''Query restriction created with KQL (Keyword Query Language). Has only day precision when searching date/time properties
                Dim restriction1 As New Independentsoft.Share.Kql.IsGreaterThan(SearchResultPropertyName.CreatedTime, DateTime.Today)

                ''Query restriction created with FQL (Fast Query Language). Has second/millisecond precision when searching date/time properties
                ''Dim restriction1 As New Independentsoft.Share.Fql.IsGreaterThan(SearchResultPropertyName.CreatedTime, DateTime.Today)

                Dim query As New SearchQuery(restriction1)
                query.SelectProperties.Add(SearchResultPropertyName.Title)
                query.SelectProperties.Add(SearchResultPropertyName.Path)
                query.SelectProperties.Add(SearchResultPropertyName.CreatedTime)

                Dim searchResult As SearchResult = service.Search(query)

                Dim table As SimpleDataTable = searchResult.PrimaryQueryResult.RelevantResult.Table

                For Each row As SimpleDataRow In table.Rows

                    For Each cell As KeyValue In row.Cells

                        If cell.Key = SearchResultPropertyName.Title Then

                            Console.WriteLine("Title: " + cell.Value)

                        ElseIf cell.Key = SearchResultPropertyName.Path Then

                            Console.WriteLine("Path: " + cell.Value)

                        ElseIf cell.Key = SearchResultPropertyName.CreatedTime Then

                            Dim localTime As DateTime = DateTime.Parse(cell.Value)
                            Console.WriteLine("CreatedTime: " & localTime)

                        End If

                    Next

                Next

                Console.Read()

            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 > Search for new files

Need help? Ask our developers: