web service output xml is not consistant.

[xren]

Hi

I am building this web service, getting data from a db table, then copy the data to another table for output.

However, when some column is null then it will not appear in the output xml. the column only appear in output xml when there is data.

I would like to have the item always in the output xml no matter if the corresponding column has data or not.

Thanks,
Xiaoli

[Steve]

Hi Xiaoli,

You need to set the property on the source field within the web service resource to write out an empty element.

1) Open the web service resource
2) Select the column (or field) in the 'Resource Fields' panel
3) In the 'Update Options' on the field properties panel, change the dropdown for 'Source field has no value' to 'write empty element'

This should now write an empty element if no data is present.

Kind regards

Steve

[xren]

Thank you Steve.