OneData 10.7 | Managing Master Data with webMethods OneData | Developing for webMethods OneData | RESTful Web Services | REST URL Parameters | skipEmptyColumns
 
skipEmptyColumns
Indicates whether to skip empty and missing XML tags. To use with conceptual objects, ensure that every level in the conceptual object has at least one record.
*skipEmptyColumns=true. Default.
*skipEmptyColumns=false. Includes all empty and missing tags in the input XML for insert and update actions.
To skip empty columns (shipEmptyColumns=true) in a conceptual object that has Country > State > City, all constituent objects must have at least one record, as in the following examples.
<Country>
<Country_Name>Country_Name_1</Country_Name>
<State>
<St_Name>State_Name_1</St_Name>
<City>
<City_Name>City_Name_a</City_Name>
</City>
</State>
</Country>
<Country>
<Country_Name>Country_Name_1</Country_Name>
<State>
<St_Name>State_Name_2</St_Name
<City>
<City_Name>City_Name_b</City_Name>
</City>
</State>
</Country>
For a conceptual object that does not have a record in every level, set the value of skipEmptyColumns as false.
<Country>
<Country_Name>Country_Name_1</Country_Name>
<State>
<St_Name>State_Name_1</St_Name>
<City>
<City_Name>City_Name_a</City_Name>
</City>
</State>
</Country>
<Country>
<Country_Name>Country_Name_1</Country_Name>
<State>
<St_Name>State_Name_2</St_Name
<City>
<!-- City record not present for the country -->
</City>
</State>
</Country>