raise better error message if metadata is not found in json files

[jdkent]

Is your feature request related to a problem? Please describe.

319 and #323

Describe the solution you'd like instead of the opaque KeyError message, there should be a clearer message on what is missing.

Describe alternatives you've considered N/A

Additional context v0.6.0