Airtable Enrichment Issue: Lookup and Upsert Records Failing

Brian · 2025-02-21T05:29:51.58963+00:00

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 (https://www.loom.com/share/3cc34467c2eb49a4a46c74f0d5c39ca7?sid=62c621a0-9b57-4a74-b655-90c46cca9719)

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

2 comments