Excute XML Query OBIEE web service

[narne...@gmail.com]

When i use executeXMLQuery webservice it just gives the data with out the Column name or header. Please let me know how to get teh column name in the XML response along with the data.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v7="urn://oracle.bi.webservices/v7">
<soapenv:Header/>
<soapenv:Body>
<v7:executeXMLQuery>
<v7:report>
<v7:reportPath>/shared/Reports/Customer Assigned Roles</v7:reportPath>
<v7:reportXml></v7:reportXml>
</v7:report>
<v7:outputFormat></v7:outputFormat>
<v7:executionOptions>
<v7:async>?</v7:async>
<v7:maxRowsPerPage>?</v7:maxRowsPerPage>
<v7:refresh>TRUE</v7:refresh>
<v7:presentationInfo></v7:presentationInfo>
<v7:type></v7:type>
</v7:executionOptions>
<v7:reportParams>
<!--Zero or more repetitions:-->
<v7:filterExpressions></v7:filterExpressions>
<!--Zero or more repetitions:-->
<v7:variables>
<v7:name></v7:name>
<v7:value></v7:value>
</v7:variables>
<!--Zero or more repetitions:-->
<v7:nameValues>
<v7:name></v7:name>
<v7:value></v7:value>
</v7:nameValues>
<!--Zero or more repetitions:-->
<v7:templateInfos>
<v7:templateForEach></v7:templateForEach>
<v7:templateIterator></v7:templateIterator>
<!--Zero or more repetitions:-->
<v7:instance>
<v7:instanceName></v7:instanceName>
<!--Zero or more repetitions:-->
<v7:nameValues>
<v7:name></v7:name>
<v7:value></v7:value>
</v7:nameValues>
</v7:instance>
</v7:templateInfos>
<!--Optional:-->
<v7:viewName></v7:viewName>
</v7:reportParams>
<v7:sessionID>ljfinj7iplce5v14a5tjtb6ceu632oor8cecnsa</v7:sessionID>
</v7:executeXMLQuery>
</soapenv:Body>
</soapenv:Envelope>

[Robin Moffatt]

Have a look at presentationInfo field in XMLQueryExecutionOptions : https://docs.oracle.com/middleware/11119/biee/BIEIT/structures.htm#BIEIT179

[narne...@gmail.com]

Robin - Appreciate your quick response. I tried that and set the presentation info to TRUE and still getting the result with out column names. Please let me know if i am missing anything.

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:sawsoap="urn://oracle.bi.webservices/v7">
   <soap:Body>
      <sawsoap:executeXMLQueryResult>
         <sawsoap:return xsi:type="sawsoap:QueryResults">
            <sawsoap:rowset xsi:type="xsd:string"><![CDATA[<rowset xmlns="urn:schemas-microsoft-com:xml-analysis:rowset">
    <Row>
        <Column0>ABC</Column0>
        <Column1>123</Column1>
        <Column2>Human Resources</Column2>
        <Column3>HR_WF_Summary</Column3>
        <Column4>Allows a person to see all WF summary data</Column4>
    </Row>
    <Row>
        <Column0>ABC</Column0>
        <Column1>123</Column1>
        <Column2>Oracle BI Apps</Column2>
        <Column3>Global_Dashboards</Column3>
        <Column4>Global Dashboards</Column4>
    </Row>
</rowset>]]></sawsoap:rowset>
            <sawsoap:queryID xsi:type="xsd:string">RSXSf_1</sawsoap:queryID>
            <sawsoap:finished xsi:type="xsd:boolean">true</sawsoap:finished>
         </sawsoap:return>
      </sawsoap:executeXMLQueryResult>
   </soap:Body>
</soap:Envelope>

[Robin Moffatt]

My mistake. It's actually controlled by the value of outputFormat. If you set it to SAWRowsetSchemaAndData or SAWRowsetSchema you'll pull back the headers & data or headers alone respectively. 

An example soap message & response here: https://gist.github.com/rmoff/ff76fb737185a88f3eb5

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Stewart Bryson]

Very nice Gist Robin. Thanks for that.

Stewart

[narne...@gmail.com]

That did the trick! Thanks a ton appreciate your help!!