Skip to main content
  • EN

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

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. 

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

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

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


Community Stats

31,250
Posts
118,505
Replies
38,840
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.