How to handle multiple nested collections in Visual Builder add-in for Excel

Summary

How to handle multiple nested collections in Visual Builder add-in for Excel

Content

In the Oracle Visual Builder add-in for Excel, a form-over-table layout can be used to support parent-child business object relationships e.g. supplier and supplier site.

However, we have a REST API where there are multiple nested child collections, and properties need to be supplied at each level to be of any use. For example:-

https://****.oraclecloud.com/fscmRestApi/resources/11.13.18.05/financialProjectPlans

This has several nested levels of child collections, and properties from each level need to be included to bulk update a financial project plan resource assignment. For example:-