Clay Icon

Issues with Salesforce Upsert Record: Key not found error when selecting table

·
·

Hey folks - when I try to Salesforce Upsert Record and select a table it just fails. Says “Key not found” but the column doesn’t have any other options.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Gregory G.
    Gregory G.
    ·
    ·

    This fast? Are you serious 😂

  • Avatar of Gregory G.
    Gregory G.
    ·
    ·

    Ohh I see it’s a bot - fair play anyway!

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey there Gregory thanks for reaching out. Taking a look.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hey there Gregory sorry for the delay, did some digging around to find what was going on and so the issue here is that Salesforce Upserts, in general, require a field in Salesforce to be marked as an external ID. According to the key you’re using in Clay, no fields in your Salesforce organization are marked as an externalID, so you can’t actually run upserts because no fields load for the upsert key.“ExternalID” is a salesforce setting that says “this field can be used to dedupe salesforce records, but its values come from another source”We can definitely make changes to enable this in our regular lookups, as mentioned in this thread, but the quickest win here would be to mark a field in salesforce as an external ID and then try again

  • Avatar of Gregory G.
    Gregory G.
    ·
    ·

    Do you have a recommendation for what to use as external id?

  • Avatar of Gregory G.
    Gregory G.
    ·
    ·

    I.e person’s email or internal Clay UUID

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Sorry for the delay, a person's email would work best, you would want it to be a data point that most leads are likely to have.