OneDrive & SharePoint Lists

Create and manage SharePoint lists, columns, and items — plus document libraries as drives. The most common list automation scenarios, run against throwaway resources so each example is safe to re-run.

---

Prerequisites

Permission	Description	Reference
Sites.Read.All	Read lists, columns, items	Sites permissions
Sites.ReadWrite.All	Create/update/delete lists, columns, items	Sites permissions

All examples authenticate with client secret (client_id, client_secret, tenant from tests.settings).

---

How lists and libraries fit together

graph TD
    subgraph Site
        LISTS["Lists"]
    end

    LISTS --> LIST["List"]
    LIST --> COL["Columns"]
    LIST --> ITEM["Items"]
    LIST --> CT["Content types"]

    LIST -- documentLibrary --> DRIVE["Drive"]
    DRIVE --> FOLDER["Folders"]
    DRIVE --> FILE["Files"]

Which example to use: create a list and its schema (create_list.py), manage the data inside it (manage_items.py), query it efficiently (query_items.py), bulk load/export (import_export.py), maintain the schema (columns.py), or work with a document library as a drive (library.py).

---

Examples

Operation	File	Permission	API
Create a list with custom columns	create_list.py	Sites.ReadWrite.All	list create
Manage list items (CRUD)	manage_items.py	Sites.ReadWrite.All	listItem create
Query items (filter/select/order/top)	query_items.py	Sites.Read.All	listItem list
Document library as a drive	library.py	Sites.ReadWrite.All	driveItem put content
Bulk import / export items	import_export.py	Sites.ReadWrite.All	listItem create
Manage columns (incl. lookup)	columns.py	Sites.ReadWrite.All	columnDefinition create

---

API reference

• List resource
• ListItem resource
• ColumnDefinition resource
• DriveItem resource