Posted: 28 Jun 2017 11:06 EDT Last activity: 3 Jul 2017 15:45 EDT
How to obtain XSD while using BIX with "Get all properties" option in XML output format
In BIX, while extracting the data in XML format using "Get all properties" option, I am unable to see an option to generate XSD file. How can I obtain the XSD for a class while extracting all the properties in XML format using BIX...?
Unfortunately this is not technically possible. PRPC stores its objects in serialized form in pzPVStream BLOB column. Pega BIX extracts this representation and it doesn't have any predefined schema by design. That actually means that two objects can have entirely different fields (assuming they're not exposed) while being stored in the same database table.
If you still need some kind of XSD schema for BIX unload, I'd recommend generating XML file for a representative entity of this type first and generate XSD from XML. This can be done using Altova XMLSpy for example. I believe there are other tools capable of this task as well.
Overall I think it's a bad idea to reverse this logic and generate XSD in this manner. It will be actually need to be tailored manually as you won't be able to determine exact types and relations for field of your entity reprentated in XML.