enhancing api functionalities and database updating