I want to connect SSIS packages to my SharePoint, to get excel or csv file and insert it into SQL server 2019. I've tried HTTP and OData connections but both of them gives same error 403.
In Server URL I am typing URL in this format :
https://companydoamin.sharepoint.com/sites/site_name/Shared%20Documents/Forms/AllItems.aspx
I've also tried with http://mySharePointServer/mySite/_vti_bin/listdata.svc