Question

Microsoft SharePoint List Reader issue

Forum|Forum|6 years ago
May 24, 2019
3 replies
29 views

+1

aquamarine

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,

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.