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

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)

Community Member Microsoft Employee on at

Like (1)

Report

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

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.
Suggested answer

a33ik 84,325 Most Valuable Professional on at

Like (1)

Report

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

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 Microsoft Employee on at

Like (0)

Report

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

Thank you but, no. shipto addressID is what I'm after. Or the msdyn_locationid. Neither are part of the composite.
Charan Raju C R 3,155 Super User 2024 Season 1 on at

Like (0)

Report

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

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);
}
);