Same problem.
I have the following code:
<!-- Log into XOG and get a session ID -->
<soap:invoke endpoint="${XOGURL}/niku/xog" var="auth">
<soap:message>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xog="http://www.niku.com/xog">
<soapenv:Header />
<soapenv:Body>
<xog:Login>
<xog:Username>${clarityUser}</xog:Username>
<xog:Password>${claritypwd}</xog:Password>
</xog:Login>
</soapenv:Body>
</soapenv:Envelope>
</soap:message>
</soap:invoke>
<!--
Checking wheter a sessionID is returned. If not, it means that Login
was unsuccessful
-->
<gel:set asString="true"
select="$auth/SOAP-ENV:Envelope/SOAP-ENV:Body/xog:SessionID/text()"
var="sessionID" />
<core:choose>
<core:when test="${sessionID == null}">
<gel:log level="ERROR">Couldn't Log in. Check the username/password
</gel:log>
</core:when>
<core:otherwise>
<gel:log>Log in Ok</gel:log>
<gel:log>SessionID: ${sessionID}</gel:log>
</core:otherwise>
</core:choose>
the login appears correctly
The script follows:
<!-- ottengo l'id del timesheet -->
<gel:log>Timesheet id: ${gel_objectInstanceId}</gel:log>
<!-- recuepero i timesheet approved-->
<gel:parse var="leggi">
<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="status" criteria="EQUALS">4</Filter>
</Query>
</NikuDataBus>
</gel:parse>
<gel:set asString="true" select="$leggi" var="cosa_chiedo"/>
<gel:log>Request:: ${cosa_chiedo}</gel:log>
<!-- Inoltro richiesta -->
<soap:invoke endpoint="${XOGURL}/niku/xog" var="runresult">
<soap:message>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xog="http://www.niku.com/xog">
<soapenv:Header>
<xog:Auth>
<xog:SessionID>${sessionID}</xog:SessionID>
</xog:Auth>
</soapenv:Header>
<soapenv:Body>
<gel:include select="$leggi"/>
</soapenv:Body>
</soapenv:Envelope>
</soap:message>
</soap:invoke>
<gel:set asString="true" select="$runresult" var="write_status"/>
<gel:log>TimePeriods Approved: ${write_status}</gel:log>
<!-- per ogni time time entry scrivo codice progetto e ETC -->
<gel:forEach select="$runresult/soapenv:Envelope/soapenv:Body/NikuDataBus/TimePeriods//TimePeriod//TimeSheets//TimeSheet//TimeSheetEntries//TimeSheetEntry" var="tm_row">
<gel:log>TtimesheetEntry Approved: ${tm_row}</gel:log>
...
The log "TimePeriods Approved: ${wr...}" does not appear in the result.
By the way I have a log where I am supposed to write a sentence for each timesheet entry.
The resutl is 18 pages in the log with:
"TimesheetEntry Approved: : [TimeSheetEntry: null]"
copy and paste whathever else xog in the parse tag I see the result,
running:
<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="status" criteria="EQUALS">4</Filter>
</Query>
</NikuDataBus>
I have correct result both via URL and Desktop XOG Client.
CANNOT FIND A WAY TO GET THE TIME PERIOD VIA GEL SCRIPT USING XOG.
HELP!!!!!