Does anyone know of a simple JavaScript to copy a text field from a related entity to the current page?
I need to copy the Product ID field to the Opportunity Product when populating the Existing Product field on an Opportunity Product.
*This post is locked for comments
Hi Graeme,
Here is sample API with complete function-
Share
Report
All responses (
Answers (
function GetProductId()
{
var productiID ="DCCE5294-9447-E711-8104-5065F38A4A21"; //GUID Of the product
var req = new XMLHttpRequest();
req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/products(" + productiID + ")?$select=name,_pricelevelid_value,productid", 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 === 200) {
var result = JSON.parse(this.response);
var name = result["name"];
var _pricelevelid_value = result["_pricelevelid_value"];
var _pricelevelid_value_formatted = result["_pricelevelid_value@OData.Community.Display.V1.FormattedValue"];
var _pricelevelid_value_lookuplogicalname = result["_pricelevelid_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
var productid = result["productid"];
// Set the value
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();
}
Thanks, however how do i put this in a function?
Hello Graeme,
Try with this -
var req = new XMLHttpRequest();
req.open("GET", Xrm.Page.context.getClientUrl() + "/api/data/v8.2/products(DCCE5294-9447-E711-8104-5065F38A4A21)?$select=name,_pricelevelid_value,productid", 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 === 200) {
var result = JSON.parse(this.response);
var name = result["name"];
var _pricelevelid_value = result["_pricelevelid_value"];
var _pricelevelid_value_formatted = result["_pricelevelid_value@OData.Community.Display.V1.FormattedValue"];
var _pricelevelid_value_lookuplogicalname = result["_pricelevelid_value@Microsoft.Dynamics.CRM.lookuplogicalname"];
var productid = result["productid"];
} else {
Xrm.Utility.alertDialog(this.statusText);
}
}
};
req.send();
Hello Graeme ,
Download the rest builder which will be easy to create the rest API to get the product id. Also you can find sample code from here -
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
