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

**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
