Troubleshooting of Airtable API

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.

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"

Further reading

• Airtable API Common Troubleshooting | Airtable Support

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