Small and medium business | Business Central, N...

Is it possible to configure Items table as a web service in Business Central?

(0) Share

Report

Posted on by Mery12

I am trying to configure Items table (as a whole as a web service) because I want to get all the columns that this table exposes at one time. But only "Pages" of this table can be configured which means that I will be able to get only a few columns when configuring for instance "Item Card " page as a web service. Is there any way I can get the Items table at once?

Note: I am using inspect tool and there are a lot of columns that have being exposed for the Item table. Ans I want to get all the columns that I see on Inspect tool

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

You can build a custom api and include all the fields you want.

learn.microsoft.com/.../devenv-develop-custom-api

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, You have two ways.
1. Create a page with all the columns, and then publish it in the Web Service and use Odata to access it.
2. Create a new API page.
The second method is more efficient.

PS: The API page type cannot be extended by creating a page extension object. If you use the standard API, you can only get limited columns.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-api-pagetype

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Mery12 11 on at

Like (0)

Report

Thank you for your reply.

But I have noticed that if we consider the Item table as a "parent", the columns of this table are distributed between different entities that can be configured as web services. For instance: some of the columns of Item table can be found in Item Card entity, some others in ItemSalesAndProfit. How does the system do this distribution of fields between child entities for a table? How does this work?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

If you look at the standard API for Items then you can see that you can navigate through the API down to the related tables.

That is how it is normally done in Business Central.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/resources/dynamics_item

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, you can also just use $expand method.

More details: https://yzhums.com/6117/#toc13

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Mohd Anas 42 on at

Like (0)

Report

Yes, you can.

create a page with all the fields and publish it as page web services and use the odata4 web services link to get all of them OR Go with the API page and add all the fields which you want.

Was this reply helpful? Yes No
DAnny3211 11,397 on at

Like (0)

Report

hi

you should create a new page with all the info you need and expose it as a web service

DAniele

Was this reply helpful? Yes No