Retrieve value and update in another entity

(0) Share

Report

Posted on by sandeepc

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)

sandeepc on at

Like (0)

Report
Copy link

Link copied!

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
Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation

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