Forum Discussion
Solved
Sync Data from Sharepoint Custom List to External List
Hi all., I am using Office 365 SharePoint online Plan 2, and Azure SQL database. I have successfully connected Business Connectivity Server for Both SharePoint & Azure SQL. I have Successfully Cre...
- Well, Indeed what you need to do is just write from your list into the SQL Azure database that is behind the scenes...there are some approaches you could use here:
(1) Since it seems you want to add the data in the SQL Azure database when a new item is added into the list, then you need to be able to react the event triggered by SharePoint when the item is added. To catch this event you have some options: a.) A Remote Event Receiver b.) a Web Hook c.) a SPO Workflow d.) a Flow
(2) Instead of adding the data to the SQL Azure database just at the moment is added to the list, poll the list for new items and add to the database. You could do this by means of a programmatic job implemented in an Azure WebJob / Azure Functions
What is the problem you are trying to solve? What is the business case for needing two separate data sources with the same content? Perhaps there is a better way...
i need Read only access to the sharepoint custome list from desktop application, so direcly accessing sharepoint list through MS Access creating performance & networkng issue...
so i have idea to create duplicate data from sharepoint list to external list (Azure SQL) then access desktop Application from Azure SQL table.
- Why not have the desktop application pull the data directly from the SharePoint list using REST/ODATA?