Error in Lookup Function: Invalid Filter Value Encountered

Aviv F. · 2025-03-20T19:36:17.99326+00:00

Trying to use the lookup multiple rows and suddenly mid table it starts giving me an error: {"type":"BadRequest","message":"Invalid filter value 8603118517 for field f_vUUhAN93BfQh","details":null}

The error you're encountering suggests an issue with the filter value you're using in the "Lookup Multiple Rows in Other Table" action. This action allows you to search for data in another Clay table based on specific criteria. To troubleshoot this issue, we need more information about your JSON setup. Could you please copy and paste the full JSON configuration for this action into the chat? This will help us identify any formatting issues or incorrect values that might be causing the error. In general, when using this action, make sure you've correctly specified: 1. The table to search 2. The target column 3. The filter operator 4. The row value 5. An optional limit for the number of rows to return

Sources: Lookup Rows | Documentation | Clay University Lookup Rows | Documentation | Clay University

7 comments