Hi @kudracha , thanks for helping me! This is the output and it appears to always be this order:
[
{
“header”: [
{
“value”: “Bank Accounts”
},
{
“value”: “Opening Balance”
},
{
“value”: “Cash Received”
},
{
“value”: “Cash Spent”
},
{
“value”: “Closing Balance”
}
],
“section”: [
{
“value”: “MHB Current Account”,
“id”: “XXXX”
},
{
“value”: “XXXX”
},
{
“value”: “XXXX”,
“id”: “XXXX”
},
{
“value”: “XXXXX”,
“id”: “XXXX”
},
{
“value”: “XXXX”
}
],
“sections”: [
[
{
“value”: "MHB Business Premium “,
“id”: “XXXX”
},
{
“value”: “XXXX”
},
{
“value”: “XXXX”,
“id”: “XXXX”
},
{
“value”: “XXXX”,
“id”: “XXXXX”
},
{
“value”: “XXXX”
}
],
[
{
“value”: “MHB Client Premium”,
“id”: “XXXXXX”
},
{
“value”: “XXXXX”
},
{
“value”: “XXXX”,
“id”: “XXXX”
},
{
“value”: “XXXX”,
“id”: “XXXXX”
},
{
“value”: “XXXX”
}
],
[
{
“value”: “MHB Current Account”,
“id”: “XXXXX”
},
{
“value”: “XXXX”
},
{
“value”: “XXXXX”,
“id”: “XXXXX”
},
{
“value”: “XXXXX”,
“id”: “XXXXX”
},
{
“value”: “XXXXX”
}
]
],
“summary”: [
{
“value”: “Total”
},
{
“value”: “XXXXX”
},
{
“value”: “XXXXX”
},
{
“value”: “XXXXX”
},
{
“value”: “XXXXX”
}
],
“IMTLENGTH”: 1,
“IMTINDEX”: 1
}
]
I’ve managed to get the value 5 out of section but when I do it for sections (in a different iterator) the array is empty. I need them for all accounts (and there are 3 in “sections”) in one place so I can put them all through a filter. Thanks again
