Have a look at the JSON path module.
It is designed to parse more complex JSON structures into Mendix objects.
https://appstore.home.mendix.com/link/app/107685/
Alternatively you can take a look at JSON Structure, which converts it into JSON objects and arrays.
https://appstore.home.mendix.com/link/app/113010/