Hi,
I'm using Scribe Online to create items from an external source but need to add attributes to some items using Odata. I'm struggling to work out how to create the attribute and link it to the item. How do attributes get related to the item?
Has anyone experience of this?
You can expose these entities in a sandbox instance having version 18500+ and Company Info | User Experience : Advanced
Hi Stuart,
I answered another almost-identical inquiry, with the exception that the other person wasn't using Scribe or any tool. They were curious to know if it was possible to do a mass import of Item Attribute information for Items. Here is a link below to that thread, and my response to them:
community.dynamics.com/.../256538
The short answer: There is no way of mass uploading Item Attributes and Item Attribute Values for Items into Dynamics 365 at this time.
Here is some explanation of how the system holds this data in the background:
To be able to import data into Dynamics 365 for Financials at this time, we must either find the table in the RapidStart Configuration Package area, or there must be an Edit in Excel option on the page. Or at least, there must me a Page associated with the table that we can publish using a Web Service (and then use a tool to publish data into Dynamics 365). None of these exist at this time for the Item Attribute functionality.
The way Item Attributes are related to Items is complex, and Microsoft has not exposed the requisite pages for us to be able to directly upload data to them.
Your Item records are stored in the Item table, and the item attributes (Color, Depth, Width, Size, Package, Brands, etc.) are stored in a table called Item Attribute (Table ID 7500).
The actual values of these attributes (i.e., the various values for Size, the various types of Packages, Colors, Brands, etc. are stored in yet another table called Item Attribute Value (Table ID 7501).
And finally, Microsoft Dynamics 365 stores which Items have which Item Attributes and Item Attribute Values in a table called Item Attribute Value Mapping (Table ID 7505).
I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"
#1
André Arnaud de Cal...
291,642
Super User 2024 Season 2
#2
Martin Dráb
230,371
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
