remove deleted properties and filter by is_deleted

The name says it all. I had forgotten to handle soft deletes so soft deleted items were still coming out the API.

@markstuart @WayneKoorts can i get a code review please