Airtable Enrichment Issue: Lookup and Upsert Records Failing

Possible bug? Airtable Lookup Record and Upsert Record enrichments are failing to locate matching records, but I’ve confirmed the lookup key is present (manually), and if I delete and re-enter the last letter of the lookup key, the enrichment is successful (but nothing has changed). I’ve recorded a loom illustrating the issue here

2 comments

Channeled
APP
·
·
We're sorry to hear you're experiencing issues with the Airtable Lookup Record and Upsert Record enrichments. The behavior you're describing, where manually re-entering the last letter of the lookup key resolves the issue, suggests there might be a problem with data formatting or whitespace. To troubleshoot this issue, we recommend checking the following: 1. Ensure there are no trailing spaces in the lookup key fields. 2. Verify that the data types in Clay match those in Airtable. 3. Check for any hidden characters that might be affecting the lookup process. 4. Confirm that the Base ID and table name are correct in your Clay configuration. Have you noticed any patterns in the data where this issue occurs more frequently?
Sources: Lookup Record with Airtable Airtable integration overview | Documentation | Clay University Upsert Record with Airtable
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.