How to retrieve Product Master Attributes via API

(0) Share

Report

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

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Leah Ju Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Partner,

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

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

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Michael Hutcheson 131 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 240,045 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Michael Hutcheson 131 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 240,045 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No