Troubleshooting of Airtable API

Troubleshooting of Airtable API

How to fix INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND

Error message:

[type] => INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND
[message] => Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct.

Solution: Verify the permissions of your API token.

1. Navigate to the Airtable developer page on Authentication - Airtable Web API.
2. From there, proceed to access token management.
3. Review the permissions of your API token, such as access levels or scopes of bases.

How to fix INVALID_VALUE_FOR_COLUMN

Error message:

[type] => INVALID_VALUE_FOR_COLUMN
[message] => Field "欄位名稱" cannot accept the provided value

Solution: Check the data type of field

• Go to the Airtable
• Select the field which met error e.g "欄位名稱" mentioned in the error message
• Menu: Edit field
• Choose the proper data type e.g. switch from "short line text" to "number"
• If the data type of the field is a number and null values are allowed, you need to convert empty strings "" to NULL before writing to Airtable.

Example data: Input data of different data types, whether writing to Airtable is successful or the error message received.

Field value	Instruction of field value	Single line text	Long text	Number (Decimal 1,0)	Number (Integer 2)
""	Empty string	ok	ok	INVALID_VALUE_FOR_COLUMN	INVALID_VALUE_FOR_COLUMN
"0" or '0'	Quoted number	ok	ok	INVALID_VALUE_FOR_COLUMN	INVALID_VALUE_FOR_COLUMN
0	Number without double quote	INVALID_VALUE_FOR_COLUMN	INVALID_VALUE_FOR_COLUMN	ok	ok
456	Integer	INVALID_VALUE_FOR_COLUMN	INVALID_VALUE_FOR_COLUMN	ok	ok
78.9	Number with decimal point	INVALID_VALUE_FOR_COLUMN	INVALID_VALUE_FOR_COLUMN	ok	ok
NULL	NULL value	ok	ok	ok

How to fix UNKNOWN_FIELD_NAME

Error message:

[type] => UNKNOWN_FIELD_NAME
[message] => Unknown field name: "XXX"

Solution: Check the field name

1. Navigate to your Airtable table.
2. Verify that the specified field name ("XXX" in this case) exists in the table.
3. If it doesn't, ensure you're using the correct field name in your query or action.

Further reading

• Airtable API Common Troubleshooting | Airtable Support
• Field Type overview | Airtable Support
• Publish as blog version: 解決 Airtable API 常見問題

References

Troubleshooting of ...

• Troubleshooting of Excel errors

• PHP, cUrl, Python, selenium, HTTP status code errors

• Database: SQL syntax debug, MySQL errors, MySQLTuner errors or PostgreSQL errors

• Troubleshooting of regular expression

• HTML/Javascript: Troubleshooting of javascript, XPath

• Software: Mediawiki, Docker, FTP problems, online conference software

• Test connectivity for the web service, Web Ping, Network problem, Web user behavior, Web scrape troubleshooting

Template

• Bug report template