Troubleshooting of Airtable API

This article "Troubleshooting of Airtable API" is still being written. If there are any incomplete parts, you are welcome to directly edit them. 這篇文章「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.

Navigate to the Airtable developer page on Authentication - Airtable Web API.
From there, proceed to access token management.
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

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