How to patch product attributes via API

(1) Share

Report

Posted on by Michael Hutcheson

131

Hi,

I'm using D365 F & O and would like to update Product Attributes values via an API - I'm currently testing in Postman.

I only need to update the TextValue and BooleanValue of the actual Product Attributes - the AttributeTypeName and AttributeName already exist.

PATCH: /data/ProductAttributeValuesV3(ProductNumber='001234')

In the body I specify:

{

/AttributeTypeName/: /Brand/,

/AttributeName/: /Brand/,

/BooleanValue/: /No/,

/TextValue/: /Test/

}

But I keep receiving a 401 // not found:

{

/Message/: /No HTTP resource was found that matches the request URI 'https://xxxxxxxxx/data/ProductAttributeValueV3(ProductNumber='001234')'. No route data was found for this request./

}

How do I update the text value // boolean value?

All responses (3)

Answers (1)

Sort by

Martin Dráb 241,417 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The problem seems to be in /data/ProductAttributeValueV3(ProductNumber='001234'). The product number alone is not sufficient for finding an individual product attribute value. Use all fields of the entity key.
Michael Hutcheson 131 on at

Like (0)

Report
Copy link

Link copied!

I still get the 404 not found:

PATCH:

"Message": "No HTTP resource was found that matches the request URI 'https:XXXXXXXXXX/data/ProductAttributeValuesV3(ProductNumber='001234',AttributeTypeName = 'Brand',AttributeName = 'Brand',BooleanValue = 'No',TextValue = 'tEST123' )'. No route data was found for this request."
Verified answer

Michael Hutcheson 131 on at

Like (1)

Report
Copy link

Link copied!

Its working - the keys are Product Number \ AttributeTypeName \ AttributeName

If we pass those in the URL:

patch:

/data/ProductAttributeValuesV3(ProductNumber='001213',AttributeTypeName = 'Brand',AttributeName = 'Brand')

Then the values we want to update in the Body:

{

"BooleanValue": "No",

"TextValue": "Test"

}

This will update D365 F&O.

Not sure if this will help anyone wanting to update the Product Attributes via REST