Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Odata - Item Attributes

Posted on by

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?

Categories:
  • Suggested answer
    joshbooker Profile Picture
    joshbooker on at
    RE: Odata - Item Attributes

    You can expose these entities in a sandbox instance having version 18500+ and Company Info | User Experience : Advanced

  • StuartLaw Profile Picture
    StuartLaw on at
    RE: Odata - Item Attributes

    Thanks for the response on this. I came to that conclusion in the end. Hopefully they will address this eventually with the new api.

  • Verified answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Odata - Item Attributes

    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?"

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans