HI ,
new here - hope im posting in the right place.
I need to change Json shceme to support multiple object (under object),
in example:
{
"parameter": {
"AppliedCampaignID": {
"name": "AppliedCampaignID",
"valueTo": "a",
"unitOfMeasure": null,
"value": "111",
"valueFrom": "c"
},
"B": {
"name": "B",
"valueTo": "B|",
"unitOfMeasure": null,
"value": "111",
"valueFrom": "A"
}
}
}
Under parameter - could be single or more objects (with exactly same attributes name,valueTo, unitOfMeasure and so on)
with different name ,
what changes i could do in the Json schematic to support it?
Json scheme:
<?xml version="1.0" encoding="UTF-8"?><xs:schema xmlns:json="http://www.informatica.com/JSON/V1/single_obj_DP" xmlns:xs="http://www.w3.org/2001/XMLSchema" attributeFormDefault="unqualified" elementFormDefault="qualified" targetNamespace="http://www.informatica.com/JSON/V1/single_obj_DP">
<xs:annotation json:name="json_original_schema">
<xs:documentation>{
"type" : "object",
"required" : false,
"properties" : {
"parameter" : {
"type" : "object",
"required" : false,
"properties" : {
"AppliedCampaignID" : {
"type" : "object",
"required" : false,
"properties" : {
"name" : {
"type" : "string",
"required" : false,
"DT_INTERNAL_JSON_PRECISION_VALUE" : 21
},
"valueTo" : {
"type" : "null",
"required" : false
},
"unitOfMeasure" : {
"type" : "null",
"required" : false
},
"value" : {
"type" : "string",
"required" : false,
"DT_INTERNAL_JSON_PRECISION_VALUE" : 4
},
"valueFrom" : {
"type" : "null",
"required" : false
}
}
}
}
}
}
}</xs:documentation>
</xs:annotation>
<xs:element name="single_obj_DP">
<xs:complexType>
<xs:all>
<xs:element minOccurs="0" name="parameter">
<xs:complexType>
<xs:sequence maxOccurs="unbounded" minOccurs="0">
<xs:element maxOccurs="1" minOccurs="0" name="B">
<xs:complexType>
<xs:all>
<xs:element minOccurs="0" name="name" type="xs:string">
<xs:annotation json:precision_value="21"/>
</xs:element>
<xs:element minOccurs="0" name="valueTo" type="json:JSON_NULL"/>
<xs:element minOccurs="0" name="unitOfMeasure" type="json:JSON_NULL"/>
<xs:element minOccurs="0" name="value" type="xs:string">
<xs:annotation json:precision_value="4"/>
</xs:element>
<xs:element minOccurs="0" name="valueFrom" type="json:JSON_NULL"/>
</xs:all>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:all>
</xs:complexType>
</xs:element>
<xs:simpleType name="JSON_DATA">
<xs:restriction base="xs:string"/>
</xs:simpleType>
<xs:simpleType name="JSON_NULL">
<xs:restriction base="xs:string">
<xs:maxLength value="0"/>
</xs:restriction>
</xs:simpleType>
</xs:schema>
```