Skip to main content

Hi there, 

here is my cURL as mentioned in the title i'm having issues just on iOS while on Android it works with no problem.

https://api.airtable.com/v0/appOwBv51ihqo****/TableName?filterByFormula=FIND("february",{Mese%20Nome})=1&sort%5B0%5D%5Bfield%5D=Created&sort%5B0%5D%5Bdirection%5D=desc

Status: 422

Error: undefined

I'm really confused, hope you can help

 

I also tried the API call in Postman, and it works great


I also tried the API call in Postman, and it works great


edit:

Error 422: "the formula for filtering records is invalid: Uknwon field names: mese%20nome

As you can see from the link above, i specify “Mese%20Nome” (first capital letters) as field, and it actually exists in Airtable.
I think it’s iOS that automatically changes this field to lowercase letters and it won’t help me to go through (it recognizes “mese%20nome” and not “Mese%20Nome”).
I tried to force capital letter using “uppercase” but it didn’t work.

The tablename has also its capital letters but it seems not to be a problem

Please tell me there is a smart solution, changing all the tables/fields and all the code in lowercase letters will take me at least 4 weeks of pure stress.

I hope you can help,

thank you very much.


edit:

Error 422: "the formula for filtering records is invalid: Uknwon field names: mese%20nome

As you can see from the link above, i specify “Mese%20Nome” (first capital letters) as field, and it actually exists in Airtable.
I think it’s iOS that automatically changes this field to lowercase letters and it won’t help me to go through (it recognizes “mese%20nome” and not “Mese%20Nome”).
I tried to force capital letter using “uppercase” but it didn’t work.

The tablename has also its capital letters but it seems not to be a problem

Please tell me there is a smart solution, changing all the tables/fields and all the code in lowercase letters will take me at least 4 weeks of pure stress.

I hope you can help,

thank you very much.


Hm, long shot, but could you try URL encoding your "{" and "}" as well?


Hm, long shot, but could you try URL encoding your "{" and "}" as well?


Sorry, i think i didn't understand.

You mean to swap the "&" and put "and" instead?

Thank you for your help


Sorry, i think i didn't understand.

You mean to swap the "&" and put "and" instead?

Thank you for your help


Ah, no, I meant to try the URL with everything URL encoded, so your "{" would be "%7B" and the "}" would be "%7D".  I just noticed the "()" and "=" need to be encoded too, so it'd be:

https://api.airtable.com/v0/appOwBv51ihqo****/TableName?filterByFormula=FIND%28%22february%22%2C%7BMese%2520Nome%7D%29%3D1&sort%5B0%5D%5Bfield%5D=Created&sort%5B0%5D%5Bdirection%5D=desc

 Worth a shot!


Ah, no, I meant to try the URL with everything URL encoded, so your "{" would be "%7B" and the "}" would be "%7D".  I just noticed the "()" and "=" need to be encoded too, so it'd be:

https://api.airtable.com/v0/appOwBv51ihqo****/TableName?filterByFormula=FIND%28%22february%22%2C%7BMese%2520Nome%7D%29%3D1&sort%5B0%5D%5Bfield%5D=Created&sort%5B0%5D%5Bdirection%5D=desc

 Worth a shot!


i tried this, which includes all the correct value apart from the app ID, but it gives me the same error.

To be fair now, with this code it's giving me the same error on Android too (it wasn't happening before)

https://api.airtable.com/v0/appOwBv51ihqoT***/teamtime020?filterByFormula=FIND%28%22marzo%22%2C%7BMese%2520Nome%7D%29%3D1&sort%5B0%5D%5Bfield%5D=Created&sort%5B0%5D%5Bdirection%5D=desc


kinda found the issue, it' in the filterByFormula.

Android reads properl {Mese%20Nome}, while iOS only read {Mese+Nome}.


Reply