Information Required for Access:

• URL of the file (most important thing)
• User ID
• Password

To get the Server URL ( Path to file on SharePoint), you can go to SharePoint and then go to File and Right Click, Choose Properties and then you will see the Address (URL). That is the Server URL you need to use.

Accessing a File in Sharepoint 2016:

Step 1: Find the Proper URL

In Share Point 2015, the most important step is to construct correct link required for accessing resource successfully.

For example, here the general URL of resource file is:

https://microsoft.sharepoint.com/teams/Hadron/Shared%20Documents/Forms/AllItems.aspx?O/Support=undefined&FolderCTID=0x01200080C5E30310F0FB4CAB8F93BDB912C0E3&id=%2Fteams%2FHadron%2FShared%20Documents%2F_M%26O%2FSupport%2FServices%20Forecasting%2FMaster%20User%20List

But the URL which will be used to access the resource file will be:

https://microsoft.sharepoint.com//teams/Hadron/Shared%20Documents/_M&O/Support/Services%20Forecasting/Master%20User%20List/Services%20master%20list.xlsx

Step 2: Download the File via PowerShell or SSIS

Method #1: Powershell

Copy and Paste the code below into Powershell (Remember to replace your File URL on the "$FileUrl" line):
[crayon-5c4602f384916134656226/]

Method #2: SSIS

Copy and paste the code below into SSIS (Remember to create a variable in SSIS with your specific URL that will be pulled in by the bolded section below):
[crayon-5c4602f384937507129712/]
With that, you should be able to access any Sharepoint file! Enjoy!