Something like import mappings: https://docs.mendix.com/refguide7/import-mappings/ ?
This example shows a mapping used in combination with the external database connector: the sql query generates a nested json structure, this is mapped to multiple persistent mendix entities using an import mapping: