How to parse a json into a Repeating group

Hi everyone! Happy new year.

Im trying to develop a xml reader to show as a list in a repeating group.
Im currently generating a json from this xml file in an element, how should I proceed to display this json as a list in a repeating group? For now it is not necessary to save in database, it can be a custom state, the problem is that Im not able to display the generated data in the repeating group.
An example of my current json is this:
{
“OFX”: {
“SIGNONMSGSRSV1”: {
“SONRS”: {
“STATUS”: {
“CODE”: “0”,
“SEVERITY”: “INFO”
},
“DTSERVER”: “20220103111908”,
“LANGUAGE”: “POR”
}
},
“BANKMSGSRSV1”: {
“STMTTRNRS”: {
“TRNUID”: “1001”,
“STATUS”: {
“CODE”: “0”,
“SEVERITY”: “INFO”
},
“STMTRS”: {
“CURDEF”: “BRL”,
“BANKACCTFROM”: {
“BANKID”: “XXXX”,
“ACCTID”: “XXXXXXXXXXX”,
“ACCTTYPE”: “CHECKING”
},
“BANKTRANLIST”: {
“DTSTART”: “20211201”,
“DTEND”: “20211231”,
“STMTTRN”: [
{
“TRNTYPE”: “DEBIT”,
“DTPOSTED”: “20211202120000[-3:BRT]”,
“TRNAMT”: “-XX.XX”,
“FITID”: “XXXXX”,
“CHECKNUM”: “XXXXX”,
“MEMO”: “TRANSACTION DESCRIPTION”
},
{
“TRNTYPE”: “CREDIT”,
“DTPOSTED”: “20211210120000[-3:BRT]”,
“TRNAMT”: “XX.XX”,
“FITID”: “XXXXX”,
“CHECKNUM”: “XXXXX”,
“MEMO”: “TRANSACTION DESCRIPTION”
}
// … mais transações conforme necessário
]
},
“LEDGERBAL”: {
“BALAMT”: “XXXXX.XX”,
“DTASOF”: “20220103”
}
}
}
}
}
}

Thank you!!

1 Like

you could create an api call with json as result.

Hi @daviddr17, Thanks for your answer!

I am trying to setup the api connector and api workflow to get the value of json from an element and display in repeating group! But As I never did this before im struggling a bit!
Do you have any example of this setup or know where to find an example?

min 8:38

1 Like

Thanks @cmarchan!

That worked properly!
It is already working! Thanks again!!

1 Like