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.!