1 Reply Latest reply on Aug 19, 2015 11:58 AM by anchorbuoy

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

    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?