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

I have the same question (0)

All responses (4)

Answers (0)

Community Member 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.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 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);

}

);

Was this reply helpful? Yes No
Community Member 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.

Was this reply helpful? Yes No
Charan Raju C R 7 Moderator 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);
}
);

Was this reply helpful? Yes No