I need help from you about Clarity Program save via XOG API. Clarity Project Id is auto numbering system. When you want to add an Clarity Program from Clarity Interface this Project Id will be automatically populated. Now if we want to save via XOG API, how can I get this Id. We tried with addin <args name="overrideAutoNumbering" value="false"/> in Header section in XOG . But this is working for Clarity Custom Object. I tried to post with this section for Program Save. We are not able to save this. Can you help us how can I get next auto number to save an Program via XOG API.
I got an option via MS SQL from the following. But how can I use this via XOG.
Message was edited by: Tapas Mondal
You may need to provide more details and log a support case for this question. There has been some issues with XOG and auto-numbering. So to ensure that you get the right response, please log a support case.
Thank you for your response
we are using the folloing xml via xog
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
<Header version="13.2" action="write" objectType="project" externalSource="NIKU">
<args name="overrideAutoNumbering" value="false"/>
<Projects><Project name="Test Data" status="0" program="true">
<?xml version="1.0" encoding="UTF-8"?>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Status elapsedTime="0.001 seconds" state="FAILURE"/>
<Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="0" updatedRecords="0"/>
<Description>[Error] :0:0: element "Project" is missing "projectID" attribute
<Exception type="java.lang.Exception">Invalid xml data</Exception>
Please help me how to overcome this problem
Sorry for the delay.
You need to specify the 'projectID' attribute with no value in the input file.
Let me know if that helps.
There is also
and you can vote
Autonumbering and XOG - Default to 'autonumber=true' on all objects where autonumbering has been enabled
In his webinar
XOG (XML Open Gateway) Best Practices Webinar UK Edition - Replay the Webinar with Q & A Transcript.
around 37 min Federico talk about autonumbering.
He is about the most posting contributor on XOG issues and knows the tips and tricks and catchas.
Some of those are shared in his user friendly power tool XQ/XOG Query Bridge.