AnsweredAssumed Answered

Best way to delete a set of records, from a list of IDs?

Question asked by anchorbuoy on Aug 19, 2015
Latest reply on Aug 19, 2015 by anchorbuoy

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?

Outcomes