Retrieve value and update in another entity

(0) Share

Report

Posted on by sandeepc

5,476

Hi Team,

I have a requirement to retrieve a exchane rate value from currency entity and update that value in opportunity entity.

using xrm.web.api.retrieve multiple

how can i achieve this ??? any links or steps will be helpful

Thanks

Sandeep

All responses (2)

Answers (1)

Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Retrieve value and update in another entity

Hi Partner,

Based on your description and code, you have decided to use exchange rate of eruo, Right?

Why not use it's guid to retrieve it directly?

Example Code:

function getEuroExchangeRate(executionContext) { var formContext = executionContext.getFormContext(); //Retrieve record Xrm.WebApi.retrieveRecord("transactioncurrency", "e97e1a46-4e59-e811-8148-000d3a06499e", "?$select=exchangerate").then( function success(result) { console.log(result); // Columns var transactioncurrencyid = result["transactioncurrencyid"]; // Guid var exchangerate = result["exchangerate"]; // Decimal var exchangerate_formatted = result["exchangerate@OData.Community.Display.V1.FormattedValue"]; //update field formContext.getAttribute("abc_euroexchangerate").setValue(exchangerate);//abc_euroexchangerate should be logic name of the field }, function (error) { console.log(error.message); } ); }

Note:

This tool--Dataverse REST Builder, it can help you build code easily:

GitHub - GuidoPreite/DRB: Dataverse REST Builder

I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
Regards,
Leah
sandeepc 5,476 on at

Like (0)

Report

Retrieve value and update in another entity

function getEuroExchangeRate(executionContext) {
var formContext= executionContext.getformContext();
try {
var results = Xrm.WebApi.retrievemultiplerecords("currency", "?$select=exchangerate&$filter=name eq '" + euro + "'");
// Xrm.WebApi.retrieveRecord(entityLogicalName, id, options).then(successCallback, errorCallback);
if (results.entities.length > 0) {
var result = results.entities[0];
// exchangerate = result["exchangerate"];
formContext.getAttribute("abc_euroexchangerate").setValue("result["exchangerate"]");
}
}
catch (error) {
console.error(error.message);
return exchangerate;
}
}

is this correct?