Hi, I am having issues connecting to a sharepoint site. I get an error 401-- Client access error.I confirmed having access via manually reviewing the site. Any pointers? or ways to trouble shoot?I am using FME 2016 or FME 2017Thanks in advanced.

Sharepoint issues 401

There were issues with the Sharepoint Online list reader. It should be solved in FME2017.1.2.1 and in FME2018

Thank you. I will have to wait to upgrade FME server before I can try it out.

SharePoint Online's authentication changed again recently, which broke how our reader and writer authenticated with it. We've made a fix in FME 2018.0 18291+ and FME 2018.1 betas 18449+.

Do you guys know if the authentication changed again? I just installed

FME(R) 2018.1.0.1 (20180730 - Build 18528 - WIN64 and have manual access but not via FME. Thoughts?

Do you guys know if the authentication changed again? I just installed

FME(R) 2018.1.0.1 (20180730 - Build 18528 - WIN64 and have manual access but not via FME. Thoughts?

Same here,cant for the life of me get it to log in, worked not that long ago. 2018.1.0.3 (20180926 - Build 18552 - WIN64)

2018.01 version still has this issue

Hi @jrogers,

Sorry to hear you are encountering an issue with accessing Sharepoint data. To help us debug the issue, we need some further information:

Please share the full log file with the error message you are receiving
What version of Sharepoint are you connecting to?
What is the authentication method you are using? Do you have any proxy settings?

2018.01 version still has this issue

Sharepoint Office 365 2013

Creating reader for format: Microsoft SharePoint List

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

Using Python interpreter from `C:\\Program Files\\FME\\fmepython27\\python27.dll' with PYTHONHOME `C:\\Program Files\\FME\\fmepython27'

Python version 2.7 loaded successfully

Loaded Python module `sharepoint' from file `C:\\Program Files\\FME\\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\\plugins/python27\\sharepoint\\__init__.pyc'

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

Microsoft SharePoint List Reader: Using proxy http://amrbasic-proxy.bp.com:80/

Microsoft SharePoint List Reader: Logging into 'https://bp365.sharepoint.com/sites/RMO' as '' using authentication mode 'SAML'

Microsoft SharePoint List Reader: Client-side error: '403 Client Error: Forbidden for url: https://bp365.sharepoint.com/sites/RMO/_api/web/Lists?%24select=Title%2CId' returned from SharePoint. Error message was: 'Access denied. You do not have permission to perform this action or access this resource.'

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://bp365.sharepoint.com/sites/RMO<

Reader Parameter(1) = >USER<

Reader Parameter(2) = ><

Reader Parameter(3) = >PASSWORD<

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

Reader Parameter(5) = >AUTHENTICATION<

Reader Parameter(6) = >SAML<

Reader Parameter(7) = >HIDDEN_LISTS<

Reader Parameter(8) = >Yes<

Reader Parameter(9) = >ALL_FIELDS<

Reader Parameter(10) = >Yes<

Reader Parameter(11) = >_MERGE_SCHEMAS<

Reader Parameter(12) = >YES<

Reader Parameter(13) = >RETRIEVE_ALL_TABLE_NAMES<

Reader Parameter(14) = >YES<

Reader Directive(0) = >RUNTIME_MACROS<

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

Configuration object contents:

FME Temporary Folder: C:\\Users\\roj72w\\AppData\\Local\\Temp

mapping file Line 0: `APPLICATION' `FME_WORKBENCH'

mapping file Line 1: `AUTOREG' `YES'

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

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

mapping file Line 4: `LOG_APPEND' `NO'

mapping file Line 5: `FME_HOME' `C:\\Program Files\\FME\\'

mapping file Line 6: `FME_SESSION_USED' `TRUE'

mapping file Line 7: `R_1_METAFILE' `SHAREPOINT'

mapping file Line 8: `R_1_DATASET' `https://bp365.sharepoint.com/sites/RMO'

mapping file Line 9: `R_1_USER' `'

mapping file Line 10: `R_1_AUTHENTICATION' `SAML'

mapping file Line 11: `R_1_HIDDEN_LISTS' `Yes'

mapping file Line 12: `R_1_ALL_FIELDS' `Yes'

mapping file Line 13: `R_1__MERGE_SCHEMAS' `YES'

mapping file Line 14: `R_1_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 15: `R_1_USER' `'

mapping file Line 16: `R_1_AUTHENTICATION' `SAML'

mapping file Line 17: `R_1_HIDDEN_LISTS' `Yes'

mapping file Line 18: `R_1_ALL_FIELDS' `Yes'

mapping file Line 19: `R_1__MERGE_SCHEMAS' `YES'

mapping file Line 20: `R_1_MERGE_SCHEMAS' `YES'

mapping file Line 21: `R_1_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 22: `SCHEMA_TIME' `YES'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

mapping file Keyword: `APPLICATION' 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

Creating reader for format: Microsoft SharePoint List

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

Using Python interpreter from `C:\\Program Files\\FME\\fmepython27\\python27.dll' with PYTHONHOME `C:\\Program Files\\FME\\fmepython27'

Python version 2.7 loaded successfully

Loaded Python module `sharepoint' from file `C:\\Program Files\\FME\\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\\plugins/python27\\sharepoint\\__init__.pyc'

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

Microsoft SharePoint List Reader: Using proxy http://amrbasic-proxy.bp.com:80/

Microsoft SharePoint List Reader: Logging into 'https://bp365.sharepoint.com/sites/RMO' as '' using authentication mode 'SAML'

Microsoft SharePoint List Reader: Client-side error: '403 Client Error: Forbidden for url: https://bp365.sharepoint.com/sites/RMO/_api/web/Lists?%24select=Title%2CId' returned from SharePoint. Error message was: 'Access denied. You do not have permission to perform this action or access this resource.'

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://bp365.sharepoint.com/sites/RMO<

Reader Parameter(1) = >USER<

Reader Parameter(2) = ><

Reader Parameter(3) = >PASSWORD<

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

Reader Parameter(5) = >AUTHENTICATION<

Reader Parameter(6) = >SAML<

Reader Parameter(7) = >HIDDEN_LISTS<

Reader Parameter(8) = >Yes<

Reader Parameter(9) = >ALL_FIELDS<

Reader Parameter(10) = >Yes<

Reader Parameter(11) = >_MERGE_SCHEMAS<

Reader Parameter(12) = >YES<

Reader Parameter(13) = >RETRIEVE_ALL_TABLE_NAMES<

Reader Parameter(14) = >YES<

Reader Directive(0) = >RUNTIME_MACROS<

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

Configuration object contents:

FME Temporary Folder: C:\\Users\\roj72w\\AppData\\Local\\Temp

mapping file Line 0: `APPLICATION' `FME_WORKBENCH'

mapping file Line 1: `AUTOREG' `YES'

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

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

mapping file Line 4: `LOG_APPEND' `NO'

mapping file Line 5: `FME_HOME' `C:\\Program Files\\FME\\'

mapping file Line 6: `FME_SESSION_USED' `TRUE'

mapping file Line 7: `R_1_METAFILE' `SHAREPOINT'

mapping file Line 8: `R_1_DATASET' `https://bp365.sharepoint.com/sites/RMO'

mapping file Line 9: `R_1_USER' `'

mapping file Line 10: `R_1_AUTHENTICATION' `SAML'

mapping file Line 11: `R_1_HIDDEN_LISTS' `Yes'

mapping file Line 12: `R_1_ALL_FIELDS' `Yes'

mapping file Line 13: `R_1__MERGE_SCHEMAS' `YES'

mapping file Line 14: `R_1_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 15: `R_1_USER' `'

mapping file Line 16: `R_1_AUTHENTICATION' `SAML'

mapping file Line 17: `R_1_HIDDEN_LISTS' `Yes'

mapping file Line 18: `R_1_ALL_FIELDS' `Yes'

mapping file Line 19: `R_1__MERGE_SCHEMAS' `YES'

mapping file Line 20: `R_1_MERGE_SCHEMAS' `YES'

mapping file Line 21: `R_1_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 22: `SCHEMA_TIME' `YES'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

mapping file Keyword: `APPLICATION' 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

Thanks for sharing the log file @jrogers. Can you confirm what kind of authentication your sharepoint uses? Does it use active directory federated services? You may need to check with your IT team at your organization.

Creating reader for format: Microsoft SharePoint List

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

Using Python interpreter from `C:\\Program Files\\FME\\fmepython27\\python27.dll' with PYTHONHOME `C:\\Program Files\\FME\\fmepython27'

Python version 2.7 loaded successfully

Loaded Python module `sharepoint' from file `C:\\Program Files\\FME\\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\\plugins/python27\\sharepoint\\__init__.pyc'

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

Microsoft SharePoint List Reader: Using proxy http://amrbasic-proxy.bp.com:80/

Microsoft SharePoint List Reader: Logging into 'https://bp365.sharepoint.com/sites/RMO' as '' using authentication mode 'SAML'

Microsoft SharePoint List Reader: Client-side error: '403 Client Error: Forbidden for url: https://bp365.sharepoint.com/sites/RMO/_api/web/Lists?%24select=Title%2CId' returned from SharePoint. Error message was: 'Access denied. You do not have permission to perform this action or access this resource.'

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://bp365.sharepoint.com/sites/RMO<

Reader Parameter(1) = >USER<

Reader Parameter(2) = ><

Reader Parameter(3) = >PASSWORD<

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

Reader Parameter(5) = >AUTHENTICATION<

Reader Parameter(6) = >SAML<

Reader Parameter(7) = >HIDDEN_LISTS<

Reader Parameter(8) = >Yes<

Reader Parameter(9) = >ALL_FIELDS<

Reader Parameter(10) = >Yes<

Reader Parameter(11) = >_MERGE_SCHEMAS<

Reader Parameter(12) = >YES<

Reader Parameter(13) = >RETRIEVE_ALL_TABLE_NAMES<

Reader Parameter(14) = >YES<

Reader Directive(0) = >RUNTIME_MACROS<

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

Configuration object contents:

FME Temporary Folder: C:\\Users\\roj72w\\AppData\\Local\\Temp

mapping file Line 0: `APPLICATION' `FME_WORKBENCH'

mapping file Line 1: `AUTOREG' `YES'

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

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

mapping file Line 4: `LOG_APPEND' `NO'

mapping file Line 5: `FME_HOME' `C:\\Program Files\\FME\\'

mapping file Line 6: `FME_SESSION_USED' `TRUE'

mapping file Line 7: `R_1_METAFILE' `SHAREPOINT'

mapping file Line 8: `R_1_DATASET' `https://bp365.sharepoint.com/sites/RMO'

mapping file Line 9: `R_1_USER' `'

mapping file Line 10: `R_1_AUTHENTICATION' `SAML'

mapping file Line 11: `R_1_HIDDEN_LISTS' `Yes'

mapping file Line 12: `R_1_ALL_FIELDS' `Yes'

mapping file Line 13: `R_1__MERGE_SCHEMAS' `YES'

mapping file Line 14: `R_1_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 15: `R_1_USER' `'

mapping file Line 16: `R_1_AUTHENTICATION' `SAML'

mapping file Line 17: `R_1_HIDDEN_LISTS' `Yes'

mapping file Line 18: `R_1_ALL_FIELDS' `Yes'

mapping file Line 19: `R_1__MERGE_SCHEMAS' `YES'

mapping file Line 20: `R_1_MERGE_SCHEMAS' `YES'

mapping file Line 21: `R_1_RETRIEVE_ALL_TABLE_NAMES' `YES'

mapping file Line 22: `SCHEMA_TIME' `YES'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

mapping file Keyword: `APPLICATION' 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

Our Sharepoint folks say

We’re using the O365 Organizational authentication…

Is there something more specific that you need?

Justin

Reply

Community Stats

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded