0
Answered

Filter on SharePoint Connector

Matthew Woolnough 11 years ago in UNIFYBroker/Microsoft SharePoint updated by anonymous 9 years ago 5

Is it possible to filter out list items from a SharePoint list?

I want to use the EmployeeID in the DN, however it will not be populated initially, which means not all list items will have a value. This will result in errors being thrown & I'd like to avoid this.

If this is not already possible, can you advise on how long it would take to implement.

OK, When specifying a viewName, is it still necessary to specify the listName (config below)? When I specify both I get the following error:

20130910,02:19:27,Change detection engine import all items failed.,Change detection engine,Warning,"Change detection engine import all items for connector SharePoint eMinerva Exceptions Connector failed with reason Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.. Duration: 00:00:02.5059556
Error details:
System.Web.Services.Protocols.SoapException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Unify.Communicators.ListService.Lists.GetListItems(String listName, String viewName, XmlNode query, XmlNode viewFields, String rowLimit, XmlNode queryOptions, String webID)
   at Unify.Communicators.Moss2007ListWebServiceCommunicatorBase.<GetListItems>d__f.MoveNext()
   at Unify.Connectors.MossListConnector.<GetAllEntities>d__1a.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnFirst>d__1c`1.MoveNext()
   at System.Linq.Enumerable.WhereSelectEnumerableIterator`2.MoveNext()
   at Unify.Framework.ActionOnExceptionEnumerator`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ActionOnLast>d__16`1.MoveNext()
   at Unify.Framework.EnumerableExtensions.<ProduceAutoPages>d__9`1.MoveNext()
   at Unify.Framework.Visitor.ThreadsafeVisitorEvaluator`1.Visit()
   at Unify.Framework.Visitor.VisitEvaluateOnThreadPool[T](IEnumerable`1 visitCollection, Action`2 visitor, Int32 maxThreads)
   at Unify.Framework.RepositoryChangeDetectionWorkerBase.PerformChangeDetection(IEnumerable`1 connectorEntities)
   at Unify.Framework.ChangeDetectionImportAllJob.ImportAllChangeProcess()
   at Unify.Framework.ChangeDetectionImportAllJob.RunBase()
   at Unify.Framework.MutexJobDecorator.Run()
   at Unify.Framework.DefinedScopeJobAuditTrailJobDecorator.Run()
   at Unify.Framework.AsynchronousJobExecutor.PerformJobCallback(Object state)",Normal
		  <communicator
							ignoreCertificateError="True"
							pollingChangeTokenOffset="-1.00:00:00"
							credentials="Custom"
							proxy="Default"
							preauthenticate="true"
							timeout="02:00:00"
							proxyUri=""
							uri="http://kweb.bne.catholic.edu.au/informationservices/SSAS/SSA/"
							domain="CATHOLIC"	
							user="svc_FIM_SharePoint"
							securePassword="TE+bBSNefb5uHPQAhhSpsw==" certificate="" listName="eMinerva Exceptions" viewName="IdentityManagement" rowLimit="100">
			  </communicator>

No, just the view name.

This support issue has remained resolved for 2 weeks. Please check the status of the issue and close or readdress the issue if necessary.

Closing this issue as it has been resolved and is now inactive. If this issue has not been resolved, please reopen or log a new issue accordingly.