Skip to main content
Solved

I am trying to download PDFs maps from SharePoint. Using HTTP Caller I don't see any PDFs downloaded. in the folder. I have made the web connection to SharePoint already. I wonder if I am using the correct transformer? Attached are the WS and image


jaygrg111_
Contributor
Forum|alt.badge.img+6

HTTP Caller Parameters

Best answer by kailinatsafe

jaygrg111_ wrote:

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.

View original
Did this help you find an answer to your question?

11 replies

kailinatsafe
Safer
Forum|alt.badge.img+21

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.


jaygrg111_
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • June 12, 2023
kailinatsafe wrote:

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.


kailinatsafe
Safer
Forum|alt.badge.img+21
  • Safer
  • Best Answer
  • June 13, 2023
jaygrg111_ wrote:

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.


jaygrg111_
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • June 13, 2023
jaygrg111_ wrote:

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.

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.


kailinatsafe
Safer
Forum|alt.badge.img+21
jaygrg111_ wrote:

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_​, 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!

imageOnce 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:

imageSelect your newly created web service and authenticate

 

imageNow 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


jaygrg111_
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • June 19, 2023
jaygrg111_ wrote:

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.

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.


kailinatsafe
Safer
Forum|alt.badge.img+21
jaygrg111_ wrote:

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_​, thanks for the update! Glad you were able to successfully connect. You should see the 'Download' action within the SharepointOnlineConnector itself:

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


jaygrg111_
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • June 21, 2023
jaygrg111_ wrote:

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.

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


jaygrg111_
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • June 29, 2023
jaygrg111_ wrote:

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.

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!


kailinatsafe
Safer
Forum|alt.badge.img+21
jaygrg111_ wrote:

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_​, 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:

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


jaygrg111_
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • June 29, 2023
jaygrg111_ wrote:

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.

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.


Reply


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