Customer experience | Sales, Customer Insights,...

How can I get ShipTo_AddressId from an order? I need to read another address field.

(0) Share

Report

Posted on by Community Member

MSDYN added a field to the customer address for Dual Write. I'm hoping to get it on the client but, ship to address is not a lookkup. It's a composite. I need the ShipTo_AddressId to run a retrieveRecord. Since it is not there, how do I get the customeraddressid or extended data from an order's ship to address using XRM.page/webapi?

TIA

All responses (4)

Answers (0)

Sort by

Charan Raju C R 7 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

If I have correctly understood your requirement, you are trying to fetch 'Ship To Address' on Sales Order form using client side script. You can get this Ship To Composite address field value using either of below two javascript statements.

Xrm.Page.getAttribute("shipto_composite").getValue();

Xrm.WebApi.retrieveRecord("salesorder", salesOrderId, "?$select=shipto_composite").then(
function success(result) {
alert(result.shipto_composite);
},
function (error) {
console.log(error.message);
}
);
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you but, no. shipto addressID is what I'm after. Or the msdyn_locationid. Neither are part of the composite.
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hello,

Have you tried something like:

Xrm.WebApi.retrieveRecord("salesorder", salesOrderId, "?$select=shipto_addressid").then(

function (result) {

alert(result.shipto_addressid);

},

function (error) {

console.log(error.message);

}

);
Community Member on at

Like (1)

Report
Copy link

Link copied!

I ruled that out because I believe it would require a save of the salesorder before it would be accurate -- old or not yet gathered shipto.

In fact I am going to solve my challenge with a plugin because if it has to be on save, why mess with client side junk.