This operation is used to return the slicer items and formatting information for the slicer visual components that are part of a slicer.

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

 <wsdl:operation name="ConnectAndGetSlicerItemList" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input wsaw:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ConnectAndGetSlicerItemList" message="tns:ExcelServiceSoap_ConnectAndGetSlicerItemList_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/ConnectAndGetSlicerItemListResponse" message="tns:ExcelServiceSoap_ConnectAndGetSlicerItemList_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/ConnectAndGetSlicerItemListExcelServerMessageFault" name="ExcelServerMessageFault" message="tns:ExcelServiceSoap_ConnectAndGetSlicerItemList_ExcelServerMessageFault_FaultMessage" xmlns:wsaw="http://www.w3.org/2006/05/addressing/wsdl"/>

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

  1. The protocol client sends the information identifying the slicer in the slicerOptions element.

  2. If the data source for the slicer is OLAP then the protocol server will connect to the data source to obtain the requested slicer items. Otherwise the protocol server will behave the same as in GetSlicerItemList (section

  3. The protocol server returns a SlicerItemList (section in itemList, as follows:

    • If the SlicerItemsOffset element of the slicerOptions element is equal to -1 then the protocol server will determine the first slicer item in the resulting itemList in the following way:

      • If a call to ApplySlicerSelection was made in the current session, then the protocol server will determine the first slicer item in the resulting itemList as follows:

        • It will take the floor of the value obtained by taking the value of the of the SlicerItemsOffset element of the slicerOptions element of the last call to ApplySlicerSelection, and dividing it by the number of visible slicer items.

        • From this value, the protocol server will subtract 2.

        • To the resulting value, the protocol server will multiple by the number of visible slicer items.

        • Finally, the protocol server will take the maximum of this value and 0, and get the first slicer item.

      • Otherwise, if a call was not made to ApplySlicerSelection in the current session, the protocol server will use the value in the startItem attribute in CT_Slicer ([MS-XLSX] section 2.6.68).

    • If SlicerItemsCount is equal to -1 then the lesser of total number of slicer items or 5 times the visible number of items is returned.

  4. If SlicerItemsOffset is equal to -1, the protocol server returns a SlicerFormatElementList (section in formatList that MUST contain 10 elements as specified in section Otherwise the protocol server MUST return a formatList with 0 elements.

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<19> be one of the values specified in section or any of the following values:

  • DclNotTrusted

  • ErrorAccessingSsoFromEcs

  • ErrorConnectingToDataSource

  • ErrorConnectingToDataSourceReadOrViewOnly

  • ExternalDataNotAllowedOnTL

  • ExternalDataRefreshFailed

  • ExternalDataRefreshFailed_Details

  • ExternalDataRefreshFailedReadOrViewOnly

  • ExternalDataRefreshFailedReal

  • IncorrectAuthUsed

  • InvalidUriorLocalConnectionPath

  • InvalidUserNameOrPassword

  • InvalidUserNameOrPasswordReadOrViewOnly

  • NoAccessToOdcReadOrViewOnly

  • OdcFileDoesNotExist

  • UnattendedAccountNotConfigured