Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

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

Issues with Lookup Single Row Functionality in Database Queries | Clay

7 comments

· Sorted by Oldest

Channeled
APP
·
·
👋 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.
·
·
https://app.clay.com/workspaces/366230/tables/t_TxbjXPwjR5XE/views/gv_SP6nx2W9dH4j
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!
Channeled
APP
·
·
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.