I'm with you on this one.
There are a few work-arounds (not so great) to this one....
- Build a little custom side job that runs daily and pulls a list of all deal ids, and all contact ids from hubspot. Then delete the extra rows from the stitch data tables... not so great.
- Try and train your users to NOT delete things - too bad there are no user level permissions that prevent deleting. (Too bad permissions are not managed at the group level....) - and train them to set a custom property like 'Delete This Record Yes/No' - and have a secondary integration delete them through an api call.
#1 is preferred I suppose, but it's really frustrating to us that to get a simple list of all vids we have to write all kinds of looping api code, get next page of ids, etc. and in this day and age we are limited to retrieving 100 ids at a time. That's 1,200 api calls just to get a list of vids from hubspot.
How about a GetAllContactVids api endpoint or something?