JSON Source for Tabular Data

Ingested JSON files must represent an array of JSON objects (each object representing one item).

[
    {
        ### content of first item
    },
    {
        ### content of second item
    },
    ...
    {
        ### content of last item
    }
]

Each JSON object must provide:

• The properties of the item. Missing properties are assumed as null.
• An extra class property, indicating the fully qualified name (package name + "." + class name) of the item's class in the target Index Unit.

  Important: If the class name contains non-alphanumeric characters, surround it by back quotes (especially dots . that would otherwise conflict with the package delimiter). For example, {class:"com.example.`PLMEntity.AbstractMyClass`",uri:"item_123",foo:"chips"}

• Optionally, a uri property. If it is not the case, Data Factory Studio generates the item URI automatically.

Example:

If the data model contains a People class in a com.example package, with the following properties:

• name type: String
• age type: Integer
• birthdate type: Date
• relatives type: List of Reference
• pets type: Map of Strings

The following json file content is valid:

[
    {
        "uri": "people_1",
        "class": "com.example.People", 
        "name": "Bob",
        "age": 20,
        "birthdate": "2000-12-25",
        "relatives": ["people_4", "people_15"],
        "pets": {
            "Atlas": "dog",
            "Bonnie": "cat"
        }
  },
    {
        "uri": "people_4",
        "class": "com.example.People",
        "birthdate": "1980-10-30",
        "relatives": [],
        "pets": {},
        "age": 40,
        "name": "Alice"
    },
    {
        "name": "Camille",
        "birthdate": null,
        "pets": {},
        "uri": "people_15",
        "class": "com.example.People"
    }
]