Get list items and expand fields

The following example shows you how to get list items and expand specified fields.

C# example

using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using Independentsoft.Graph;
using Independentsoft.Graph.Sites;
using Independentsoft.Graph.QueryOptions;

namespace ConsoleApp1
{
    class Program
    {
        static async Task Main()
        {
            try
            {
                GraphClient client = new GraphClient();

                client.ClientId = "67cb3333-209e-454e-b7bd-55a4d201270f";
                client.Tenant = "independentsoft.onmicrosoft.com";
                client.Username = "info@independentsoft.onmicrosoft.com";
                client.Password = "password";

                Query query = new Query();
                query.Expand.Add("fields(select=Id, Title, Author, Editor, Modified, Created)");

                IList<ListItem> items = await client.GetListItems("independentsoft.sharepoint.com,ea210ba9-c729-4bc5-a3a0-e80b4f5b645f,cc286862-00d7-403c-ad10-33df95371a72", "333333333-2a3d-4235-9305-9f8bd6c7300a", query);

                foreach (ListItem item in items)
                {
                    Console.WriteLine("Item Id: " + item.Id);
                    Console.WriteLine("Item Name: " + item.Name);
                    Console.WriteLine("-----------------------------------------------------------------");

                    foreach (ListItemField field in item.Fields)
                    {
                        Console.WriteLine("Field Name: " + field.Name);
                        Console.WriteLine("Field Value: " + field.Value);
                        Console.WriteLine("-----------------------------------------------------------------");
                    }
                }

                Console.Read();
            }
            catch (GraphException ex)
            {
                Console.WriteLine("Error: " + ex.Code);
                Console.WriteLine("Message: " + ex.Message);
                Console.Read();
            }
        }
    }
}

VB example

Imports System
Imports System.Collections.Generic
Imports System.Threading.Tasks
Imports Independentsoft.Graph
Imports Independentsoft.Graph.Sites
Imports Independentsoft.Graph.QueryOptions

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

            Dim task = New Task(AddressOf Run)

            ' Start and wait for task to end.
            task.Start()
            Console.Read()

        End Sub

        Shared Async Sub Run()
            Try

                Dim client As GraphClient = New GraphClient()

                client.ClientId = "67cb3333-209e-454e-b7bd-55a4d201270f"
                client.Tenant = "independentsoft.onmicrosoft.com"
                client.Username = "info@independentsoft.onmicrosoft.com"
                client.Password = "password"

                Dim query As Query = New Query()
                query.Expand.Add("fields(select=Id, Title, Author, Editor, Modified, Created)")

                Dim items As IList(Of ListItem) = Await client.GetListItems("independentsoft.sharepoint.com,ea210ba9-c729-4bc5-a3a0-e80b4f5b645f,cc286862-00d7-403c-ad10-33df95371a72", "333333333-2a3d-4235-9305-9f8bd6c7300a", query)

                For Each item As ListItem In items

                    Console.WriteLine("Item Id: " + item.Id)
                    Console.WriteLine("Item Name: " + item.Name)
                    Console.WriteLine("-----------------------------------------------------------------")

                    For Each field As ListItemField In item.Fields

                        Console.WriteLine("Field Name: " + field.Name)
                        Console.WriteLine("Field Value: " + field.Value)
                        Console.WriteLine("-----------------------------------------------------------------")

                    Next

                Next

                Console.Read()

            Catch ex As GraphException
                Console.WriteLine("Error: " + ex.Code)
                Console.WriteLine("Error: " + ex.Message)
                Console.Read()
            End Try
        End Sub

    End Class
End Namespace

Independentsoft - any library, any programming language

Graph .NET > Tutorial > Get list items and expand fields

Need help? Ask our developers: