Hello @jaygrg111_​, thanks for posting! Is there a specific reason you're using the HTTPCaller to connect to Sharepoint in FME? After reviewing this article, I think the SharepointOnlineConnector with the download action may be the way to go! If you haven't used the SharepointOnlineConnector in FME Form yet, section 4 of this article reviews how to get started: Configure the Connection in FME Form: SharePoint Online Connector (FME Hub). Happy to help, Kailin.

Hi @kailinatsafe​ Thank you so much for your feedback! To my surprise, I dont have Microsoft SharePoint Online (safe.microsft-sharepoint) web services on my menu that the link displays. What should I use now ? Is it related to permission issue? Please see the attached image. Please dont get confused by SharePoint on that list, because, I established that connection using Microsoft SharePoint Online (Template) so that I can use SharePointList Reader/Writer.

Hello @jaygrg111_​, I think the SharePoint List R/W and the SharePointOnlineConnector use two different APIs so there are differences in how those two web connections are set up (as well as the permissions), and the way Microsoft authenticates the user. I think you'd need two different app registrations, with two sets of permissions, then different web services, and thus connections in FME. So for the SharepointOnlineConnector, you'd want to create a new web service using the Microsoft SharePoint Online (safe.microsoft-sharepoint) Form! This article (section 4) reviews how to do this more specifically! Let me know if you get stuck somewhere along the way! Best, Kailin.

Hi @kailinatsafe , thank you so much for your feedback and sorry for many question but I dont have Microsoft SharePoint Online (safe.microsoft-sharepoint) web service form at all on my FME Desktop (Manage Sevrices). How can I add it to my list. Please see the attached image of list of current web services. I appreciate your suggestions.

Hello @jaygrg111_​, no worries at all! I think I know where the confusion is coming from. So we first need to

• add the web service
• then create the web connection in FME Options

1.Create a web new service form/template for your Sharepoint Instance. In your last screenshot (Manage Services...) you will want to use "Microsoft SharePoint Online (Template)". After you fill out all of the connection information, rename the connection to something unique at the top of the form. Then test the connection using the 'Test...' button at the very bottom!

Once you have done all of this, hit 'Apply' and then close the window.

2.Next, we can create the web connection. In FME Options > Web Connections, click the "+" at the bottom left hand side of your connection lists:

Select your newly created web service and authenticate

Now you should be able to select the new connection in the SharePointOnlineConnector! Please let me know if we're still having issues! Happy to help, Kailin

Hi @kailinatsafe​  It took me a while to figure out Web Connection parameters for SharePoint Online Connector. Thanks you for your suggestions throughout. I had to install the xml file from FME Hub that installed the correct template Source https://www.youtube.com/watch?v=1H0JlC3s0i0&t=54s). I have the connection now. However, I cant see the download option in Action. Is it a permission issue in Azure? Thank you again.

Hello @jaygrg111_​, thanks for the update! Glad you were able to successfully connect. You should see the 'Download' action within the SharepointOnlineConnector itself:

If you're unable to see it, please let me know or provide a screenshot if possible! Happy to help, Kailin

Hi @kailinatsafe , Thank you so much for your response. I will definitely update you how it goes.

Hi @kailinatsafe​  Sorry, I am back with my question again; I am getting the parameters as attached image on SharePoint Online Connector Transformer. This is completely different what your looks like above. Does it mean that the way I established my web connection details are wrong? I followed the steps under Topic "Configure the Connection in FME Form: SharePoint Online Connector (FME Hub)

" in the link - https://community.safe.com/s/article/How-to-Create-a-SharePoint-Web-Connection-for-FME-Form-Multitenant#multitenant . And I am using a Creator transformer before this transformer on my workspace. I am using FME 2022 version. I look forward to your suggestions. Thank you so much!

Hello @jaygrg111_​, thanks for reaching out, no apologies needed! Hm... the screenshot of the SharepointOnlineConnector does not look correct - you're right.

Would you be able to try uninstalling and re-installing the package? I believe this can be done in FME Options > Packages, you can see which Packages you have installed and then can Remove/Update Packages. After removing the package in FME Options, use the Type to Add function on the workbench canvas to re-install the package, like below:

If the re-install does not help resolve the issue, would you mind submitting a support case with us? We might need to take a closer look at whats going on! Best, Kailin.

Hi @kailinatsafe , Thank you very much for your response. I tried uninstalling and installing it but problem remains the same. I will submit a support case. Thanks alot.