Share via

3.1.4.5 ApplySlicerSelection

  • Article

This operation is used to update the state of the slicer items that are part of a slicer.

The following is the WSDL port type specification of the ApplySlicerSelection WSDL operation.

 <wsdl:operation name="ApplySlicerSelection" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelection" message="tns:ExcelServiceSoap_ApplySlicerSelection_InputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:output wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelectionResponse" message="tns:ExcelServiceSoap_ApplySlicerSelection_OutputMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
   <wsdl:fault wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplySlicerSelectionExcelServerMessageFault" name="ExcelServerMessageFault" message="tns:ExcelServiceSoap_ApplySlicerSelection_ExcelServerMessageFault_FaultMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>
 </wsdl:operation>

The protocol client sends an ExcelServiceSoap_ApplySlicerSelection_InputMessage request message, and the protocol server responds with an ExcelServiceSoap_ApplySlicerSelection_OutputMessage response message, as follows:

  1. The protocol client sends the information identifying the slicer and the slicer items that will be selected and unselected in the slicerOptions element.

  2. The protocol server updates the state of the slicer items in the slicer.

This operation is a state changing operation on the protocol server.

In the event of an application error on the protocol server during this operation, a SOAP fault is returned, as specified in section 2.2.2. The Id element of the ExcelServerMessage SHOULD<14> be one of the values specified in section 2.2.2.1 or any of the following values.

  • DclNotTrusted

  • ErrorAccessingSsoFromEcs

  • ErrorConnectingToDataSource

  • ErrorConnectingToDataSourceReadOrViewOnly

  • ExternalDataNotAllowedOnTL

  • ExternalDataRefreshFailed

  • ExternalDataRefreshFailed_Details

  • ExternalDataRefreshFailedReadOrViewOnly

  • ExternalDataRefreshFailedReal

  • IncorrectAuthUsed

  • InvalidUriorLocalConnectionPath

  • InvalidUserNameOrPassword

  • InvalidUserNameOrPasswordReadOrViewOnly

  • NoAccessToOdcReadOrViewOnly

  • OdcFileDoesNotExist

  • UnattendedAccountNotConfigured