Share via

3.1.4.52 GetPivotFieldListData

  • Article

This operation is used to get the PivotTable fields that are associated with a PivotTable or PivotChart.

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

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

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

  1. The protocol client sends information that identifies the PivotTable or PivotChart in the pivotOperationOptions element, type information in the type element, version information in the version element, and measure group information in the measureGroup element.

  2. The protocol server uses this information to get the PivotTable fields that are associated with the PivotTable or PivotChart.

This operation is not 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<69> be one of the values specified in section 2.2.2.1.