Share via

3.1.4.2 ApplyPivotFilter

  • Article

This operation is used to apply a PivotTable custom filter or a PivotTable manual filter on a PivotTable field.

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

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

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

  1. The protocol client sends the PivotTable custom filter or PivotTable manual filter to be applied, and the information identifying the PivotTable field in the pivotOperationOptions element.

  2. The protocol server applies the PivotTable custom filter or PivotTable manual filter to the PivotTable field.

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<11> 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

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