Nov 11, 2022 07:11 PM
The REST call from Appgyver for a new record fails, because the call has a ‘null’ for a linked record. Appgyver won’t remove the field just because its blank, so a null is sent - and Airtable breaks on it.
Nov 12, 2022 02:43 AM
Assuming that the primary field of your linked table allows data to be written to it, you have 3 choices when posting your data to your linked record field:
You will either need to:
(1) Not send any data to that field at all,
(2) Create a “null” record in your linked table that your linked record field can link to, or
(3) Enable the “typecast” parameter in your API call, which will automatically create the “null” record in your linked table.
Nov 13, 2022 11:14 AM
Actually, I just realized that “typecast” must be enabled for both the #2 and #3 scenarios above. You must always send a Record ID to a linked record field UNLESS typecast is enabled. Then, you can send the primary field name of an existing record OR a new record that doesn’t yet exist.
Nov 13, 2022 06:42 PM
It might be also related to linked field expecting array - try sending empty array?