Skip to main content

Notifications

Announcements

No record found.

Business Central forum

How to get item attributes via api.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

We are using cloud Dynamics 365 Business Central and trying to get items with all attributes via OData. 

In Microsoft documentation we found this endpoint:

api.businesscentral.dynamics.com/v1.0[our tenant id]/Sandbox/ODataV4/Company('CRONUS%20DE')/items

But unfortunately, the response does not contain item attributes and values, such as Farbe, Tiefe, etc.

Next, we tried to add new Web Services. But some of this endpoints return empty values and some of them (7506, 7507, 7508, 7510) don't work and return: 

No HTTP resource was found that matches the request URI

Screen-Shot-2019_2D00_05_2D00_29-at-17.11.24.png

Objects 7500, 7501, 7503 contain information about attributes. But non of them (7500 - 7510) does not contain a relation between Item, Attributes, and Values.

Maybe there is another way to get items with their attribute values? We also tried to research microsoft graph but not successful.

Thank you!

  • slashtechllc Profile Picture
    slashtechllc 25 on at
    RE: How to get item attributes via api.

    Nevermind

  • AI123456789 Profile Picture
    AI123456789 129 on at
    RE: How to get item attributes via api.

    I've just found this and it's saved me a lot of pain!  Thank you

  • evka Profile Picture
    evka 5 on at
    RE: How to get item attributes via api.

    Ok. Works great.

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: How to get item attributes via api.

    hi,

    a solution for you ... ready to go!

    Publish as query on Web Services (OData)

    github.com/.../qry50121.ItemAttributeValueMapping.al

    runs great also in Power BI!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,257 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,028 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans