Blob to SharePoint ETL using SharePoint Migration API

I need a compact proof-of-concept that automatically extracts Documents from an Azure Blob container, captures their accompanying metadata, and lands both in a SharePoint Online document library. Only files classed as “Documents” (e.g., PDF, DOCX, XLSX) are in scope—no images or videos. The PoC must demonstrate that file contents arrive intact, their metadata is mapped to the correct SharePoint columns, and the process can be triggered on demand or on a simple schedule.

You are free to choose the most suitable approach—Azure Data Factory, Logic Apps, Power Automate, an Azure Function, or a lightweight script in C# or Python using the Azure SDK and Microsoft Graph/SharePoint REST API are all acceptable. The key is clarity and repeatability; hard-coded secrets or one-off manual steps won’t meet the goal.

Deliverables
• Source code or pipeline definition with clear README covering setup, configuration variables, and execution steps
• A brief demo (screenshots or short video) showing a sample document and its metadata moving end-to-end
• Notes on extending the PoC to handle larger volumes or incremental syncs

Once this PoC runs smoothly I will review the results and determine next steps for a full-scale deployment.