Clarity

<!-- Get the external project code and internal ID from the object instance id - for use as a parameter in jobs-->

<sql:query dataSource="${clarityDS}" escapeText="false" var="project">


<![CDATA[


SELECT 


code, id 


from inv_investments i


where i.id = ${gel_objectInstanceId}


]]> 

</sql:query>


<core:forEach items="${project.rowsByIndex}" trim="true" var="project_data">


<core:set value="${project_data[0]}" var="project_code" />


<core:set value="${project_data[1]}" var="project_id" />

</core:forEach>



<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>${XOGUsername}</xog:Username>






                        <xog:Password>${XOGPassword}</xog:Password>









</xog:Login>








</soapenv:Body>






</soapenv:Envelope>




</soap:message>

</soap:invoke>



<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>Couldn't Log in.  Check the username/password.</gel:log>





</core:when>


<core:otherwise></core:otherwise>

</core:choose>




<gel:log>Logging in and running jobs for project ${project_code}...</gel:log>




<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>







<!-- First run Purge Financial Tables job-->







<gel:log>${project_code} Purge financial table job...</gel:log>







<Process xmlns="http://www.niku.com/xog/InvokeAction">








<code>owen_purge_financials</code>








<request>









<thisProject>










param_project_code="${project_id}"









</thisProject>








</request>







</Process>








<!-- Then run Delete Documents job-->







<gel:log>${project_code} Purge documents job...</gel:log>








<Process xmlns="http://www.niku.com/xog/InvokeAction">









<code>archive_purge_docs</code>









<request>










<documents>











retainVersions="-1"











notAccessedDays="-1"











purgeAll="true"











allProjects="false"











projectOBSunitId="-1"











allResources="false"











resourceOBSunitId="-1"











specificResourceId="-1"











allCompanies="false"











companyOBSunitId="-1"











specificCompanyId="-1"











retainVersions="-1











purgeKnowledgeStore="false"











specificProjectId="${project_id}"










</documents>









</request>







</Process>






</soapenv:Body>





</soapenv:Envelope>



</soap:message>


</soap:invoke>

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
    <soapenv:Header/>
    <soapenv:Body>
        <ProcessResult xmlns="http://www.niku.com/xog/InvokeAction"/>
    </soapenv:Body>
</soapenv:Envelope>

Owen_R wrote:

Well that thread might, if there were any answers in it :grin:.

Create a process with no primary object, and a step to run your chosen job / parameters.

Create another process, and within the GEL make an invokeAction/Process web service call (see: http://yourserver/niku/wsdl/InvokeAction) to the XOG end point. It's indirect to have a 2nd process to give you the item you can call on demand, but as a route and solution, it is supported.

Owen_R:

An update...from Support I got the suggestion to use the getDocument tag in my GEL to retrieve the process XML and set the variables. This and setDocument are not tags I've used before. Looking at the Integration Guide doesn't really help much either as there's no example code. Has anybody got any examples of these tags in action or suggestions where I should use them in my script above?

Hello Owen, 

I know this is an old thread but I am trying to do the same thing in our environment, trying to run auto-schedule project job from within a processes with dynamic project id as param..any idea how to achieve it? Possibly with a code?

Thanks

Hi,

Owen_R and @TonyRosa, I'm trying to do something similar (programmatically trigger a process on a specific object instance), and I too can't quite follow the setDocument and getDocument and InvokeAction items. Please share any guidance!

My code snippet below is as far as I've gotten. It does trigger the process, but it doesn't appear to attach the process instance to an object instance (task in my case, even though the process "z_sam_tt2" definition is to a task instance?)

    <gel:parse var="v_xml_root_2">

        <Process xmlns="http://www.niku.com/xog/InvokeAction">

            <code>z_sam_tt2</code>

                <request>

                    <thisTask>5108018</thisTask>

                </request>

        </Process>

    </gel:parse>

    <!--  Execute XOG -->

    <core:catch var="xog_error">

        <soap:invoke endpoint="${v_clarityURL}" 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>${v_xogSessionId}</xog:SessionID>

                        </xog:Auth>

                    </soapenv:Header>

                    <soapenv:Body>

                        <gel:include select="$v_xml_root_2"/>

                    </soapenv:Body>

                </soapenv:Envelope>

            </soap:message>

        </soap:invoke>

    </core:catch>

Hi Samos, I know it's a pretty old thread, but I do have the same issue.  Did you figured it out?

If I excecute this:

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

<?xml version="1.0" encoding="UTF-8"?>
<Process xmlns="http://www.niku.com/xog/InvokeAction">>
<code>cs_cp_actuals</code>
<request>
<thisCostPlan>XOG-002350-20171118CO</thisCostPlan>
</request>
</Process>

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

and looked into process, my XOG-002350-20171118CO is not linked to the process

See if this link helps: Gel access to WSDL Process InvokeAction content 

V/r,

Gene

Thanks Gene, I did try changing to:

<?xml version="1.0" encoding="UTF-8"?>
<Process xmlns="http://www.niku.com/xog/InvokeAction">>
<code>cs_cp_actuals</code>
<request>
<objparam objType="costplan">XOG-002350-20171118CO</objparam>
</request>
</Process>

but I still don't see in the Initiated Process  window the Object Name