Data from analysis to be returned as CSV when issuing a SOAP request — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data from analysis to be returned as CSV when issuing a SOAP request

edited Oct 23, 2019 11:24AM in Reporting and Analytics for HCM 2 comments

Content

Hi,

I have a SOAP request in PHP as follows:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/&quot; xmlns:v7="urn://oracle.bi.webservices/v7">
   <soapenv:Header/>
   <soapenv:Body>
      <v7:executeXMLQuery>
         <v7:report>
            <v7:reportPath>/shared/Custom/Digital/MyResources/HCM_DATA</v7:reportPath>
            <v7:reportXml></v7:reportXml>
         </v7:report>
         <v7:outputFormat>String CSV</v7:outputFormat>
         <v7:executionOptions>
            <v7:async></v7:async>
            <v7:maxRowsPerPage></v7:maxRowsPerPage>
            <v7:refresh></v7:refresh>
            <v7:presentationInfo></v7:presentationInfo>
            <v7:type></v7:type>
         </v7:executionOptions>
           <v7:sessionID>'.$sessionID.'</v7:sessionID>
      </v7:executeXMLQuery>
   </soapenv:Body>
</soapenv:Envelope>
This delivers a XML file - I was wondering whether it was possible to get a CSV file instead?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!