I have a table for users and a column (object data type) for profiles. The profile schema is very simple: profile_id, profile_firstname, and profile_lastname.
I have an endpoint that takes a new profile firstname and lastname. It finds the last profile on the user and pops off the profile_id, adds one to 'autoincrement'. Everything is working except the Add Record step.
I have tested filters for the profiles column to be: merge, append, and set. Yet none of these are simply adding the values to this object array as I need. Instead, the existing values are deleted and the new values never show up.
Here is a Loom video showing how the API function is actually deleting any previous records and not storing the new values.
I appreciate any guidance here!!