3.1.4.31 TogglePivotDrill

This operation is used to expand or collapse a PivotTable member.

 <wsdl:operation name="TogglePivotDrill">
     <wsdl:input message="TogglePivotDrillSoapIn" />
     <wsdl:output message="TogglePivotDrillSoapOut" />
 </wsdl:operation>

The protocol client sends a TogglePivotDrillSoapIn request message, and the protocol server responds with a TogglePivotDrillSoapOut response message, as follows:

1. The protocol client sends the PivotTable member to be expanded or collapsed in the pivotFilterOptions element.

2. The protocol server expands the PivotTable member if it was collapsed. The protocol server collapses the PivotTable member if it was expanded.

In the event of an application error on the protocol server during this operation, the protocol server MUST return an ExcelServerMessage as specified in section 2.2.9.2. The id element of the ExcelServerMessage MUST be one of the values specified in section 2.2.9.4, and SHOULD<46> be one of the values described in the following table.

Id	Description
InvalidOrTimedOutSession	See section 2.2.9.5.
RetryError	See section 2.2.9.5.
OperationCanceled	See section 2.2.9.5.
InternalError	See section 2.2.9.5.
MultipleRequestsOnSession	See section 2.2.9.5.
MaxRequestDurationExceeded	See section 2.2.9.5.