Why does sharepointOnlineConnector show only one web connection, when multiple are installed in the connections list?

Thanks @danminneyatsaf​ for looking at my question. I am unable to get the workaround to work in my setup; I have successfully added the sharepoint connection from the service definition - it is sitting in the web connection list once authenticated. Such as: I have even started with a clean machine, so that the connection is the ONLY one in the list (just to be sure) and I still get presented with the Safe starter template when choosing "account" in the SharePointOnlineConnector:I am confused with how to get the edit window up (as shown in your post) for the connection settings when choosing "account" within the connector..

@ridleyj​ I can see you've got the web connection setup in your first screenshot so that all looks good. This web connection that you created is selectable from the drop down list for the Account parameter in the SharePointOnlineConnector.

The name of the web connection will match the one you setup already(jason.ridley Microsoft SharePoint Online OtherTenance ConnectorTest). In your second screenshot it looks like you've clicked Add Web Connection which you would only want to do if you want to create another Web Connection.

If this is still a bit confusing, would you be able to clarify the goal here? Are you trying to create a new Web Connection, a new Web Service, or just select your existing Web Connection it in the SharePointOnlineConnector?

@danminneyatsaf​ The goal is to select the existing Web Connection. Interestingly, I don't see a list (which is why I assumed that you meant for me to follow the route of "Add Web Connection"; even though my connections list has values, the connector account dropdown is blank, so nothing to select:

@ridleyj​ What version of FME are you running? You can find this information under Help > About FME Workbench.

Apologies for the delay in responding:

FME Information

Edition: FME Desktop Oracle Edition (floating)

Version: FME(R) 2021.0.0.0 (20210305 - Build 21302 - WIN64)

Locale: en_AU

Codepage: windows-1252

@ridleyj​ I tested the same methods on FME 2021.0.0.0 (Build 21302 - WIN64) and was not able to reproduce the issue.

Would you be able to download a more recent version of FME and try the same methods and see if you can reproduce the issue? If the issue no longer persists then that means there must have been a problem with either that version of FME or the install on your machine.

Thanks!

Ok @danminneyatsaf​  I'll see if I can update. This may take some time in my corporate ecosystem! I'll keep you posted 😊​

@danminneyatsafe (Safer) I have the same issue in FME 2022.1.1.0. Can u advise me what needs to be done to connect from a selection of web connections for sharepoint?

@gemeentehw_mvk​ would you be able to provide more details on the issue you're having? Is this the same issue that was detailed above about not being able to view web connections you've created in the SharePointOnlineConnector?

@danminneyatsaf​ Sorry for my clarity.

I am experiencing the same issue that started this question. I don't get web connections that were previously made in the basic Microsoft SharePoint List Reader.

The SharePointOnlineConnecter does give me the web connections.

@gemeentehw_mvk​ I have a few follow up questions to better understand how you're setting up your workspace:

• Are you creating the web connection in the transformer or in the FME Options > Web Connections Window?
• Were these existing web connections made in the same version of FME you're using right now or a previous version?
• Is your SharePoint Online package up to date? You can upgrade by going to Tools (in the FME Workbench toolbar) > FME Options > FME Packages > check that the SharePoint Online package doesn't have "Upgrade Available" next to it. If it does, upgrade the package and try again

Hi, 

I am having the same issue with FME workbench version 2023.2.1.  Has this bug been fixed? The interesting things is that I am able to connect to a SharePoint List as a reader within the same workspace but when I try to connect to SharePointOnlineConnector using that same web connection to connect to the SP List I am unable to.  

Or is there a better way now to connect to excel on SP Online than this? 

Thanks,

Michelle
 

@michelle_n Hi there, thanks for posting your question. Could you please access the following location in FME Workbench 2023.2.1:

Tools → FME Options → Web Connections → select the Manage Services button at bottom right.

In the list of web services at left, could you please highlight the web service that you have configured for your SharePoint web connection that you’re trying to use.

Now look in the right-side pane, at the definition of the web service. Make sure you’re scrolled all the way to the top of the definition, and check on the full bolded name of the web service. Do you see reference to Microsoft SharePoint Online (Template), or Microsoft SharePoint Online (safe.microsoft-sharepoint)?

Here are a couple of images that demonstrate where to find the information I’m referring to:

SharePoint Online Connector Web Service:

SharePoint List Format Web Service:

If you see reference to Microsoft SharePoint Online (Template) on the web service that you’ve configured, then you’ve configured the web service specific to the SharePoint List Reader / Writer.

You would need to configure the web service that references Microsoft SharePoint Online (safe.microsoft-sharepoint) in order to create a web connection for the SharePoint Online Connector. This is because the SharePoint List Reader / Writer makes use of the SharePoint API, while the SharePointOnlineConnector makes use of the Microsoft Graph API, so they need different web services to hit those different APIs.

Please let me know if the above information addresses your question!

@gemeentehw_mvk @ridleyj hopefully the above helps you out, too!