Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / How to retrieve Produc...
Finance forum
Answered

How to retrieve Product Master Attributes via API

(0) ShareShare
ReportReport
Posted on by Michael Hutcheson 125
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
 
 
Categories:
Applications and Add-ons
Integration with Other Products
Dynamics 365 Administration
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 228,501 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 125 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 228,501 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 125 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 228,501 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans