Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Get lookup Id values for load table

if you are creating a load table and you need to query Salesforce for lookup ID values, what is the best way to do this using bulk operations? or do you use a query?
1 person has
this question
+1
Reply
  • It all depends on the source data.

    If the other object has an external id and you know that value, you can use that as the lookup value and force salesforce to lookup the actual id.

    If you want to stick with regular salesforce ids, then it is a question of volume. If your load table has 100K records, then avoid looking up foreign key ids one at a time. Instead, write a query to download the id and any other columns needed and lookup against the local table.

    On the hand, if the load table is just 5 rows for example, looking up values with a query against the linked server table is fine.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned