Question

Microsoft SharePoint List Reader issue


Badge +1

Hi @mark2atsafe @andreaatsafe, I am using FME 2018.1.1.1 Build 18578.

I am trying to connect to a Microsoft SharePoint list via SAML since it is a SharePoint Online instance, but am getting the following error message. It is message type '200' which apparently indicates success, but this doesn't seem to be the case here...

Creating reader for format: Microsoft SharePoint List

 

Trying to find a PYTHON plugin for reader named `SHAREPOINT'

Loaded Python module `sharepoint' from file `C:\\Program Files\\FME_Desktop_2018.1.1.1\\plugins/python27\\sharepoint\\__init__.pyc'

Creating reader for format: Microsoft SharePoint List

Trying to find a PYTHON plugin for reader named `SHAREPOINT'

Loaded Python module `sharepoint' from file `C:\\Program Files\\FME_Desktop_2018.1.1.1\\plugins/python27\\sharepoint\\__init__.pyc'

Microsoft SharePoint List Reader: Items Per Request format parameter is set to '5000'

Microsoft SharePoint List Reader: Logging into xxxxx as 'xxxxx' using authentication mode 'SAML'

Microsoft SharePoint List Reader: Error authenticating via SAML. Verify that the username and password are correct, and that this is a SharePoint Online instance. Response message was: '200'

A fatal error has occurred. Check the logfile above for details

Failed to obtain any schemas from reader 'SHAREPOINT' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

UniversalReader -- readSchema resulted in 0 schema features being returned

Reader Parameter(0) = >https://xxxxxxx

Reader Parameter(1) = >USER<

Reader Parameter(2) = >xxxxxxx

Reader Parameter(3) = >PASSWORD<

Reader Parameter(4) = >********<

Reader Parameter(5) = >AUTHENTICATION<

Reader Parameter(6) = >SAML<

Reader Parameter(7) = >HIDDEN_LISTS<

Reader Parameter(8) = >No<

Reader Parameter(9) = >ALL_FIELDS<

Reader Parameter(10) = >No<

Reader Parameter(11) = >_MERGE_SCHEMAS<

Reader Parameter(12) = >YES<

Reader Parameter(13) = >RETRIEVE_ALL_TABLE_NAMES<

Reader Parameter(14) = >YES<

Reader Parameter(15) = >+FME_DEBUG<

Reader Parameter(16) = >DUMP_SCHEMA<

Reader Parameter(17) = >+FME_DEBUG<

Reader Parameter(18) = >BADNEWS<

Reader Parameter(19) = >+FME_DEBUG<

Reader Parameter(20) = >FME_STACK_TRACE<

Reader Parameter(21) = >+FME_DEBUG<

Reader Parameter(22) = >HTTP_DEBUG<

Reader Parameter(23) = >+FME_DEBUG<

Reader Parameter(24) = >FTP_DEBUG<

Reader Directive(0) = >RUNTIME_MACROS<

Reader Directive(1) = >USER,xxxxxx,PASSWORD,********,AUTHENTICATION,SAML,HIDDEN_LISTS,No,ALL_FIELDS,No,_MERGE_SCHEMAS,YES,RETRIEVE_ALL_TABLE_NAMES,YES<

Configuration object contents:

FME Temporary Folder: xxxxxx

mapping file Line 0: `APPLICATION' `FME_WORKBENCH'

mapping file Line 1: `AUTOREG' `YES'

mapping file Line 2: `LOG_MAX_FEATURES' `-1'

mapping file Line 3: `LOG_APPEND' `NO'

mapping file Line 4: `LOG_ENCODING' `UTF-8'

mapping file Line 5: `FME_HOME' `C:\\Program Files\\FME_Desktop_2018.1.1.1\\'

mapping file Line 6: `FME_SESSION_USED' `TRUE'

mapping file Line 7: `R_14_METAFILE' `SHAREPOINT'

mapping file Line 8: `R_14_DATASET' `https://xxxxx

mapping file Line 9: `R_14_USER' `xxxxx

mapping file Line 10: `R_14_AUTHENTICATION' `SAML'

mapping file Line 11: `R_14_HIDDEN_LISTS' `No'

mapping file Line 12: `R_14_ALL_FIELDS' `No'

mapping file Line 13: `R_14__MERGE_SCHEMAS' `YES'

mapping file Line 14: `R_14_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 15: `R_14_+FME_DEBUG' `DUMP_SCHEMA'

mapping file Line 16: `R_14_+FME_DEBUG' `BADNEWS'

mapping file Line 17: `R_14_+FME_DEBUG' `FME_STACK_TRACE'

mapping file Line 18: `R_14_+FME_DEBUG' `HTTP_DEBUG'

mapping file Line 19: `R_14_+FME_DEBUG' `FTP_DEBUG'

mapping file Line 20: `R_14_USER' `xxxxxx

mapping file Line 21: `R_14_AUTHENTICATION' `SAML'

mapping file Line 22: `R_14_HIDDEN_LISTS' `No'

mapping file Line 23: `R_14_ALL_FIELDS' `No'

mapping file Line 24: `R_14__MERGE_SCHEMAS' `YES'

mapping file Line 25: `R_14_MERGE_SCHEMAS' `YES'

mapping file Line 26: `R_14_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 27: `SCHEMA_TIME' `YES'

mapping file Keyword: `R_14_HIDDEN_LISTS' occurs 2 time(s)

mapping file Keyword: `R_14_DATASET' occurs 1 time(s)

mapping file Keyword: `LOG_MAX_FEATURES' occurs 1 time(s)

mapping file Keyword: `LOG_APPEND' occurs 1 time(s)

mapping file Keyword: `R_14_PASSWORD' occurs 2 time(s)

mapping file Keyword: `R_14_MERGE_SCHEMAS' occurs 1 time(s)

mapping file Keyword: `R_14_AUTHENTICATION' occurs 2 time(s)

mapping file Keyword: `R_14_ALL_FIELDS' occurs 2 time(s)

mapping file Keyword: `R_14_METAFILE' occurs 1 time(s)

mapping file Keyword: `AUTOREG' occurs 1 time(s)

mapping file Keyword: `FME_HOME' occurs 1 time(s)

mapping file Keyword: `LOG_ENCODING' occurs 1 time(s)

mapping file Keyword: `APPLICATION' occurs 1 time(s)

mapping file Keyword: `R_14_RETRIEVE_ALL_TABLE_NAMES' occurs 2 time(s)

mapping file Keyword: `SCHEMA_TIME' occurs 1 time(s)

mapping file Keyword: `R_14_USER' occurs 2 time(s)

mapping file Keyword: `R_14__MERGE_SCHEMAS' occurs 2 time(s)

mapping file Keyword: `R_14_+FME_DEBUG' occurs 5 time(s)

mapping file Keyword: `FME_SESSION_USED' occurs 1 time(s)

UniversalReader -- readSchema resulted in 0 schema features being returned

Failed to obtain any schemas from reader 'SHAREPOINT' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information

 

Does anyone have any ideas? I thought in FME 2018.1 the previous issue with the Microsoft SharePoint List reader was resolved.

Thanks,


3 replies

Badge +2

FME does not yet support SAML authentication. We'll post here when it is implemented. See also the Idea

Badge +1

FME does not yet support SAML authentication. We'll post here when it is implemented. See also the Idea

Thanks @markatsafe. Why is there an option for SAML in the Reader? Is it just there in preparation for when it is supported?

@markatsafe Do you have a timeline on when this will be implemented?

Thanks in advance.

Reply