Change of rack location via API does not work

[TorstenEhrhardt]

Deployment Type

Self-hosted

Triage priority

N/A

NetBox Version

v4.1.7

Python Version

3.11

Steps to Reproduce

• Create Rack in a site and location
• facility id is not set (null)
• send patch request to /api/dcim/racks/:id/ with payload

{
    "location": {
        "name": "Other location",
        "site": {
            "name": "Other site"
        }
    },
    "site": {
        "name": "Other site"
    }
}

or only change location with a global unique location

{
    "location": {
        "name": "Other location"
    }
}

Example performed on https://demo.netbox.dev

Expected Behavior

Location and site of rack is changed, like it does in the frontend

Observed Behavior

Receiving

{
"non_field_errors": [
"The fields location, facility_id must make a unique set."
]
}

If you set some facility_id in the request it's working, also set the facility_id to null after the location was changed

[jeremystretch]

This appears to be related to #17810, in which a bug in DRF fails to recognize that one of the fields required by a uniqueness constraints is null.

[jeremystretch]

Confirmed that the fix for #17810 has also resolved this issue, so I'm going to reclassify it as a duplicate.