I am getting records fed into my org from an external system at a pretty rapid clip (600 - 1500 per day) and I would ideally like to use Process Builder to help me manage this data - but I have a concern about batch safety. Here is my use case:
- Records are pushed in from an external system, each with an External ID. The External ID field is set as indexed in my org
- If a change is made to a record in the external system, that same record is pushed in to Salesforce again with the same unique external ID - but with different field values
I would like to use process builder to trigger a flow upon creation of these records, that performs a fast-lookup for any record with the same External ID as the new record, and then performs a fast delete of those records.
All pretty easy from a setup standpoint - my question is will I run into issues because so many records are being pushed in at a time? Will this hold up with a high volume of records being pushed in?
Thanks,
John
2 risposte
Question - can't you just do the push as an upsert instead of an insert? That would seem a lot easier and kind of the idea behind the External ID capabilities
