Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Representing an XML schema in VBCS

edited Apr 15, 2019 10:35PM in Visual Builder

Summary

taking a CSV file from OICS and converting it to a json for XML schema complex types

Content

Hello All!

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. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!