AnsweredAssumed Answered

Web Service for Query (NSQL)

Question asked by rdasilva on Feb 8, 2011
Latest reply on Feb 6, 2013 by riteshkumar
I have built a working Query object (NSQL), but when trying to use the Web Services to retrieve data, get the following error:

<Description>Exception while processing client request</Description>
<Exception type="com.niku.xog.XOGException"><![CDATA[com.niku.xog.XOGException: Invalid query

at com.niku.xog.service.QueryHandler.process(QueryHandler.java:109)

at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:114)

at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:266)

Web Service call :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:quer="http://www.niku.com/xog/Query">
   <soapenv:Header>
      <quer:Auth>
         <!--Optional:-->
         <quer:SessionID></quer:SessionID>
         <!--Optional:-->
         <quer:Username>username</quer:Username>
         <!--Optional:-->
         <quer:Password>password</quer:Password>
      </quer:Auth>
   </soapenv:Header>
   <soapenv:Body>
      <quer:Query>
         <quer:Code></quer:Code>
         <!--Optional:-->
         <quer:Filter>
            <!--Optional:-->
            <quer:prjid></quer:prjid>
            <!--Optional:-->
            <quer:prjid_from></quer:prjid_from>
            <!--Optional:-->
            <quer:prjid_to></quer:prjid_to>
            <!--Optional:-->
            <quer:prjid_wildcard></quer:prjid_wildcard>
            <!--Optional:-->
            <quer:projectname></quer:projectname>
            <!--Optional:-->
            <quer:projectname_from></quer:projectname_from>
            <!--Optional:-->
            <quer:projectname_to></quer:projectname_to>
            <!--Optional:-->
            <quer:projectname_wildcard></quer:projectname_wildcard>
            <!--Optional:-->
            <quer:manager>managerId</quer:manager>
            <!--Optional:-->
            <quer:manager_from>[b]managerId</quer:manager_from>
<!--Optional:-->
<quer:manager_to>managerId</quer:manager_to>
<!--Optional:-->
<quer:manager_wildcard>managerId</quer:manager_wildcard>
</quer:Filter>
</quer:Query>
</soapenv:Body>
</soapenv:Envelope>

where managerId is real/valid username in Clarity.

Not sure what is best way to troubleshoot error? Any ideas?

Thank you in advance.

Outcomes