on 09-15-2015 6:28 PM
I want to send an XML representation of the data in a datastore to a web service. I get the XML with dw1.Object.DataWindow.Data.XML.
However it doesn't differentiate between empty string data and data that is null, something that is quite important since I am saving it to a database. It marks any columns with empty string and null the same, with a nill="true".
Does anyone know of any way for it not to do this? I'd like empty string to be represented as an empty XML element and nulls with a nill="true".
Thank you.
Hi Aron;
1) Set the "empty string is null" property in the DWO's column(s) edit mask as appropriate.
2) In the "Data Export" tab of the DWO, set the "Meta Data Type" to XMLSchema!
3) Set the "save Meta Data" default to MetaDataInternal! (default).
That should (hopefully) have the DWO's include the nillable="true" and nil="true" you are looking for in its XML data stream.
HTH
regards ... Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<my bad> ... sorry for getting that in backwards!
So ... just reverse my advise:
1) Uncheck the "empty string is null" property in the DWO's column(s) edit mask as appropriate.
2) In the "Data Export" tab of the DWO, set the "Format to configure" to XML
3) In the "Data Export" tab of the DWO, set the "Meta Data Type" to XMLNone!
That should make the DWO's suppress the nillable="true" and nil="true" and return null columns to "empty".
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.