Hi guys,Need a bit of help from those experienced with FME and sharepoint.Scenario:Need to access a “shared” excel file from our business groups sharepoint site as source for ETL development IT created a registered Azure app following FME guide on setting up Sharepoint web connection for single tenant, web guide. IT provided Tenant Id and client Id. IT setup registered azure app with delegated permissions: user.read, sites.selectedIssues:After following the guide for the web connection setup on FME, when testing, FME loads our orgs login page, when I key-in my windows account, I keep receiving prompt to ask admin for permission. I tried asking our Azure admins to test the web connection using their admin account and it goes thru. After saving the web connection and testing it on the sharepoint connector transformer it fails to load any sites and just throws an “unknow error”.So I am not sure at this point if its an issue with the registered app setup or if i lack access permission to our sharepoint site?If anybody has ran into these issues before, would definitely appreciate any recommendations. Cheers,Chris

Question

SharePoint Connection (SingleTenant) setup issues

3 months ago
February 1, 2025
4 replies
50 views

chrisp
Contributor
8 replies

Hi guys,

Need a bit of help from those experienced with FME and sharepoint.

Scenario:

Need to access a “shared” excel file from our business groups sharepoint site as source for ETL development
IT created a registered Azure app following FME guide on setting up Sharepoint web connection for single tenant, web guide. IT provided Tenant Id and client Id.
IT setup registered azure app with delegated permissions: user.read, sites.selected

Issues:

After following the guide for the web connection setup on FME, when testing, FME loads our orgs login page, when I key-in my windows account, I keep receiving prompt to ask admin for permission.
I tried asking our Azure admins to test the web connection using their admin account and it goes thru. After saving the web connection and testing it on the sharepoint connector transformer it fails to load any sites and just throws an “unknow error”.

So I am not sure at this point if its an issue with the registered app setup or if i lack access permission to our sharepoint site?

If anybody has ran into these issues before, would definitely appreciate any recommendations.

Cheers,

Chris

donalmateer
Safer
41 replies
3 months ago
February 4, 2025

Hi @chrisp,

Thanks for the post! I’m currently looking into it and will try my best to assist.

I’ve put together some useful articles that may help get an answer:

There are also some similar questions on the Community that I believe could help.

This thread regarding ‘Adming approval for Sharepoint Online connector’ may be of great assistance.
Also check out this relatec community question regarding ‘Sharepoint web connection’.

Let me know if anything here is of assistance, I will continue to look into it.

Thanks,
Donal.

chrisp
Author
Contributor
8 replies
3 months ago
February 4, 2025

Hi Donal,

Thanks for these inputs. The first link that talks about a “SharePoint Global Admin” that receives the request for approval seems to be promising. I will check with our Sharepoint team if they are receiving such requests and if approved, will potentially solve my issue. I will update this thread soon.

Cheers,
Chris

chrisp
Author
Contributor
8 replies
3 months ago
February 5, 2025

Hi Donel,

Our IT managed to resolve the authentication issues and i can now authenticate successfully using my account. The new issue or the next one is that when i use it on my 2022.2 FME i get this error,

I’ll try to look into further posts here in the community. I guess another layer of permission missing?

Cheers,

Chris

donalmateer
Safer
41 replies
3 months ago
February 5, 2025

Hi @chrisp,

This error could be due to FME being unable to access Microsoft due to permission issues. Here’s some ideas that may help find a solution.

Make sure FME has permission to access Microsoft API.
Ensure Correct Authentication.
Re-authenticate in FME (web-connections).

I’ve also included some articles which may assist:

Let me know if this assists - I’ll continue to look into this.

Donal.

Reply

Rich Text Editor, editor1

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

Cookie settings

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos + marketing

SharePoint Connection (SingleTenant) setup issues