Error in Lookup Enrichment: Invalid Filter Value Encountered

hi, there's some trouble in my look up enrichment. It shows me this error message: {"type":"BadRequest","message":"Invalid filter value 655471 for field f_5zN6NAdJKhFU","details":null}. But when I search for the companyId (the value that I search for) does exist in the other table

11 comments

Channeled
APP
·
·
The "BadRequest Invalid filter value" error you're experiencing could be due to a few reasons. To help troubleshoot, we'd need to see the full JSON response. Could you please copy and paste the complete JSON error message into the chat? In the meantime, here are a couple of things to check: 1. Ensure your Clay API key is correctly linked in your account settings. 2. Double-check that the column names and data types match between the tables you're trying to link. If the issue persists after verifying these points, sharing the full JSON will help us provide more specific guidance.
Source: Write to Other Table | Documentation | Clay University
Clarissa S.
·
·
but for some it does work
Channeled
APP
·
·
The "BadRequest Invalid filter value" error you're experiencing with your lookup enrichment could be due to a few reasons. To help troubleshoot, we'd need to see the full JSON response. Could you please copy and paste the complete JSON error message into the chat? In the meantime, here are a few things to check: 1. Ensure the data types match between the tables you're trying to link. 2. Verify that the column names are correct in both tables. 3. Check if there are any hidden characters or formatting issues in the companyId values. If the issue persists after verifying these points, sharing the full JSON will help us provide more specific guidance.
Source: Lookup Rows | Documentation | Clay University
Clarissa S.
·
·
how do I see the JSON response
Channeled
APP
·
·
To view the full JSON response for a lookup enrichment error in Clay, you'll need to copy and paste the complete JSON error message into the chat. This will help us troubleshoot more effectively. If you're not sure where to find the JSON response, check the following: 1. Look for any error messages or logs in your Clay workspace. 2. If you're using the HTTP API integration, check the response section of your enrichment setup. Once you have the full JSON, please paste it here so we can help identify and fix any issues.
Source: HTTP API integration overview | Documentation | Clay University

Clarissa S.

{"type":"BadRequest","message":"Invalid filter value 655471 for field f_5zN6NAdJKhFU","details":null}

Channeled
APP
·
·
The "Invalid filter value" error you're experiencing could be due to a few reasons. Here are some steps to troubleshoot: 1. Check for data type mismatches between the tables you're linking. 2. Verify that the column names are correct in both tables. 3. Look for any hidden characters or formatting issues in the companyId values. If the issue persists, it would be helpful to see the full JSON response. Could you please copy and paste the complete JSON error message into the chat? This will allow us to provide more specific guidance. If you need further assistance, you can request human support by clicking on "Talk to a person" in this chat.
Source: Write to Other Table | Documentation | Clay University
Clarissa S.
·
·
talk to a person
Clarissa S.
·
·
https://app.clay.com/workspaces/431194/workbooks/wb_0sw3q6fsmgtTwdYdCS7/tables/t_0sw3rs05NX5RyJs66fv/views/gv_0sw3rs1XbQFu4aHYqBP
Bo (.
·
·
Hey, is it possible this got resolved already? I just checked the table and I’m not seeing the error anymore. Let me know if it’s still showing up on your side.
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.

Error in Lookup Enrichment: Invalid Filter Value Encountered | Clay