I m trying to create or update custom field values using the v3 API.
- find out if a custom fieldvalue exsists,
- if it does update it
- if it does not, create it.
The problem is in the first step:
There is no GET /fieldValues documented, however, this endpoint does exist and returns all field values, but filter[contact] or filter[field] are not supported it seems. The only way would be to get all filedvalues for all fields and contacts and then filtering them in my client, but for 40K records, this is very inefficient.
Another option would be to do a POST and then a PUT if it returns an error. I can create a fieldValue using POST /fieldValues, but if I POST the fieldValue again, the post gets accepted (with a new id) and does not return an error. Furtermore, the value does not change in the UI.
Is there another way to do this, or can the Get /FieldValues be extended with filters on contact and field. An alternative would be to return an error if the contact/field combination alreay exists on POST.