This topic provides a description of the components of a Query API SOAP response.
Every Query API SOAP response contains the following static elements:
All query results from the Query API service will be contained in this response body:
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"> <S:Header/> <S:Body> <ns2:executeResultSetQueryResponse xmlns:ns2="http://www.bea.com/analytics/AnalyticsQueryService"> <return> </return> </ns2:executeResultSetQueryResponse> </S:Body> </S:Envelope>
The results of the query are contained within the <return> element. These elements are:
This element represents one row of the result set. It contains a <values> element for each column in the result set. Each <values> element can be of any type, and the actual type is specified in the element attributes. When the result set has multiple columns, the <values> elements are in the same sequence as the <columns> elements.
This element describes one column of the result set.
The following is an example Query API SOAP response. This is a possible response to the request in the request example in The Query API SOAP Request
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"> <S:Header/> <S:Body> <ns2:executeResultSetQueryResponse xmlns:ns2="http://www.bea.com/analytics/AnalyticsQueryService"> <return> <results> <values xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:int">7</values> <values xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">Publisher Administration</values> <values xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:int">246</values> <count>0</count> </results> <columns>count(*)</columns> <columns>portlet.name</columns> <columns>portlet.id</columns> </return> </ns2:executeResultSetQueryResponse> </S:Body> </S:Envelope>