Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to retrieve Produc...
Finance | Project Operations, Human Resources, ...
Answered

How to retrieve Product Master Attributes via API

(0) ShareShare
ReportReport
Posted on by Michael Hutcheson 131
Hello,
 
How do I retrieve Product Master Attribute data via a GET request?
 
For example to retrieve the Product Master I would use the below:
 
GET: {{resource}}/data/ProductMasters?$filter=ProductNumber eq '001234'&cross-company=true
 
And for the related size dimension info I would use;
 
GET: {{resource}}/data/ProductMasterSizes?$filter=ProductMasterNumber eq '001234'&cross-company=true
 
How do I retrieve the Product Attribute info?  I've tried the below to no avail;
 
{{resource}}/data/ProductAttributeV2?cross-company=true
{{resource}}/data/ProductAttribute?cross-company=true
{{resource}}/data/ProductMasterAttributes?cross-company=true
{{resource}}/data/ProductMasterAttribute?cross-company=true
 
 
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 231,409 Most Valuable Professional on at
    How to retrieve Product Master Attributes via API
    I used the same filter in Application Explorer: type:dataentity product.*attr. Then I chose this entity by name (ProductAttributeValue sounded like it could be the right one) and then reviewed its developer documentation and fields to verify that.
  • Michael Hutcheson Profile Picture
    Michael Hutcheson 131 on at
    How to retrieve Product Master Attributes via API
    That has answered my question - thank you.
     
    Apologies, I should have stated the exact requirements going forward.
     
    I'm quite new to D365 - how did you locate the name of that entity?  Is there something I could be doing going forward?
     
    Thanks again for your help.
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 231,409 Most Valuable Professional on at
    How to retrieve Product Master Attributes via API
    We would have all saved time if you stated your actual requirements at the beginning.
     
    I believe the entity you want now is EcoResProductAttributeValueV3Entity. Its public collection name is ProductAttributeValuesV3.
  • Michael Hutcheson Profile Picture
    Michael Hutcheson 131 on at
    How to retrieve Product Master Attributes via API
    Hello,
     
    Thank you for your help.
     
    Performing a GET on /data/ProductAttributes?cross-company=true will give me a list of the actual attributes. 
     
    The end game though is to actually update the attributes for each product.
     
    E.g. I will need to POST:
     
    Product Number \ Attribute Type Name \ Attribute Name \ Text Value
     
    But what do I need to post?
     
    For example to POST released products I use:
     
    /data/ReleasedProductVariantsV2
     
    and enter the details in the body.  I need something similar for the attributes but cannot seem to locate it?
     
  • Martin Dráb Profile Picture
    Martin Dráb 231,409 Most Valuable Professional on at
    How to retrieve Product Master Attributes via API
    Moved from D365 general forum to the Finance forum, because it's clearly about F&O and not about D365 in general.
     
    The first step is finding the entity to use, instead of trying random URLs. There are several options. For example, you can open {{resource}}/data to see the list of OData entities. Or you can use Find references in Visual Studio to find the entities using a particular table and then look at Public Collection Property.

    If you mean EcoResAttribute table, the entity you want is likely EcoResProductAttributeEntity (I found it by filtering AOT by type:dataentity product.*attr) and the public colllection name is ProductAttributes.
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    How to retrieve Product Master Attributes via API
    Hi Partner,
    Could you tell me what app you are using in Dynamics 365?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans