.png&w=3840&q=75){kind=logo}
Issues with Lookup Single Row Functionality in Database Queries
Why does lookup single row doesn't work? I have t fill in table ID, but it won't recognize any of my existing tables. Do you have any support documentation
👋 Hey there! Our support team has got your message - we'll be back in touch soon. If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Stefano··Hi sam, thank you for reaching out. The most likely reason this is not working is because the API key you have inserted for your Clay account is outdated or incorrect. Do you mind sending the link to the table so I can take a look and verify this? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1736260200&signature=0fa7224615f93c00d5d9931dcc03652039338defec71e2e3ddb79c853e3f53b9&req=dSEgF85%2FmohWX%2FMW1HO4zYTywS3%2BAJcU2BKsam%2FhVPtsng%3D%3D%0A
Sam W.··Thanks for helping so quickly, Really struggling with this..
- Sam W.··
I have the same problem also for lookup with google sheets
- Stefano··
Hi Sam, I have created an Api Key called "NEW API KEY CLAY" which, as you can see the below, is able to find the tables associated with your account, shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1324506003/60ac1aef728ae2e9720537dcd5e7/CleanShot+2025-01-07+at+15_01_44%402x.png?expires=1736260200&signature=6b0cddc8f8f4da34ad24f7cca5e79d6aea54e210cf29d002cb83c0691543ad5c&req=dSMlEsx%2Bm4FfWvMW1HO4zQDdU8VyolavLXu76r6r0X0aAgO4Sc6ZkMhAKMvF%0ACFon%0A Use this key now when trying to do Lookups and it should work! Let me know if this helps!
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.