Conditional delete from a databases using a value from the pipeline

I'm trying to delete rows from my database when their id's aren't in the response document returned from an api query. Currently, my pipeline looks like this:

If there is an ID value in the SQL Server table that is not in the REST response document, I want to delete that row from the table. Here's my current non-working SQL Query:

But this doesn't work; it doesn't delete anything from the target table. How can I delete rows form the table when they aren't present in the api response?