Json schema - enforce content of one array based on content of another array

Viewed 26

I would like to enforce the property names of 'reference data' array (e.g., id, name) to optionally be any of those specified in fieldMapping.referenceFieldName property values (e.g., id, name, billingCycleDescription). How can I define such schema?

{
    "$schema": "../../Reference data schema.json",
    "TableName": "BillingCycle",
    "fieldMapping": [
        {
            "FieldName": "BillingCycleId",
            "referenceFieldName": "id"
        },
        {
            "FieldName": "BillingCycleName",
            "referenceFieldName": "name"
        },
        {
            "FieldName": "BillingCycleDescription",
            "referenceFieldName": "billingCycleDescription"
        }
    ],
    "referenceData": [
        { "id": 104800000, "name": "Daily" },
        { "id": 104800001, "name": "Weekly" },
        { "id": 104800005, "name": "Bi-weekly" },
        { "id": 104800002, "name": "Monthly" },
        { "id": 104800003, "name": "Quarterly" },
        { "id": 104800004, "name": "Yearly" }
    ]
}
0 Answers
Related