Skip to main content
Question

Connect to SharePoint list in FME 2020

M

Hello there,

Hope you are doing well and safe.

 

I am trying to connect to a SharePoint list but I did not have any success with FME 2018, so upgraded to 2020. However, still, I am getting errors. Could you please advise.

 

Many thanks

Mohsen

 

AADSTS70011: The provided request must include a 'scope' input parameter. The provided value for the input parameter 'scope' is not valid. The scope https://[TENANT].sharepoint.com/.default offline_access is not valid. The scope format is invalid. Scope must be in a valid URI form <https://example/scope> or a valid Guid <guid/scope>.

 

Please see the screenshots.

 

 

 

6 replies

carsonlam
Safer
Forum|alt.badge.img
  • carsonlamSafer
  • Safer
  • May 7, 2020

The "Microsoft SharePoint Online (Template)" Web Service can't be used as-is. You need to make a copy of it and adjust it to match your organization. See the Web Service Setup Instructions under FME Options > Web Connections > Manage Services... > Microsoft SharePoint Online (Template).

M
carsonlam wrote:

The "Microsoft SharePoint Online (Template)" Web Service can't be used as-is. You need to make a copy of it and adjust it to match your organization. See the Web Service Setup Instructions under FME Options > Web Connections > Manage Services... > Microsoft SharePoint Online (Template).

Thank you Carsonlam, is there any guide on how to get those values (e.g. secret client,token,..)

carsonlam
Safer
Forum|alt.badge.img
  • carsonlamSafer
  • Safer
  • May 7, 2020
mohsenhs82 wrote:

Thank you Carsonlam, is there any guide on how to get those values (e.g. secret client,token,..)

To get things working, you don't need to change the included Client ID. Only the [TENANT] in Authorization Parameters > URL needs to be updated to match your organization.

Create an App Registration on Azure to obtain your own Client ID/Secret. This may require the involvement of an administrator for your SharePoint Online instance or Azure subscription.

M

Thanks, I am following that link and of course, I had to contact ICT, I will keep you/this thread posted.

 

M
  • mohsenhs82
  • Author
  • May 14, 2020
carsonlam wrote:

The "Microsoft SharePoint Online (Template)" Web Service can't be used as-is. You need to make a copy of it and adjust it to match your organization. See the Web Service Setup Instructions under FME Options > Web Connections > Manage Services... > Microsoft SharePoint Online (Template).

Hi again, I think we need to do it from Enterprise application rather than register an app in the Sharepoint (What about the redirect url if we register the app?), However, when we used FME and the admin account, FME application was created in the Enterprise application tab, and the SP admin created a security group, added me to it, and assigned it to FME, Still my account does not work, the admin also tried self-service and this does not work too, sorry it is kind of SharePoint question rather than FME, but appreciate if you could assist.
fmelizard
Safer
Forum|alt.badge.img+18
  • fmelizardSafer
  • Safer
  • May 14, 2020

Hi @mohsenhs82 Please send us the details of your SharePoint problem via https://www.safe.com/support/report-a-problem/ Thanks!

Reply


Helpful Members This Week

Community Stats

31,322
Posts
118,830
Replies
38,954
Members

Latest FME

Terms & ConditionsCookie settings

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
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.