Solution on syncing data from sharepoint to Azure SQL Database

Based on the information I found, here are some steps and considerations for your project:

Set up MS Entra for sharepoint api, You can refer to this article: learn.microsoft.com/en-us/answers/questions/2120929/authenticating-to-the-sharepoint-rest-api-as-an-en

You can use a time interval to check for changes in SharePoint, but a more efficient way might be to use webhooks or event receivers to get notified when a file is uploaded or modified. Once a change is detected, you can use the SharePoint REST API to download the file.

For more detailed steps and examples, you can refer to these articles:

Here are some additional resources and methods that might help you:

Microsoft Flow (Power Automate): Another option is to use Power Automate to create a flow that triggers when a file is uploaded to SharePoint, processes the file, and updates the SQL Database.

If the answer is helpful, please click “Accept Answer” and kindly upvote it. If you have extra questions about this answer, please click “Comment”.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.