Nowdays, in Reqnroll, you can use External Data Plugin to acomplish just that! It supports various file formats, including JSON and the file structure you have present should work just fine :)