move hard-coded JSON into db_interface
create initial API connection interface