GET API Method whit JSON

[avv]

Can somebody help me with parsing the following JSON - https://bank.gov.ua/depo_securities?json
I try to do this in bpm - but can't understand how to collect and parse data.
unfortunately in documentation I can't find any examples.

Thank a lot!

[emillod]

You should run foreach for whole list, for example $body[0]['cpcode'], to get cpcode of code record. I don't think there is a formula which work like foreach in php.
Interesting. If there is no such thing, i'll try to code something like this in our extension custom-formulas.

Ping me if you'll don't have any response in few days.

[emillod]

You can play with while https://docs.espocrm.com/administration/formula/#while