Clay Icon
Join the Community
02 Support

Troubleshooting Lookup Single Row in Other Table Issues

Avatar of João T.João T.
·
·

Hello, I'm not being able to use the "Lookup Single Row in Other Table" enrichment as the "Table to Search" field's dropdown isn't being populated with my workbook's tables. I have tried to use the table ID directly but it doesn't accept it either. I've also hard refreshed the page multiple times and re-logged but still facing the same issue

6 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    We're sorry to hear you're experiencing issues with the "Lookup Single Row in Other Table" enrichment. The "Table to Search" field should typically populate with your workbook's tables. If this isn't happening, it could be due to a technical glitch or a temporary issue with the interface. To troubleshoot this issue, you could try the following steps: 1. Clear your browser cache and cookies, then reload the page. 2. Try accessing the workbook from a different browser or device. 3. Ensure you have the necessary permissions to access all tables in the workbook. If these steps don't resolve the issue, could you please provide more details about your workbook setup? For example, how many tables are in your workbook, and are you able to see and access these tables in other parts of the Clay interface?

  • Avatar of João T.
    João T.
    ·
    ·

    I have also noticed that other columns I've previously successfully set as single lookup enrichments now display the table's raw ID rather than its name, as they did before:

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, Did you recently make any changes to your Clay API key? If so, you’ll need to reset it in your settings to get everything working again: 1. Go to Settings > Accounts > API Key 2. Then head to Settings > Connections 3. Search for Clay under connections 4. Remove the old API key and paste in the new one Once that’s done, the dropdown should populate correctly, and your lookups should start working again. Let me know if you need help walking through it.

  • Avatar of João T.
    João T.
    ·
    ·

    I did not make any changes to my Clay API key, but re-generating one and updating it under Clay's connection solved it. Thank you!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·