Retrieve value and update in another entity

(0) Share

Report

Posted on by sandeepc

5,514

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 5,514 on at

Like (0)

Report

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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates