I have an external service bulk inserting a task and including a foreign key to my table
The service will be creating ~100-500 tasks at a time.
I'm trying to build a bulkified trigger to perform a SOQL via the foreign key and then insert the correct id into the Task Related To/WhatId.
On insert of Task where:
iter = [select id,BusinessUUID__c from Task]
biz = [select id from Business where Business_UUID__c = :iter.BusinessUUID__c]
Obviously, I'm trying to avoid calling the soql's above within a for loop so currently I'm considering assigning the entire
business object to a map?