Configuring OneData to Skip Empty Columns
You can configure OneData to skip empty columns and reset the value of any other column as empty using REST. 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. On the Menu toolbar, click Administer > System > OneData Property Configuration.
2. In the OneData Property Configuration screen, do one of the following to locate the property you want to configure:
Click the relevant properties tab, and scroll to locate the property.
For example, Data Management.
In the search box, type the partial or full name of the property, and click
.
3. 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>
4. In the REST web service link, use the parameter skipEmptyColumns=true.
5. Using the HTTP Client, POST the created XML through the RESTful web service link.