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 2017
Thanks in advanced.
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 2017
Thanks in advanced.
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
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:
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.