Clay Icon

Error in Lookup Function: Invalid Filter Value Encountered

·
·

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}

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    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

  • Avatar of Aviv F.
    Aviv F.
    ·
    ·

    Doesn’t make sense still

  • Avatar of Aviv F.
    Aviv F.
    ·
    ·
  • Avatar of Aviv F.
    Aviv F.
    ·
    ·

    ??

  • Avatar of Daniel K.
    Daniel K.
    ·
    ·

    Hey, sorry for the dealy. I jumped into the table and noticed you got it working now, correct? Glad it ended up running after but do let us know if it gives you any trouble again!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·