Business Central API question

(0) Share

Report

Posted on by aksmith

I'm looking for some assistance with the Business Central API. Currently I'm making calls to BC using the api v2.0 https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/ which is working well but I'm now trying to get the posted creditor and debtor transaction data. On the debtor side I want the data from the 'Cust. Ledger Entry' table but there is no api endpoint for that table. (Nor the creditor side)

Have anyone got any idea how to query this data from the api?

All responses (3)

Answers (1)

Suggested answer

aksmith 30 on at

Like (0)

Report

RE: Business Central API question

Thanks for your help - I have had a look through the OData V4 web services and I can get the data I required
Verified answer

YUN ZHU 75,673 Super User 2024 Season 2 on at

Like (1)

Report

RE: Business Central API question

Hi, for 'Cust. Ledger Entry', there is a standard OData V4 URL in BC. You can try this first.

For example: https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Sandbox02/ODataV4/Company('My%20Company')/Cust_LedgerEntries

If it's not available, as Igne said, you need to customize the new API.

Hope this will help.

Thanks.

ZHU
Suggested answer

Inge M. Bruvik 993 Super User 2024 Season 1 on at

Like (1)

Report

RE: Business Central API question

There is no standard API avalible for the Custom Ledger Entries or the Vendor Ledger entries.

So you would either have to use the Odata V4 webservice or create a custom API.

Best practice these days is to create a custom API for this.

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