Finance | Project Operations, Human Resources, ...

Exporting all the address for a customer

(0) Share

Report

Posted on by Dev

451

Hi All,

I have a scenario where I need to export all the primary/non primary address for all the customers.

What will be the best approach to handle this as a single customer will have multiple address and those need to be sent as a single record for a customer and so on.

Thanks !

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi AX Dev,

You can use the data entity CustomerPostalAddressEntity ("Customer postal addresses") to export addresses of all customers

Was this reply helpful? Yes No
Dev 451 on at

Like (0)

Report

Hi ,

I need to export the address along with customer details.

For example for customer A I need to export a single record with customer details like accountNum, name and all the addresses.

Thanks

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

You could create a custom entity based on on CustomerPostalAddressEntity and add the fields you need from Customers. This way you will have multiple rows (based on customer addresses) with the same customer details.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

This is not possible with the standard entities. You need to export the addresses via the customer postal address entity. The customer can have 0-n addresses and it's not possible to present such information properly in "single record". That's why the addresses are stored in a separate table and not in the customer table. And that's why there are two separate entities.

But if you have a strong definition of how that "single record" result would look like, then you can easily extend the customer entity and add the addresses there.

Was this reply helpful? Yes No
Martin Dráb 237,892 Most Valuable Professional on at

Like (0)

Report

We can't understand your requirement until you explain what you mean by "a record".

If you mean a single file, you can create a composite entity including both customers and their addresses.

Was this reply helpful? Yes No
Dev 451 on at

Like (0)

Report

Hi,

I need to create a file where we have customer details and then all its address without repeating customer data.

I tried creating composite entity with custcustomerv3 and CustomerPostalAddressEntity but I guess that is not possible to set relation on the CustomerPostalAddressEntity entity.

Was this reply helpful? Yes No
Martin Dráb 237,892 Most Valuable Professional on at

Like (0)

Report

Making such a composite entity is possible - I did it for one of my clients.

But you'll need some changes, such as adding RowId and ParentRowId fields to staging tables. Refer to Develop composite data entities for more information.

Was this reply helpful? Yes No