Make Airtable 422 INVALID_VALUE_FOR_COLUMN: match the value to the field type

Описание и применение

Ошибка 422 INVALID_VALUE_FOR_COLUMN в Airtable возникает, когда Make отправляет данные, не соответствующие типу поля. Решение – проверить тип поля в Airtable и преобразовать значение в Make (parseNumber, formatDate, boolean, split, record IDs).

Задача

Airtable 422 INVALID_VALUE_FOR_COLUMN errors occur when Make sends data that does not match the field type, such as text into a number field or a string "true" into a checkbox.

Результат

After converting values to match Airtable field types, the 422 INVALID_VALUE_FOR_COLUMN errors disappear and records are created or updated successfully.

Рабочий процесс

• Open the failed run in History and click the Airtable module’s bubble to view the input bundle sent to Airtable.
• Identify the field name or ID mentioned in the error message.
• Check the field type in Airtable (Number, Checkbox, Date, Single select, Multiple select, Linked record).
• Convert the value in Make’s mapping: use parseNumber() for numbers, formatDate() for dates, boolean for checkboxes, split() for multiple selects, and record IDs for linked records.
• If a source field may be empty, map it with ifempty() or omit it; to clear a field in Update a Record use the erase function.
• Run the module again with "Run this module only" using the same input to verify success.

Доказательства

An Airtable 422 in Make means Airtable understood the address but rejected the data. With INVALID_VALUE_FOR_COLUMN the value you mapped does not fit the field type

Источник

Open the failed run in History, click the Airtable module's bubble and read the input bundle. That is what Airtable received, not what the mapping panel shows.

Источник

Check its type in Airtable, then convert in the mapping: parseNumber() for numbers, formatDate() for dates, a boolean for checkboxes, split() for multiple selects.

Источник