How do I find deleted posts via API?

I use the API to store posts in my database so I don’t have to call the API every time I want to display data for every user. This also allows me to connect the data fully to all of my tables, add it to views, etc.

I then can show information about posts on my website, outside of discourse.

But since there’s apparently no way to find out when posts are deleted, I end up showing some deleted posts and people don’t understand why the links aren’t working right.

I don’t understand why there’s no way to find deleted posts? It seems a very obvious tool. There’s even a field in posts.json for “user deleted”, but this field apparently can never be True, because the posts.json will never show a deleted post. So either that field shouldn’t exist or the posts.json should be showing deleted posts.