There is an existing issue with multiple conversions using flatten-tool. When using flatten-tool to converting JSON to XLSX and back to JSON, properties that have a value of an empty list are lost. So for instance when starting with:
{
"statementID": "1dc0e987-5c57-4a1c-b3ad-61353b66a9b7",
...
"publicListing": {
"hasPublicListing": true,
"companyFilingsURLs": ["http://example.com/"],
"securitiesListings": []
},
...
}
the "securitiesListings" property will be missing after the round trip. This is even true when supplying a schema.