Troubleshooting of Airtable API: Difference between revisions

From LemonWiki共筆
Jump to navigation Jump to search
No edit summary
Line 24: Line 24:


Solution: Check the data type of field
Solution: Check the data type of field
* Go to the airtable
* Go to the Airtable
* Select the field which met error e.g "欄位名稱" mentioned in the error message
* Select the field which met error e.g "欄位名稱" mentioned in the error message
* Menu: Edit field
* Menu: Edit field
* Choose the proper data type e.g. switch from "short line text" to "number"
* Choose the proper data type e.g. switch from "short line text" to "number"
== How to fix UNKNOWN_FIELD_NAME ==
Error message:
<pre>
[type] => UNKNOWN_FIELD_NAME
[message] => Unknown field name: "XXX"
</pre>
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.


== Further reading ==
== Further reading ==

Revision as of 14:29, 17 August 2023

Troubleshooting of Airtable API


icon_scale_pencil.png 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"

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

References


Troubleshooting of ...

Template