Clarity

  • 1.  Not able to fetch data from CA Clarity

    Posted Jul 29, 2015 09:59 AM

    Hi Everyone,

    I'm using CA Clarity 14.2 to fetch data in java using Webservice api which is available @ https://<server>:port/niku/wsdl, so using soapui to request and get response to check data but facing some fatal issue as shown below:

    Soap Request:

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:obj="http://www.niku.com/xog/Object">

       <soapenv:Header>

          <obj:Auth>

             <!--Optional:-->

            

          <obj:SessionID>5175050__CFD78C77-A46F-4783-A3F7-7A65CA97F945</obj:SessionID></obj:Auth>

       </soapenv:Header>

       <soapenv:Body>

          <obj:ReadProject>

          </obj:ReadProject>

       </soapenv:Body>

    </soapenv:Envelope>

     

    Soap Response :

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

       <soapenv:Header/>

       <soapenv:Body>

          <ReadProjectResponse xmlns="http://www.niku.com/xog/Object">

             <XOGOutput xsi:noNamespaceSchemaLocation="../xsd/status.xsd">

                <Status elapsedTime="0.0 seconds" state="FAILURE"/>

                <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>

                <ErrorInformation>

                   <Severity>FATAL</Severity>

                   <Description>Missing NikuDataBus request document</Description>

                   <Exception/>

                </ErrorInformation>

             </XOGOutput>

          </ReadProjectResponse>

       </soapenv:Body>

    </soapenv:Envelope>

     

    So can anyone please provide the reason which i'm missing.

     

    Regards,

    Deepak Gupta



  • 2.  Re: Not able to fetch data from CA Clarity

    Posted Aug 06, 2015 01:54 PM

    Are you using the CA API Gateway to access this API or accessing it directly from SoapUI? I want to make sure that this question is posted in the appropriate community. Thanks!



  • 3.  Re: Not able to fetch data from CA Clarity

    Posted Aug 12, 2015 12:57 PM

    I moved this question to the CA PPM Community.



  • 4.  Re: Not able to fetch data from CA Clarity
    Best Answer

    Posted Aug 12, 2015 02:01 PM

    Between these lines/elements:

     

    ...

          <obj:ReadProject>

          </obj:ReadProject>

    ...

     

    Needs to go your XOG-formatted request document.

     

    If you have installed the XOG client you will find it comes with a folder named 'xml' containing examples of many different XOG-formatted request documents.

     

    For your specific web service call (ReadProject) you probably want to refer to file prj_projects_read.xml in that folder.

     

    Then include this in your web service call like the following (replacing your criteria as preferred):

     

    ...

          <obj:ReadProject>

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
      <Header version="6.0.11" action="read" objectType="project" externalSource="NIKU">
        <!-- you change the order by simply swap 1 and 2 number in the name attribute -->
        <args name="order_by_1" value="name"/>
        <args name="order_by_2" value="projectID"/>
        <args name="include_tasks" value="true"/>
        <args name="include_dependencies" value="true"/>
        <args name="include_subprojects" value="true"/>
        <args name="include_resources" value="true"/>
        <args name="include_baselines" value="true"/>
        <args name="include_allocations" value="true"/>
        <args name="include_estimates" value="true"/>
        <args name="include_actuals" value="true"/>
        <args name="include_custom" value="true"/>
        <args name="include_burdening" value="false"/>
      </Header>
      <Query>

          <Filter name="projectID" criteria="EQUALS">test</Filter>
      </Query>
    </NikuDataBus>

          </obj:ReadProject>

    ...

     

    Please try incorporating this and see if you can get anything.  Remember to change the criteria 'test' to an actual project ID from Clarity that your SOAP/XOG user actually has permissions to view, otherwise it still may not return results.



  • 5.  Re: Not able to fetch data from CA Clarity

    Posted Aug 13, 2015 12:49 AM

    Thanks Nick, now able to do swiftly .