Unanswered

Dataverse API PATCH lookup column

(0) Share

Report

Posted on by kunald_gmeet

I want to use PATCH API of Dataverse to update lookup column. I am getting 200 OK response but the lookup column value not getting updated. Here is the sample request:

URL: {{dataverse_url}}/Employees(7af4aca9-734c-ed11-bba2-0022489935a6)/Country

BODY:

{
"@odata.countryid":"{{dataverse_url}}/countries(c8046381-6c4c-ed11-bba2-0022489935a6)"
}

* {{dataverse_url}} -> your dataverse url
* Country is lookup column in Employees table
* Countries is table used in lookup
* countryid is unique identifier

Thanks,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Fubar 8,365 Super User 2025 Season 2 on at

Like (0)

Report
Main issue is probably the format of the bind - if you were doing it via XMLHTTP it would something more like ... (below updates a contact Lookup on the account table)
var entity = {}; entity["new_secondarycontact@odata.bind"] = "/contacts(95bd7961-e7f8-ea11-a815-000d3a799a0d)"; var req = new XMLHttpRequest(); req.open("PATCH", Xrm.Page.context.getClientUrl() + "/api/data/v9.1/accounts(95bd7961-e7f8-ea11-a815-000d3a799a77)", true); req.setRequestHeader("OData-MaxVersion", "4.0"); req.setRequestHeader("OData-Version", "4.0"); req.setRequestHeader("Accept", "application/json"); req.setRequestHeader("Content-Type", "application/json; charset=utf-8"); req.setRequestHeader("Prefer", "odata.include-annotations=\"*\""); req.onreadystatechange = function() { if (this.readyState === 4) { req.onreadystatechange = null; if (this.status === 204) { //Success - No Return Data - Do Something } else { // error } } }; req.send(JSON.stringify(entity));

Was this reply helpful? Yes No
Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

the name of lookup fields is not always the logical name, you can use my tool Dataverse REST Builder to find the exact syntax for your environment.

Was this reply helpful? Yes No
kunald_gmeet 22 on at

Like (0)

Report

@Fubar - It's working properly for updating other columns, only problem i am facing is with lookup column. trying to do this using POSTMAN and not using XMLHTTP.

Thanks,
KD

Was this reply helpful? Yes No
Fubar 8,365 Super User 2025 Season 2 on at

Like (0)

Report

Provided example so you could see that the Structure of your query, the bind in particular, is not correct for a Lookup (is different to normal text fields etc). you need to change the "@OData.countryid" keyword.

Was this reply helpful? Yes No
kunald_gmeet 22 on at

Like (0)

Report

Ok, can you please help with correct syntax for a lookup field PATCH ? I am using the one I shared.

Was this reply helpful? Yes No