this is more a question regarding the process/workflow.
Im using a api to create things in the database or to update an existing thing if a specific id is already existing.
But here it comes:
What’s about data that are not longer available via api? I.g. Because something were deleted on the external endpoint.
In my current workflow it will still exist in my database. But not longer be updated.
But I want to delete this thing in my database too if it was deleted on the external endpoint.
Any idea? My first thought was using the modification date in the database. But this will only be updated if there is any change. If there is no change for this item the date will not be updated.