api added and db resorts