Representing an XML schema in VBCS
Summarytaking a CSV file from OICS and converting it to a json for XML schema complex types
I need some help on this problem I have
I attempted to attach my XML schema into OICS but the entire schema was split across different namespaces. OICS doesn't have support for this. So I then flattened the XML schema and adjusted it so it was all in 1 namespace but found difficulties of mapping the flat CSV data to a complex XML schema, where there are complex type elements with other repeating elements within.
So instead I thought of representing the data as business objects in VBCS, send the CSV data to VBCS and get a response from VBCS to get the representation I need. Each (sub) schema file can be represented as a separate business object. And hopefully with relationships between objects I can form the complex type and repeating structure that's found in the original XML. This way when I query the database I'll get a response that looks like the JSON verson of the XML and map that response to an XML file in OICS.