Microsoft SharePoint connection method

Modified on Fri, 20 Oct, 2023 at 10:59 AM

For the Microsoft SharePoint connection method, you can refer below to follow the steps:

1. Provide the Shared Link to have the connection. For how to get the Shared link, can refer to more detail.

For example, https://<tenant>sharepoint.com/
2. The File Format field is set to Auto where Stock Sync auto-detects the file format or can also choose the type of file format.


3. By default First Row Header is disabled. If there’s a header on the file, need to enable this option. 

4. Then, for the Sheet Name you can put the sheet name under that field. If there are multiple sheets separated, you can put commas as separate. 

For example Sheet1, Sheet2

5. Lastly, you can click Test Connection to test the connection as well.

Steps to get the shareable link:

1. Locate your file in Microsoft SharePoint and click on the Share icon. 


2. It will show up this. You can edit the setting as by clicking the part Anyone with the link can edit


3. You can set it as Anyone with the link or can add it as specific people for stocksync@appspot.gserviceaccount.com to access the file. Click on Apply to save the setting. 


4. Click on the share icon again to copy the link or you can right-click on the file section to copy the link. 







Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article