python – JSON to XML – Complicated file. Sub Objects
I have a JSON file with the following data.
{
"ref_object": "additionalData/areas",
"row_count": 3,
"rows": [
{
"area_id": "-LAJ8kR1KLHLJlYwtbSl",
"issued_status": false,
"issued_user": "A1",
"matcheck_user": "A1"
},
{
"area_id": "-LAJ9BxJbLtJ9uj8gj3M",
"issued_status": false,
"issued_user": "A2",
"matcheck_user": "A2"
},
{
"area_id": "-LHgFnRjjMJrKp57owKM",
"issued_status": false,
"issued_user": "A3",
"matcheck_user": "A3"
}
],
"sub_row_count": 3,
"sub_object_rows": [
{
"area_id": "-LAJ8kR1KLHLJlYwtbSl",
"type": "buildPlannedDays",
"date": "2019-03-01",
"count": 6
},
{
"area_id": "-LAJ9BxJbLtJ9uj8gj3M",
"type": "buildPlannedDays",
"date": "2019-03-02",
"count": 6
},
{
"area_id": "-LHgFnRjjMJrKp57owKM",
"type": "buildPlannedDays",
"date": "2019-08-03",
"count": 11
}
]
}
How do I export this as either CSV or XML?
I tried using examples but none seemed to cope with Sub_object.
Read more here: Source link
