How do we establish a relationship between two objects? Sample data
{
"report_fields": {
"cutomer": [
{
"id": 1,
"current_account_id": 20,
"code": "CSTM1",
"description": "Customer 1"
},
{
"id": 2,
"current_account_id": 20,
"code": "CSTM2",
"description": "Customer 2"
},
{
"id": 2,
"current_account_id": 22,
"code": "CSTM2",
"description": "Customer 2"
}
],
"current_account": [
{
"id": 20,
"code": "CRNT1",
"description": "Current Account 1"
},
{
"id": 22,
"code": "CRNT2",
"description": "Current Account 2"
}
]
}
}
Hello, Namig,
Thank you for writing to us.
We would like to inform you that our component supports two JSON formats – an array of objects, where each object is an unordered set of name/value pairs, and an array of arrays, where each sub-array contains ordered values. We kindly recommend modifying your data to suit one of the formats. For more details, check this article: https://www.flexmonster.com/doc/json-data-source/.
Please let us know if the case of questions.
Regards,
Tanya