Clay Icon

Troubleshooting Lookup References in Clay Tables

·
·

Hey Team, I am new to clay, and having a hard time in creating look up references to other table in clay. When I try to do this, it shows me empty list in the Find Table By Id dropdown.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To use lookup references in Clay, you'll first need to ensure you have your API key set up properly. Here's how to get started: 1. Get your API key: • Click your profile picture in the top navigation bar • Select Settings • Find your API key under "Your Profile" 2. Once you have your API key, you can use either: • "Lookup Single Row" for finding one specific record • "Lookup Multiple Rows" when you need to find several matching recordsIf you're still seeing an empty dropdown after setting up your API key, please let me know and I can help troubleshoot further. Sources: Lookup Multiple Rows in Other Table with Clay Lookup Single Row in Other Table with Clay Guide: How to find your Clay API key - Clay University

  • Avatar of Aditya M.
    Aditya M.
    ·
    ·

    Yes I have setup api key and still I don't see anything in the dropdpwn

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Let's double-check your API key connection, as this is often the source of lookup reference issues. First, verify that your API key is properly connected under Settings > Connections > and search for Clay.The lookup feature requires a valid API key to: 1. Access "Lookup Single Row" functionality 2. Access "Lookup Multiple Rows" functionality 3. Enable table connectionsIf you've confirmed your API key is correctly set up under Settings > Your Profile > API Key and you're still experiencing issues, please let me know and I can help investigate other potential causes. Sources: Guide: How to find your Clay API key - Clay University Lookup Single Row in Other Table with Clay Lookup Multiple Rows in Other Table with Clay

  • Avatar of Aditya M.
    Aditya M.
    ·
    ·

    actually yes, now it works

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Excellent! I'm thrilled to hear it's working now and I'm here if you need any further assistance.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Aditya M.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback Aditya M.!