I have a postgres database on my heroku instance tied to various salesforce custom objects. Whenever I write true to the isdeleted field in my table everything is fine. However, after it syncs with salesforce the isdeleted is written back as false. Is there some way to set this field?
IsDeleted field is a system field and we cannot update this field.This field is automatically set when the record is moved to the Recycle Bin (true) or not (false).
You can find more details in below link: https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/system_fields.htm
You can try to map your field with a custom field and do your operations with that custom field.