API tested in in memory database.