How to retrieve Product Master Attributes via API

(0) Share

Report

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

All responses (6)

Answers (2)

Verified answer

Martin Dráb 230,492 Most Valuable Professional on at

Like (1)

Report

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 125 on at

Like (0)

Report

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 230,492 Most Valuable Professional on at

Like (0)

Report

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 125 on at

Like (0)

Report

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 230,492 Most Valuable Professional on at

Like (0)

Report

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

Like (0)

Report

How to retrieve Product Master Attributes via API

Hi Partner,

Could you tell me what app you are using in Dynamics 365?