Managing Master Data with webMethods OneData 10.5 | Managing Master Data with webMethods OneData | Developing for webMethods OneData | REST Web Services | Working with REST XSDs | Configuring OneData to Skip Empty Columns
 
Configuring OneData to Skip Empty Columns
You can configure OneData to skip empty columns and reset the value of any other column as empty by using REST in the onedata.properties file. The onedata.datainterchange.nullify.keyword property defines whether to nullify an empty field while constructing the XML. Use this property along with the parameter skipEmptyColumns in the REST URL.
* To skip empty columns and reset other columns
1. Go to <Installation_Directory>\SoftwareAG\profiles\ODE\bin\onedata\config directory and open the onedata.properties file.
2. Set the property, onedata.datainterchange.nullify.keyword=NULLIFY_FIELD to automatically skip empty columns and reset fields. Save and close the file.
For example, if onedata.datainterchange.nullify.keyword=NULLIFY_FIELD, and you want to reset a column value while constructing XML, use NULLIFY_FIELD as follows.
<ADDRESS>
<datarow>
 <ID>12</ID>
<COL1>Book</COL1>
<COL2>NULLIFY_FIELD</COL2>
<COL3></COL3>
</datarow>
</ADDRESS>
3. In the REST web service link, use the parameter skipEmptyColumns=true.
4. Using the HTTP Client, POST the created XML through the RESTful web service link.
Copyright © 2011-2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.