Skip to main content

API Error on " filterByFormula "

  • August 16, 2022
  • 5 replies
  • 25 views

Today Airtable give me error on “filterByFormula” it was working fine earlier. Anyone had same problem like me.? reply : Error parameter validation fail

Thanks.

5 replies

Justin_Barrett
Forum|alt.badge.img+21

Welcome to the community, @Saksin_CCM! :grinning_face_with_big_eyes: A lot more detail is needed before we can help with this issue. An error message alone isn’t sufficient. Please share as much detail as you can about your use case: code examples, screenshots, etc.


Forum|alt.badge.img+13
  • Inspiring
  • August 16, 2022

Adding on to what @Justin_Barrett shared, are you sure a related field was not renamed or reconfigured in some way? ()That can affect formulas and therefore the base REST API’s filterByFormula parameter)


Forum|alt.badge.img+19
  • Inspiring
  • August 17, 2022

Actually, I’ll bet it only seemed like it was working. My hunch is your code finally encountered a data pattern that it didn’t support. In almost every case, API errors like this are related to encoding, specifically quotes.

Examine the exact call (URL containing the filter) you are making to Airtable - you almost certainly will spot the error.


  • Author
  • New Participant
  • August 17, 2022

I did not rename or do anything, all other apps with original code I have (Thubkable X) not working at all after compiler to apk for Android. I used same code repleted again to test and result is same error with parameter validation fail. If my field is rename the existing app should not running right? But it is happen only re-complier to new version.


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • August 17, 2022

I did not rename or do anything, all other apps with original code I have (Thubkable X) not working at all after compiler to apk for Android. I used same code repleted again to test and result is same error with parameter validation fail. If my field is rename the existing app should not running right? But it is happen only re-complier to new version.


Something is probably different somewhere

  • something different in the base field names and/or types
  • something different in your code
  • something different in the data in the base
  • something different in your inputs used to generate the formula

Does the old code still work?