Updating api + adding additional sql views