microsoft-365

name	microsoft-365
description	Microsoft 365 integration via Graph API. Create, read, modify, and delete SharePoint sites, lists, list items, document libraries, and files (Excel, Word, PowerPoint). Read/write Excel cells and ranges directly. Upload/download files to SharePoint drives. Use when interacting with Microsoft 365, SharePoint, OneDrive for Business, or Office documents on SharePoint.

Microsoft 365 — Graph API Skill

Authentication

Source the auth helper to get $GRAPH_TOKEN / $GRAPH_ACCESS_TOKEN:

source skills/microsoft-365/scripts/graph-auth.sh

Requires these values exported in the environment or via all-agents secrets export:

• AZURE_VICTORIA_TENANT_ID
• AZURE_VICTORIA_CLIENT_ID
• AZURE_VICTORIA_CLIENT_SECRET

Do not put client secrets in command lines or checked-in files. All Graph API calls use: -H "Authorization: Bearer $GRAPH_TOKEN".

Base URL: https://graph.microsoft.com/v1.0

Quick Reference

Sites

# List all sites
GET /sites?search=*

# Get specific site
GET /sites/{site-id}

# Site ID format: hostname,siteCollectionId,webId

SharePoint Lists

# List all lists on a site
GET /sites/{site-id}/lists

# Create list
POST /sites/{site-id}/lists
{"displayName":"MyList","list":{"template":"genericList"},"columns":[{"name":"Col1","text":{}},{"name":"Col2","number":{}}]}

# Add item
POST /sites/{site-id}/lists/{list-id}/items
{"fields":{"Title":"Item1","Col1":"value","Col2":42}}

# Update item
PATCH /sites/{site-id}/lists/{list-id}/items/{item-id}/fields
{"Col1":"newValue"}

# Delete item
DELETE /sites/{site-id}/lists/{list-id}/items/{item-id}

# Delete list
DELETE /sites/{site-id}/lists/{list-id}

# Column types: text, number, boolean, dateTime, currency, choice, personOrGroup, lookup

Files (Drive)

# List files in root
GET /sites/{site-id}/drive/root/children

# Upload file (≤4MB)
PUT /sites/{site-id}/drive/root:/{filename}:/content
# Set Content-Type header appropriately, --data-binary @file

# Upload file (>4MB) — use upload session
POST /sites/{site-id}/drive/root:/{filename}:/createUploadSession

# Download file
GET /sites/{site-id}/drive/items/{item-id}/content

# Delete file
DELETE /sites/{site-id}/drive/items/{item-id}

# Get file metadata
GET /sites/{site-id}/drive/root:/{filename}

Excel (Online)

Read/write cells directly via workbook API — no download/reupload needed:

# Read range
GET /sites/{site-id}/drive/items/{item-id}/workbook/worksheets/{sheet}/range(address='A1:B3')

# Write range
PATCH /sites/{site-id}/drive/items/{item-id}/workbook/worksheets/{sheet}/range(address='A1:B2')
{"values":[["Name","Score"],["Alice",95]]}

# Add worksheet
POST /sites/{site-id}/drive/items/{item-id}/workbook/worksheets
{"name":"Sheet2"}

# List worksheets
GET /sites/{site-id}/drive/items/{item-id}/workbook/worksheets

# Create table
POST /sites/{site-id}/drive/items/{item-id}/workbook/tables/add
{"address":"A1:C5","hasHeaders":true}

# Add table row
POST /sites/{site-id}/drive/items/{item-id}/workbook/tables/{table-id}/rows
{"values":[["val1","val2","val3"]]}

Word & PowerPoint

Graph API does not support in-place content editing for Word/PowerPoint. Workflow:

1. Create locally using python-docx / python-pptx (pip packages)
2. Upload via drive PUT endpoint
3. Modify: Download → edit locally with python libs → re-upload

# Create Word doc
python3 -c "
from docx import Document
d = Document()
d.add_heading('Title', 0)
d.add_paragraph('Content here')
d.save('/tmp/output.docx')
"

# Create PowerPoint
python3 -c "
from pptx import Presentation
from pptx.util import Inches
p = Presentation()
slide = p.slides.add_slide(p.slide_layouts[0])
slide.shapes.title.text = 'Title'
slide.placeholders[1].text = 'Subtitle'
p.save('/tmp/output.pptx')
"

Python packages required: openpyxl, python-docx, python-pptx

Capabilities Matrix

Feature	Supported	Method
SharePoint Sites — list/get	✅	Graph API
SharePoint Lists — full CRUD	✅	Graph API
SharePoint List columns — add/modify	✅	Graph API
Document Libraries — list/upload/download/delete	✅	Graph API
Excel — read/write cells & ranges	✅	Graph Workbook API (online)
Excel — create workbooks	✅	openpyxl → upload
Excel — add worksheets/tables	✅	Graph Workbook API
Word — create documents	✅	python-docx → upload
Word — modify existing	✅	Download → python-docx → re-upload
Word — in-place edit via API	❌	Not supported by Graph
PowerPoint — create presentations	✅	python-pptx → upload
PowerPoint — modify existing	✅	Download → python-pptx → re-upload
PowerPoint — in-place edit via API	❌	Not supported by Graph
Files >4MB upload	✅	Upload session (resumable)
Create SharePoint sites	⚠️	Requires Sites.FullControl.All
OneNote	⚠️	Separate API, not covered here
Outlook/Teams	⚠️	Separate skills needed

Notes

• Excel workbook API works on files already in SharePoint/OneDrive — upload first, then manipulate
• Add Prefer: respond-async header for long-running Excel operations
• SharePoint list item IDs are integers, file item IDs are alphanumeric
• For file operations, get item ID via: GET /sites/{site-id}/drive/root:/{filename}
• Token is app-only (client credentials) — actions appear as "SharePoint App" in audit logs