Read and write files to sharepoint

Question

Hi,

I want to read and write files from/to sharepoint server. As of my knowledge we cannt use ADF to write back to sharepoint server, but we can read from sharepoint.

How we can achieve both reading and writing using azure cloud services? Please suggest best possible solutions for this.

Answer 1

Hey,

You are right, ADF supports only reading from sharepoint via web activity and doesnt support write back as REST end point is not supported as sink.

In case if you need low code technology, then Azure logic is the best fit which supports reading and writing back into sharepoint.

Others Azure offerings like Azure functions, Azure databricks, Azure automation and Azure batch support custom code and based on custom logics , you can read and write from sharepoint based on the code you write

Answer 2

Hello @Santhi Dhanuskodi - I wanted to weigh in on this thread with @Nandan Hegde and address your follow-up question:

Yes, it should be possible to accomplish this through Python code.

• To interact with Sharepoint, you can use its REST API. A quick search yields the following Python library to make it easier to work with the operations provided via the REST API: https://github.com/vgrem/Office365-REST-Python-Client
• As for interacting with ADF, you can use the Python SDK: Azure Data Factory libraries for Python

Similar/related post: https://learn.microsoft.com/en-us/answers/questions/78034/how-to-connect-python-program-to-sharepoint-rest-a

I hope these resources help you get started. If you run into issues, feel free to make new posts here on MS Q&A and we'd be happy to assist.

---

Please "Accept Answer" if the answer is helpful so that others in the community may benefit from your experience.