updated api calls, added entries into sql test data