Help get this topic noticed by sharing it on Twitter, Facebook, or email.
Andrew Murphy August 06, 2018 22:04

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
  • EMPLOYEE
    Bill Emerson (Developer) August 06, 2018 22:08
    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.
    Comment
    good answer! good answer! (undo)
  • (some HTML allowed)
    How does this make you feel?     Add Image
    I'm

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

    Cancel