Why does sharepointOnlineConnector show only one web connection, when multiple are installed in the connections list?
I have had success in connecting to my corporate Sharepoint with the SharePointOnlineConnector using the web connection as set up in this HowTo: How to create a Sharepoint Web Connection (safe.com). Now I want to connect to another Tenant for which I have been granted access, but the connector only presents me with the Safe Template version for my web connection - even though I have set up and succesfully tested a new connection with a new name. I tried testing on a new machine, with no previous connections, and imported the new connection via xml then tried to add the web connection from within the transformer - same issue - the dropdown list doesn't show me the newly created connection (no matter what I call it):
Can anyone advise on what needs to be done to connect from a selection of web connections for sharepoint?
Page 1 / 1
Hi @ridleyj thank you for bringing this to our attention. I have tested the same methods and am encountering the same issues. I've submitted a bug report with our developers to get this fixed. The reference number for the issue is FMEDESKTOP-12773.
To workaround this, click on Tools > FME Options and then click the + symbol to add a Web Connection. From here you can select one of those other SharePoint web services that you created previously. As you can see in the screenshot below, multiple SharePoint web services are selectable. Hope this helps!
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..
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?
@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 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?
@ridleyj What version of FME are you running? You can find this information under Help > About FME Workbench.
@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?
@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?
@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?
@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?
@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?
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 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?
@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!
Can anyone advise on what needs to be done to connect from a selection of web connections for sharepoint?
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..
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. 
The SharePointOnlineConnecter does give me the web connections.
