Hello Will,
The marketplace module 'Microsoft SharePoint' should be able to connect to your SharePoint 2019 on-premise sites.
For 401 issues please check,Your username and password are correct.The API should not be IP restricted.
Mendix Community - Question Details
Upload a file to SharePoint using Mendix | by Heena S | Mendix Community | Medium
Mendix Community - Question Details
Developed custom Java to make the API connection. Was unsuccessful in getting the SharePoint module from the Marketplace to connect.