I'm building a backend data sync engine, and part of the engine needs to be able to delete a set of records. I'm using carriage return-delimited lists to pass the record IDs around, so am looking for the best way to perform a deletion based on that.
The list of IDs could range from roughly 1 to 1,000 values in length.
I had been planning to use Selector-Connector (set the "select" field to the list of IDs), but it looks like I can't effectively delete related records that way (it has to be done via portal, which is bad enough, but also there's limited support for `Go to Portal Row` script step on FM Server).
What's the best way to go about this? Is the only option to use a cascading delete?