Get Free Trial
Get Free Trial

Nested rows not showing up

JC Mata asked on July 8, 2019

I’m trying to show as nested rows some values that are contained within each parent row.
The JSON looks like below example… what I need is to show those values within the DealFees array as rows under the MortgageNumber.
I have attached the fields settings currently applied and the actual rendered result.
Am I getting it wrong? or is this something that can not be done?
 
Thanks!

[{
"Id": 2201,
"MortgageNumber": 9001686,
"Status": "FUNDED",
"DealType": "Purchase",
"ProgramType": "Second Home",
"PostalCode": "N6G0K2",
"LendingValue": 403000.0000,
"LoanAmount": 368479.4000,
"DateReceived": "2019-06-13T16:50:17",
"DealAudit": [],
"DealFees": [
{ "ReimbursementType": "Cash Back" },
{ "ReimbursementType": "Appraisal" },
{ "ReimbursementType": "Appraisal" }
]
},
{
"Id": 2202,
"MortgageNumber": 9001687,
"Status": "FUNDED",
"DealType": "Purchase",
"ProgramType": "Second Home",
"PostalCode": "N6G0K2",
"LendingValue": 723000.0000,
"LoanAmount": 368479.4000,
"DateReceived": "2019-06-13T16:50:17",
"DealAudit": [],
"DealFees": [
{ "ReimbursementType": "Cash Back" }
]
}
]

1 answer

Public
Vera Didenko Flexmonster July 9, 2019

Hello,
 
Thank you for your question.
 
 
Please keep in mind that the JSON format should be one of the following:
 
1) An array of objects, where each object is an unordered set of name/value pairs
2) An array of arrays, where each sub-array contains ordered values.
 
More information about supported JSON formats can be found in our connecting to JSON guide.
 
 
Our team kindly suggests restructuring the JSON data the following way:

[{
"Id": 2201,
"MortgageNumber": 9001686,
"Status": "FUNDED",
"DealType": "Purchase",
"ProgramType": "Second Home",
"PostalCode": "N6G0K2",
"LendingValue": 403000.0000,
"LoanAmount": 368479.4000,
"DateReceived": "2019-06-13T16:50:17",
"DealAudit": "",
"DealFees_ReimbursementType": "Cash Back"
},
{
"Id": 2201,
"MortgageNumber": 9001686,
"Status": "FUNDED",
"DealType": "Purchase",
"ProgramType": "Second Home",
"PostalCode": "N6G0K2",
"LendingValue": 403000.0000,
"LoanAmount": 368479.4000,
"DateReceived": "2019-06-13T16:50:17",
"DealAudit": "",
"DealFees_ReimbursementType": "Appraisal"
},
....
]

This format is supported and the output should be as desired.
Here is a JSFiddle example for illustration.
 
 
Please let us know if this would work for you.
 
You are welcome to contact us in case of any questions.
 
Best Regards,
Vera

Please login or Register to Submit Answer