Problems integrating Mule with SharePoint online and on-premises ADFS -
i need read , write sharepoint lists mule.
setup following: mule 3.6, sharepoint online 2013 on-premises adfs.
web access sharepoint works, user going through following urls sequence:
- i open saved sharepoint site page --
https://[company].sharepoint.com/sites/.../collab/... - i automatic redirect
https://login.microsoftonline.com/login.srf?... - after type in email, automatic redirect "organization's sign-in page" --
https://adfs.[company].com/adfs/ls/?... - i type in email , password there , automatically redirected
login.microsoftonline.com,[company].sharepoint.com, i'm able see lists.
in mule, i'm using sharepoint 2013 connector in "claims connection" mode.
configuration follows:
<sharepoint:claims-connection-config disablecncheck="true" name="microsoft_sharepoint_2013__claims_connection" username="[user email]" password="[password]" siteurl="https://[company].sharepoint.com/sites/[site]/" stsurl="https://adfs.[company].com/adfs/services/trust/13/usernamemixed" scope="urn:federation:microsoftonline" doc:name="microsoft sharepoint 2013: claims connection" /> parameter "scope" found out adfs.[company].com/adfs/ls/?... url's parameter wtrealm.
operation i'm trying perform following:
<sharepoint:list-get config-ref="microsoft_sharepoint_2013__claims_connection" doc:name="microsoft sharepoint 2013" listid="f93ef42e-1faf-4cb3-8d7f-ebfc76cbdb3c" /> list id found out web, user has access list.
both when clicking "test connection" , when running flow i'm getting following exception:
org.mule.api.connectionexception: code: 403 message: {"error":{"code":"-2147024891, system.unauthorizedaccessexception","message":{"lang":"en-us","value":"access denied. not have permission perform action or access resource."}}} @ org.mule.module.sharepoint.connection.basesharepointconnectionstrategy.connect(basesharepointconnectionstrategy.java:83) ~[?:?] @ org.mule.module.sharepoint.connectivity.claimsconnectionstrategysharepointconnectoradapter.connect(claimsconnectionstrategysharepointconnectoradapter.java:21) ~[?:?] @ org.mule.module.sharepoint.connectivity.claimsconnectionstrategysharepointconnectoradapter.connect(claimsconnectionstrategysharepointconnectoradapter.java:9) ~[?:?] @ org.mule.devkit.3.6.1.shade.connection.management.connectionmanagementconnectorfactory.makeobject(connectionmanagementconnectorfactory.java:47) ~[?:?] @ org.mule.devkit.3.6.1.shade.connection.management.connectionmanagementconnectorfactory.makeobject(connectionmanagementconnectorfactory.java:15) ~[?:?] @ org.apache.commons.pool.impl.generickeyedobjectpool.borrowobject(generickeyedobjectpool.java:1220) ~[commons-pool-1.6.jar:1.6] @ org.mule.module.sharepoint.connectivity.sharepointconnectorclaimsconnectionconfigconnectionmanagementconnectionmanager.acquireconnection(sharepointconnectorclaimsconnectionconfigconnectionmanagementconnectionmanager.java:269) ~[?:?] @ org.mule.module.sharepoint.connectivity.sharepointconnectorclaimsconnectionconfigconnectionmanagementconnectionmanager.acquireconnection(sharepointconnectorclaimsconnectionconfigconnectionmanagementconnectionmanager.java:58) ~[?:?] @ org.mule.devkit.3.6.1.shade.connection.management.connectionmanagementprocessinterceptor.execute(connectionmanagementprocessinterceptor.java:47) ~[?:?] @ org.mule.devkit.3.6.1.shade.connection.management.connectionmanagementprocessinterceptor.execute(connectionmanagementprocessinterceptor.java:19) ~[?:?] @ org.mule.security.oauth.process.retryprocessinterceptor.execute(retryprocessinterceptor.java:84) ~[mule-module-devkit-support-3.6.0.jar:3.6.0] @ org.mule.devkit.3.6.1.shade.connection.management.connectionmanagementprocesstemplate.execute(connectionmanagementprocesstemplate.java:33) ~[?:?] ... investigation has shown exception isn't first error mule gets sharepoint.
after connecting https://adfs.[company].com/adfs/services/trust/13/usernamemixed/ , obtaining token, mule performs post https://[company].sharepoint.com/sites/.../_trust/. url answers http 200 ok, html containing "sorry, went wrong" , "an unexpected error has occurred" messages.
don't know why, maybe because of code 200, mule ignores , proceeds making request https://[company].sharepoint.com/sites/.../_api/web/id, returns 403 exception mentioned above.
any troubleshooting connection process appreciated.
the newest microsoft sharepoint 2013 connector, version 2.1.8 released 2015-10-06, able connect sharepoint online users on-prem ad fs.
personally, used "online" configuration type. not sure claim-type auth.
Comments
Post a Comment