CORE-5832 Updated refactored endpoint JSON keys.

Simplified and standardized key names in refactored endpoint JSON responses to match the new database column names.