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
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.
but for some it does work
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.
how do I see the JSON response
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.
{"type":"BadRequest","message":"Invalid filter value 655471 for field f_5zN6NAdJKhFU","details":null}
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.
talk to a person
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.
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.