Share via

3.1.4.3 ApplyPivotSort

  • Article

This operation is used to change the sort order of a PivotTable field in the workbook.

 <wsdl:operation name="ApplyPivotSort">
   <wsdl:input wsam:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplyPivotSort" message="tns:ExcelServiceSoap_ApplyPivotSort_InputMessage"/>
   <wsdl:output wsam:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplyPivotSortResponse" message="tns:ExcelServiceSoap_ApplyPivotSort_OutputMessage"/>
   <wsdl:fault wsam:Action="http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/ExcelServiceSoap/ApplyPivotSortExcelServerMessageFault" name="ExcelServerMessageFault" message="tns:ExcelServiceSoap_ApplyPivotSort_ExcelServerMessageFault_FaultMessage"/>
 </wsdl:operation>

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

  • The protocol client sends the information identifying the PivotTable field in the pivotOperationOptions element.

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

  • "DclNotTrusted"

  • "ErrorAccessingSsoFromEcs"

  • "ErrorAccessingSsofromWfe"

  • "ErrorConnectingToDataSource"

  • "ErrorConnectingToDataSourceReadOrViewOnly"

  • "ExternalDataNotAllowedOnTL"

  • "ExternalDataRefreshFailed"

  • "ExternalDataRefreshFailed_Details"

  • "ExternalDataRefreshFailedReadOrViewOnly"

  • "ExternalDataRefreshFailedReal"

  • "IncorrectAuthUsed"

  • "InvalidUriorLocalConnectionPath"

  • "InvalidUserNameOrPassword"

  • "InvalidUserNameOrPasswordReadOrViewOnly"

  • "NoAccessToOdcReadOrViewOnly"

  • "OdcFileDoesNotExist"

  • "UnattendedAccountNotConfigured"