Forum Discussion

Advocate I

2 years ago

Solved

Import Excel template to Synapse, populate and push to Teams/Sharepoint

Hi, I have a Synapse workspace available where i will be querying som data. I would like to populate the data to some excel template files (stored in Teams/Sharepoint) and (re)save the file in an...

data engineering

FabianSchut
2 years ago
Hi AbiNyk,

I suggest you use a Python Notebook in Synapse and use the sharepoint API to upload files to the sharepoint site.
Here is an example of a Python script to upload an Excel file:
https://stackoverflow.com/questions/70574450/upload-file-to-sharepoint-using-api-postman#answer-78380860

First, you should get the right access token, preferrably with an app registration and access to the sharepoint site. This is how you receive the access token in sharepoint:
https://stackoverflow.com/questions/75795486/how-can-i-get-an-access-token-using-msal-in-python#answer-75800949

Anonymous

Not applicable

2 years ago

HI AbiNyk,

I check the documents and find current you can read data from SharePoint folder and modify these records, but it is hard to write data back to SharePoint from fabric. (it seems like fabric not able to directly integrate and manage the online SharePoint contents)

Copy data from SharePoint Online List - Azure Data Factory & Azure Synapse | Microsoft Learn

Set up your SharePoint folder connection - Microsoft Fabric | Microsoft Learn

For writeback data operations, I'd like to suggest you publish them to azure side and use azure feature to push data to SharePoint side.

Regards,

Xiaoxin Sheng