How to retrieve 'owneridtype' or 'cutomeridtype' field of a record using web api?

(0) Share

Report

Posted on by Waldner

I try to find the referenced record of a table. 'ownerid' and 'customerid' are multiple targets lookup attributes, I want to find out which table those fields are referenced to. Looks like 'owneridtyp' and 'cutomeridtype' could give me the information I need, but those 2 fields are not retrievable. How can I find out which target table the record referenced to in this case? I need this through web API.

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report
Copy link

Link copied!

if you are using the Web API endpoint add the formatted values (the request header for it)

and you will see an additional property "logicalname" for the lookup fields telling you the logical name of the table the record is pointing to, for example for ownerid (_ownerid_value) will tell you if is a systemuser or a team record

Was this reply helpful? Yes No
Verified answer

meelamri 13,218 User Group Leader on at

Like (1)

Report
Copy link

Link copied!
Hi,

Record owners:

Xrm.WebApi.retrieveRecord("account", "d8862a8c-90fe-eb11-94ef-002248800dd0", "?$select=name,_ownerid_value") .then(function(result) { var account = { "accountname": result["name"], "ownerid" : result["_ownerid_value"], "owneridtype" : result["_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname"] } console.log(account); })

The Customer field:

Xrm.WebApi.retrieveRecord("opportunity", "1d2e438e-1621-4b0e-ae9a-529e06b16d0e") .then(function(result) { var opportunity = { "opportunityName": result["name"], "customerid" : result["_customerid_value"], "customeridname": result["_customerid_value@OData.Community.Display.V1.FormattedValue"], "customeridtype": result["_customerid_value@Microsoft.Dynamics.CRM.lookuplogicalname"] } console.log(opportunity); })

Was this reply helpful? Yes No