2024.2 yields an error in SharepointOnlineConnector ?

Have you tried uninstalling and reinstalling the package?

If this does not resolve your issue I would submit a ticket.

I don’t want to do that right now, since another virtual machine is running the same workspace with 2024.1 as a scheduled task.

I just upgraded FME 2024 locally to see if there were any issues, before upgrading on the VM.

I guess I found one, so I’m not upgrading FME 2024 on the VM at this time.

I wonder if it is a python version issue. do you have the same python versions installed on each machine and the same version compatibility set?

Asking chatgpt, it suggests that after 3.6 python would begin raising syntax errors when strings with escape characters (“\”) weren’t declared as raw strings.
https://chatgpt.com/share/673e31ac-fd98-800f-b74e-0aecdf38ae84

If changing the python versions doesn’t work (or isn’t possible in your setup) then yes, its definitely something for Safe to investigate!

As far as I can tell, FME 2024.1 and 2024.2 embeds the same Python version: 3.12.

I assume the transformer (SharepointOnlineConnector) uses the embedded Python, so unless 2024.1/3.12 != 2024.2/3.12, I don’t see an issue here.

I have submitted a ticket. It’s probably an easy fix in the code, and may be just a friendly warning, but I would like to be sure before upgrading our production version.

I have also come across this error today.  I haven’t had time to fully examine it as yet but there’s this and also a datetime function deprecation (below - not an FME page but found when searching an error we encountered today in Flow and Form) that have both arisen around FME 2024.2 and python.  I’ve mentioned both to our NZ FME reseller.

https://stackoverflow.com/questions/78634993/why-cant-i-ignore-this-datetime-datetime-utcnow-deprecationwarning

I got this reply from Safe support:

• Our development team has informed me that this warning, logged as an error, is expected and not harmful.
  - and -
  Unfortunately, there aren't any plans to change this behaviour for now.
  This warning is generated from a third-party Python library included with the SharePointOnlineConnector. 
  In FME, SyntaxWarnings generated by third-party Python code are displayed as red error text.
  I have put a note in our system as a possible enhancement request, but these requests don't have a specific timeline.

So this is apparently just a 3rd party warning, that’s unfortunately shown as an error in FME.

This actually looks like a quick fix, that could easily be applied to the SharepointOnlineConnector code.

Interesting.  Unfortunately we have a long-running process with a lot of features being written to ArcGIS Online and the additional logging was causing memory issues on our Flow Hosted server.  Will have to think around that one!

Just updating on my previous comments - that error may be more related to interactions between Flow 2024.2 and ArcGIS Online and not relevant to this thread.  I am uncertain if the SharepointOnlineConnector also triggers this error.

Any updates (or workarounds) for this? Ran into the same issue today.

​@sfb Hi there, sorry to hear you’ve encountered this one! What version of FME Form / Flow are you working with? Is the SharePointOnlineConnector failing in your workspace when you see this warning logged? Or are you still receiving expected results despite the warning?

Hi Natalie. I’m using FME Form v2024.2. I’m able to successfully add the SharePointOnlineConnector transformer to the canvas but the error presents itself when attempting to select the site from within the transformer parameters. I receive the same python syntax error in the log as the OP.

​@sfb Could you please open your FME Workbench 2024.2, then access Tools > FME Options > FME Packages. Single-click on the SharePoint Online package in the list of packages showing, and then check it’s version in the information that populates about the package. What version of the SharePoint Online package are you currently working with?

Thanks for the reply Natalie. I’m using version: safe.microsoft-sharepoint [1.2.2]

​@sfb Sorry to keep on this point, but I just want to confirm one thing. Does this error message completely prevent you from configuring the SharePointOnlineConnector? Or do you receive this error in the translation log window, but you can still select a site for the Site parameter, and carry on configuring the connector? I’m trying to determine if what you’re seeing is something we know about, or something new. Thanks!

No worries Natalie. It does completely prevent me from configuring the Sharepoint connector (see attached pic). Many thanks.