There's a plugin that allows you to do this: doc is here.
It requires some setup prior to use, which is explained in the documentation.
Once you've set up the plugin, you will be able to interact with the Sharepoint folder through Dataiku. In your case, you could create a Python recipe that uses the dataiku package to read and write to the folder (example and doc here).
