Cannot get Item ID from Odata service or Business central V2.0 API

(0) Share

Report

Posted on by M.Barimah

Hello Community,

I am trying to get a list of all the items with their respective id's under a specific company, stored in business central.

I tried to use the ODATA API in the following way

https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environmentName}/ODataV4/Company('{companyName}')/Items

were Items is a Odata service expose through the business central web service configuration targeting object 32

The service works, but I am not able to see the internal ID.

I also tried to switch to the business central v2.0 API and try to get the items that I need by doing the following:

https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environmentName}/api/v2.0/companies({companyId})/Items

but this seems not to be a valid operation because I receive the following error

7776.code.png

How do I get a list of Company Items with their respective Id's?

I have the same question (0)

All responses (5)

Answers (1)

M.Barimah 60 on at

Like (0)

Report

RE: Cannot get Item ID from Odata service or Business central V2.0 API

Hello Zhu,

Thank you for the post, it pointed me to the right direction. Really nice interesting article by the way. At the end I realized that I was doing a rookie mistake. The business central api was expecting "items" instead of "Items", after the change it worked perfectly.

Thanks

Was this reply helpful? Yes No
Verified answer

YUN ZHU 92,443 Super User 2025 Season 2 on at

Like (0)

Report

RE: Cannot get Item ID from Odata service or Business central V2.0 API

Hi, you can use standard APIs.

For example: api.businesscentral.dynamics.com/.../items

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

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Rob F. 487 on at

Like (0)

Report

RE: Cannot get Item ID from Odata service or Business central V2.0 API

Hi, to use the standard API try using "Item" instead of "Items" in your string.

api.businesscentral.dynamics.com/.../Item

item resource type - Business Central | Microsoft Docs

Rob

Was this reply helpful? Yes No
M.Barimah 60 on at

Like (0)

Report

RE: Cannot get Item ID from Odata service or Business central V2.0 API

Hello Akshay,

Thanks for your answer,

do you mean that I need to create a page extension in AL and then add the GUID to the page? I was under the impression that the OData service should return the GUID out of the box without me creating an extension, is this wrong?

Was this reply helpful? Yes No
Suggested answer

Akshay_Panchal 402 on at

Like (0)

Report

RE: Cannot get Item ID from Odata service or Business central V2.0 API

Hii,

You have create new field with datatype GUID. system allocate unique GUID for each record.that way you can get the specific item using GUID.

Thanks.

Verify, If this answer is helpful to you.

Was this reply helpful? Yes No