Clarity

Expand all | Collapse all

How to read timesheet approval through XOG ?

  • 1.  How to read timesheet approval through XOG ?

    Posted Apr 22, 2017 06:39 PM

    Hi guys,

     

    I'm trying to approve timesheets through XOG, but I don't know where to get the ReadTimesheetApproval NikuDataBus template, please can somebody share it with me ?

     

    Thanks



  • 2.  Re: How to read timesheet approval through XOG ?

    Posted Apr 23, 2017 02:19 AM

    Hi, 

     

    You can use below sample xog request for reading timesheet data. I have used two filters, 

    1) Resource Id

    2) Timesheet status 

     

    Please find below Sample Xog rrequest to read timesheet datd from PPM.

     

    <?xml version="1.0" encoding="UTF-8"?>
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
    <Header version="6.0.11" action="read" objectType="timeperiod" externalSource="NIKU"/>
    <Query>
    <Filter name="resourceID" criteria="EQUALS">psingh</Filter>
    <Filter name="status" criteria="EQUALS">4</Filter>

    </Query>
    </NikuDataBus>

     

    Let me know if this works for you.

     

    Regards,

    Prashank Singh



  • 3.  Re: How to read timesheet approval through XOG ?

    Posted Apr 23, 2017 09:04 AM

    Hi Prashank,

    I can read/write timesheet, I'm looking for the XOG to approve timesheet and for that, I need to read and write approval, so I need both XOG:

    - XOG to read Approval

    - XOG to write Approval

     

     

    Please, waiting for your feedback

     

    Thanks,

    Amos



  • 4.  Re: How to read timesheet approval through XOG ?

    Posted Apr 23, 2017 10:52 AM

    Please search these boards, your question has been asked and discussed a few times before and various threads exist.

    e.g. XOG in approved timesheet 



  • 5.  Re: How to read timesheet approval through XOG ?

    Posted Apr 23, 2017 11:50 AM

    Hi David,

    I saw that I have to use below XOG to approve timesheets:

     

    <?xml version="1.0" encoding="UTF-8"?>
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timesheetApproval.xsd">
    <Header action="write" externalSource="NIKU" objectType="timesheetApproval" version="12.1.0.5840"/>
    <timesheetApprovals>
    <timesheetApproval isAdjusted="false" isAdjustment="false" resourceDbId="the internal database resource id" resourceId="the resource id" resourceName="Last Name, First Name"
    start="2012-09-03T00:00:00" status="3" timeperiodDbId="the internal database time period id" timesheetDbId="the internal database timesheet id" total="40" approved="true"/>
    </timesheetApprovals>
    </NikuDataBus>


    But, how can I get
    resourceDbId and timeperiodDbId ? could I retrieve them from
    database using ReadTimesheetApproval XOG ? I tryed it also but not working too :

    -----------------REQUEST
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
    <Header version="12.1.0.5840" externalSource="NIKU"/>
    <Query>
    <Filter name="resourceID" criteria="EQUALS">alida</Filter>
    <Filter name="start" criteria="EQUALS">2017-04-03T00:00:00</Filter>
    </Query>
    </NikuDataBus>

    -----------------------RESPONSE

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header/>
    <soapenv:Body>
    <ReadTimesheetApprovalResponse xmlns="http://www.niku.com/xog/Object">
    <NikuDataBus xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timesheetApproval.xsd">
    <Header externalSource="NIKU" version="14.3.0.298"/>
    <XOGOutput>
    <Object type="timesheetApproval"/>
    <Status state="FAILURE"/>
    <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
    <Records>
    <Record>
    <KeyInformation>
    <column name="externalSource">NIKU</column>
    </KeyInformation>
    <ErrorInformation>
    <Severity>FATAL</Severity>
    <Description>Invalid filter name, criteria or value: resourceID, EQUALS, alida
    com.niku.xog.XOGException: Invalid filter name, criteria or value: resourceID, EQUALS, alida
    at com.niku.xog.object.ReadTimesheetApprovals.setTimeperiodDates(ReadTimesheetApprovals.java:113)
    at com.niku.xog.object.ReadTimesheetApprovals.getInputDocument(ReadTimesheetApprovals.java:127)
    at com.niku.xog.object.ReadTimesheetApprovals.doProcessRequest(ReadTimesheetApprovals.java:37)
    at com.niku.xog.service.BaseXOGService.processRequest(BaseXOGService.java:228)
    at com.niku.union.service.binding.ServiceControlBindingJava.processRequest(ServiceControlBindingJava.java:58)
    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:902)
    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)
    at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:219)
    at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1419)
    at com.niku.union.web.PortletController.processProcessActionRequest(PortletController.java:233)
    at com.niku.union.web.PortletController.processRequest(PortletController.java:160)
    at com.niku.union.web.WebActionController.processAction(WebActionController.java:1433)
    at com.niku.union.web.WebActionController.processRequest(WebActionController.java:176)
    at com.niku.xog.service.XOGWMDHandler.process(XOGWMDHandler.java:89)
    at com.niku.xog.service.AbstractObjectHandler.processRequest(AbstractObjectHandler.java:280)
    at com.niku.xog.service.AbstractObjectHandler.process(AbstractObjectHandler.java:215)
    at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)
    at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:595)
    at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:355)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:148)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.niku.union.web.filter.XSSFilter.doFilter(XSSFilter.java:80)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.niku.union.web.filter.TenantSetupFilter.doFilter(TenantSetupFilter.java:50)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:45)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
    at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:65)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1086)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:659)
    at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:223)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1558)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1515)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)</Description>
    </ErrorInformation>
    </Record>
    </Records>
    </XOGOutput>
    </NikuDataBus>
    </ReadTimesheetApprovalResponse>
    </soapenv:Body>
    </soapenv:Envelope>

     

    Please, I need more details about the ReadTimesheetApproval to get first all the fields and then run the WriteTimesheetApproval as advised.

     

     

    Thanks,

    Amos



  • 6.  Re: How to read timesheet approval through XOG ?

    Posted Apr 23, 2017 01:26 PM

    Hi Amos,

     

    Please use below READ XOG as below

    ------------------------------------------------------------------------------------------------------------------------------------------------------

    <?xml version="1.0" encoding="UTF-8"?>
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
    <Header version="6.0.11" action="read" objectType="timeperiod" externalSource="NIKU"/>
    <Query>

    <Filter name="start" criteria="EQUALS">2015-11-02</Filter>
    <Filter name="resourceID" criteria="EQUALS">psingh</Filter>

    </Query>
    </NikuDataBus>

    -----------------------------------------------------------------------------------------------------------------------------------------------------

    Response

     

    <?xml version="1.0" encoding="UTF-8"?>
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timeperiod.xsd">
    <Header action="write" externalSource="NIKU" objectType="timeperiod" version="14.2.0.237"/>
    <TimePeriods>
    <TimePeriod finish="2015-11-09T00:00:00" openForTimeEntry="true" start="2015-11-02T00:00:00">
    <TimeSheets>
    <TimeSheet ID="5016003" lastModified="2016-11-14T21:12:37" resourceID="psingh" status="2" version="10">
    <TimeSheetEntries>
    <TimeSheetEntry assignmentEstimate="0" assignmentEstimateForTimePeriod="0" assignmentID="5023002" assignmentPendingEstimate="0"
    internalTaskID="5033002" projectID="PRJ004924" projectName="Test Data for Cost Plan" roleID="csk.architect" taskID="PRJ00492-000110"
    taskName="Capital Business Task" totalActuals="16">
    <DailyActuals>
    <Actual actualDate="2015-11-02" amount="8"/>
    <Actual actualDate="2015-11-03" amount="8"/>
    <Actual actualDate="2015-11-04" amount="0"/>
    <Actual actualDate="2015-11-05" amount="0"/>
    <Actual actualDate="2015-11-06" amount="0"/>
    <Actual actualDate="2015-11-07" amount="0"/>
    <Actual actualDate="2015-11-08" amount="0"/>
    </DailyActuals>
    </TimeSheetEntry>
    </TimeSheetEntries>
    <Notes>
    <NoteData category="check2" createdBy="admin" createdTime="2016-11-14T20:45:52" noteText="test2"/>
    <NoteData category="NoteCatageory" createdBy="admin" createdTime="2016-11-14T21:12:08" noteText="test2 data change"/>
    <NoteData category="check2" createdBy="admin" createdTime="2016-11-14T21:17:42" noteText="test2"/>
    <NoteData category="NoteCatageory" createdBy="admin" createdTime="2016-11-14T21:17:42" noteText="test2 data change"/>
    <NoteData category="check2" createdBy="admin" createdTime="2016-11-14T21:24:46" noteText="test2"/>
    <NoteData category="NoteCatageory" createdBy="admin" createdTime="2016-11-14T21:24:46" noteText="test2 data change"/>
    <NoteData category="check23" createdBy="admin" createdTime="2016-11-14T21:25:09" noteText="test2"/>
    <NoteData category="NoteCatageory3" createdBy="admin" createdTime="2016-11-14T21:25:09" noteText="test2 data change"/>
    </Notes>
    </TimeSheet>
    </TimeSheets>
    </TimePeriod>
    </TimePeriods>
    <XOGOutput>
    <Object type="timeperiod"/>
    <Status state="SUCCESS"/>
    <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
    <Records/>
    </XOGOutput>
    </NikuDataBus>

     

    -------------------------------------------------------------------------------------------------------------------------------------------------------------

     

    You can use these futher as per your requirement, let me know if this helps.

     

    Regards,

    Prashank Singh



  • 7.  Re: How to read timesheet approval through XOG ?

    Posted Apr 23, 2017 01:37 PM

    Hi Prashank,

     

    It seems that this XOG you shared is for timeperiods read ? I'm looking for time approval read and write. I tryed the XOG below but getting the same error:

     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:obj="http://www.niku.com/xog/Object">
    <soapenv:Header>
    <obj:Auth>
    <SessionID>10752395__47E701E1-AC97-4147-9AD6-2B479AD12087</SessionID>
    </obj:Auth>
    </soapenv:Header>
    <soapenv:Body>
    <obj:ReadTimesheetApproval>

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
    <Header version="12" action="read" objectType="timeperiod" externalSource="NIKU"/>
    <Query>
    <Filter name="start" criteria="EQUALS">2017-04-03</Filter>
    <Filter name="resourceID" criteria="EQUALS">alida</Filter>
    </Query>
    </NikuDataBus>
    </obj:ReadTimesheetApproval>
    </soapenv:Body>
    </soapenv:Envelope>

     

     

    Thanks,

    Amos



  • 8.  Re: How to read timesheet approval through XOG ?

    Posted Apr 23, 2017 03:11 PM

    Hi Amos,

     

    I have tried to create a ReadApproveTimesheet sample request, however im not able to apply any filter , it seems resourceID is not a proper filter for ReadApproveTimesheet and lack of any sample ReadApproveTimesheet request made this more difficult.

     

    However i have given WriteApproveTimehseet a test and it seems to be working fine for me with below sample request.

    -------------------------------------------------------------------------------------------------------------------------------------

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timesheetApproval.xsd">
    <Header action="write" externalSource="NIKU" objectType="timesheetApproval" version="12.1.0.5840"/>
    <timesheetApprovals>
    <timesheetApproval isAdjusted="false" isAdjustment="false" resourceDbId="5013001" resourceId="psingh" resourceName="Singh, Prashank"
    status="3" timeperiodDbId="5002001" timesheetDbId="5016003" approved="true"/>
    </timesheetApprovals>
    </NikuDataBus>

    ------------------------------------------------------------------------------------------------------------------------------------------

     

    You can create a connection to clarity db for all essential infromation for creating your write request. 

     

    Regards,

    Prashank Singh



  • 9.  Re: How to read timesheet approval through XOG ?

    Posted Apr 24, 2017 01:49 AM

    Hi Prashank,

     

    Thank you, I'm now able to approve timesheets, but the ReadTimesheetApproval is still failing, I need the read to work in order to get resourceDbId,  timeperiodDbId and timesheetDbId for the write:

    --------------------REQUEST

     

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:obj="http://www.niku.com/xog/Object">
    <soapenv:Header>
    <obj:Auth>
    <SessionID>10752395__47E701E1-AC97-4147-9AD6-2B479AD12087</SessionID>
    </obj:Auth>
    </soapenv:Header>
    <soapenv:Body>
    <obj:ReadTimesheetApproval>

    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
    <Header version="12" action="read" objectType="timeperiod" externalSource="NIKU"/>
    <Query>
    <Filter name="start" criteria="EQUALS">2017-04-03T00:00:00</Filter>
    <Filter name="resourceID" criteria="EQUALS">alida</Filter>
    </Query>
    </NikuDataBus>

    </obj:ReadTimesheetApproval>
    </soapenv:Body>
    </soapenv:Envelope>

     

    ----------------------------------RESPONSE

    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header/>
    <soapenv:Body>
    <SessionID xmlns="http://www.niku.com/xog">10752415__6BAFBB7D-F842-42E5-B3D1-27CAC34D22D5</SessionID>
    <ReadTimesheetApprovalResponse xmlns="http://www.niku.com/xog/Object">
    <NikuDataBus xsi:noNamespaceSchemaLocation="../xsd/nikuxog_timesheetApproval.xsd">
    <Header externalSource="NIKU" version="14.3.0.298"/>
    <XOGOutput>
    <Object type="timesheetApproval"/>
    <Status state="FAILURE"/>
    <Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
    <Records>
    <Record>
    <KeyInformation>
    <column name="externalSource">NIKU</column>
    </KeyInformation>
    <ErrorInformation>
    <Severity>FATAL</Severity>
    <Description>Invalid filter name, criteria or value: start, EQUALS, 2017-04-03T00:00:00
    com.niku.xog.XOGException: Invalid filter name, criteria or value: start, EQUALS, 2017-04-03T00:00:00
    at com.niku.xog.object.ReadTimesheetApprovals.setTimeperiodDates(ReadTimesheetApprovals.java:108)
    at com.niku.xog.object.ReadTimesheetApprovals.getInputDocument(ReadTimesheetApprovals.java:127)
    at com.niku.xog.object.ReadTimesheetApprovals.doProcessRequest(ReadTimesheetApprovals.java:37)
    at com.niku.xog.service.BaseXOGService.processRequest(BaseXOGService.java:228)
    at com.niku.union.service.binding.ServiceControlBindingJava.processRequest(ServiceControlBindingJava.java:58)
    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:902)
    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)
    at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:219)
    at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1419)
    at com.niku.union.web.PortletController.processProcessActionRequest(PortletController.java:233)
    at com.niku.union.web.PortletController.processRequest(PortletController.java:160)
    at com.niku.union.web.WebActionController.processAction(WebActionController.java:1433)
    at com.niku.union.web.WebActionController.processRequest(WebActionController.java:176)
    at com.niku.xog.service.XOGWMDHandler.process(XOGWMDHandler.java:89)
    at com.niku.xog.service.AbstractObjectHandler.processRequest(AbstractObjectHandler.java:280)
    at com.niku.xog.service.AbstractObjectHandler.process(AbstractObjectHandler.java:215)
    at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)
    at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:595)
    at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:355)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:148)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.niku.union.web.filter.XSSFilter.doFilter(XSSFilter.java:80)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.niku.union.web.filter.TenantSetupFilter.doFilter(TenantSetupFilter.java:50)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:45)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
    at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:65)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:516)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1086)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:659)
    at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:223)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1558)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1515)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)</Description>
    </ErrorInformation>
    </Record>
    </Records>
    <DeprecationInformation>
    <Severity>WARNING</Severity>
    <Description>DEPRECATION MESSAGE</Description>
    <Exception type="java.lang.Exception">The action and objectType attributes in the Header have been deprecated, and the listed value of 'timeperiod' conflicts with the requested objectType 'timesheetApproval'.</Exception>
    </DeprecationInformation>
    </XOGOutput>
    </NikuDataBus>
    </ReadTimesheetApprovalResponse>
    </soapenv:Body>
    </soapenv:Envelope>

     

     

    Thanks,

     

    Amos



  • 10.  Re: How to read timesheet approval through XOG ?

    Posted Apr 24, 2017 03:09 AM

    Read is not working for me either, still you can get data via sql from clarity DB for your write xml.



  • 11.  Re: How to read timesheet approval through XOG ?

    Posted Apr 24, 2017 05:46 PM

    Hi Prashank,

    Thank you a lot for your help, but I don't want to implement a query in clarity, I just want to use native solution.

    Can somebody help us ?

     

    Thanks,

    Amos



  • 12.  Re: How to read timesheet approval through XOG ?

    Posted Apr 25, 2017 03:26 AM

    Esdras wrote:

     

    I don't want to implement a query in clarity, I just want to use native solution.

     

    The Query API is a "native solution", it just exposes NSQL queries over the SOAP webservices. Nothing too complex about it.