Summary:
FleetWave API PUT requests can fail with a “Duplicate field value found” error when updating records if fields configured under “Duplicate Field” in the table schema are not included in the payload. This occurs even when those fields are not being actively updated.
Resolution Steps:
- Navigate to the relevant module and table:
- Example: Vehicles → Three Dots → Show Details → Table Schema → Configure tab
- Review the “Duplicate Field” configuration
- Identify all fields listed as duplicate-controlled
- Validate existing data
- Ensure all records have unique, non-null values for each duplicate field
- Check for both NULL and empty string values
Choose an approach:
Option A: Include duplicate fields in API payload
- Add all duplicate-controlled fields to the PUT request
- Populate them with their current values for the record
Option B: Remove field from Duplicate Field configuration
- Remove any fields that do not need uniqueness enforced
- Save configuration changes
- Re-test the API request
- Confirm the update completes without duplicate validation errors
Additional Notes:
- Duplicate field validation is applied during API updates regardless of whether the fields are included in the payload
- This can impact partial updates where only a subset of fields is intended to be changed
- Whether a field is auto-generated or user-maintained does not affect duplicate validation behaviour