[progress Communities] [progress Openedge Abl] Forum Post: Read-xml / Write-json

[xjg]

Hello, I'm working in a XML -> JSON transformation by automatically reading the XML file using the READ-XML method from the ProDataSet class. The behavior that I'm trying to deal with is that all the fields appear to be converted to character, thus, all the fields written afterwards in the JSON file have their value quoted since they are all treated as characters although they are supposed to be decimal. When I load the XML file to the ProDataSate I can Write the Schema generated when reading and I can see there that indeed all the xsd elements of the fields have the property "type="xsd:string". I've tried to use the option field-type-mapping from the READ-XML method but I can't make my WRITE-JSON method to show any field as decimal nor this option seems to modify the schema written. Does anybody know how could I do to get the fields with their correct type? Thanks in advance for your answers!

Continue reading...