I have been attempting to parse large JSON files (+200MB) that are provided on a daily basis using the schema provided.
I do know that in the Hierarchical stage the assembly editor can infer the schema by just importing the JSON data file,I have been able to parse a file based on this approach. The problem with this is that I have been given no guarantees that the +200MB file fulfills all fields defined in the schema.
My question is has anyone been able to import a JSON schema and use that to parse JSON data?
I have even tried using a simple Person example found at https://json-schema.org/learn/miscellan ... mples.html
Using the sample data the first parser step produces the following in the Downstream Output Test Data which you can see the firstName, lastName and age items are not being populated with the Name and Age values;
Code: Select all
{
"$id": "https://example.com/person.schema.json",
"$schema": "http://json-schema.org/draft-07/schema#",
"title": "Person",
"type": "object",
"properties": {
"firstName": {
"type": "string",
"description": "The person's first name."
},
"lastName": {
"type": "string",
"description": "The person's last name."
},
"age": {
"description": "Age in years which must be equal to or greater than zero.",
"type": "integer",
"minimum": 0
}
}
}<?xml version="1.0" encoding="UTF-8"?><top>
<InputLinks/>
<result>
<root>
<__24_id>
<@originalName>$id</@originalName>
</__24_id>
<__24_schema>
<@originalName>$schema</@originalName>
</__24_schema>
<@type>object</@type>
<properties>
<firstName>
<@type>object</@type>
<@@isPresent>false</@@isPresent>
</firstName>
<lastName>
<@type>object</@type>
<@@isPresent>false</@@isPresent>
</lastName>
<age>
<@type>object</@type>
<@@isPresent>false</@@isPresent>
</age>
<@type>object</@type>
<@@isPresent>false</@@isPresent>
</properties>
</root>
</result>
</top>
jneasy.