Retrieve value and update in another entity

(0) Share

Report

Posted on by sandeepc

5,494

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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Leah Ju 14,965 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

Was this reply helpful? Yes No
sandeepc 5,494 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?

Was this reply helpful? Yes No

Community site session details

Retrieve value and update in another entity

Helpful resources

Quick Links

Mansi Soni – Community Spotlight

Announcing our 2025 Season 2 Super Users!

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Retrieve value and update in another entity

Helpful resources

Quick Links

Mansi Soni – Community Spotlight

Announcing our 2025 Season 2 Super Users!

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates