web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Issue with Exporting BC Data via API

(0) ShareShare
ReportReport
Posted on by 43
Hello ,

Background

I have set up 35 API pages to expose BC data to third-party systems.

Tests with Postman

During the testing phase using the Postman tool, 34 API pages worked correctly. However, there is one exception: the page does not work for the "G/L Account" .

Web Services Behavior

When the "G/L Account" resource is declared as a Web Service, the SOAP call executes without any issues. However, this proper functioning is not observed with the API call.
Using SOAP is not solution because it ‘will be removed version 29
Any Idea of resolution of Issue?
Thanks
Screenshot 2026-05-07 102925.jpg
I have the same question (0)
  • Suggested answer
    Teagen Boll Profile Picture
    2,158 Super User 2026 Season 1 on at
    Microsoft is deprecating SOAP this year, see below:
     
    They recommend adding the source code to a tenant extension instead. You will only be able to use OData V4 going forward.
     
    Best,
    Teagen Boll
    Social: LinkedIn
  • Verified answer
    Mounir M Profile Picture
    43 on at
     Thanks, Thanks, I resolved the issue. Some app registration permissions were missing; add definition field in API Page:
       field(accountCategory; GetAccountCategoryAsText)            {
                        Caption = 'Account Category';
                    }
        trigger OnAfterGetRecord()
        begin
            GetAccountCategoryAsText := GetAccountCategoryDisplayName(Rec."Account Category");
        end;
        var
            GetAccountCategoryAsText: Text;

        local procedure GetAccountCategoryDisplayName(accountCategory: Enum "G/L Account Category"): Text
        begin
            case accountCategory of
                accountCategory::" ":
                    exit('');
                accountCategory::Assets:
                    exit('Assets');
                accountCategory::Liabilities:
                    exit('Liabilities');
                accountCategory::Equity:
                    exit('Equity');
                accountCategory::Income:
                    exit('Income');
                accountCategory::"Cost of Goods Sold":
                    exit('Cost of Goods Sold');
                accountCategory::Expense:
                    exit('Expense');
            end;
            exit('');
        end;
    Thanks 
     
     
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,957 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 956 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 645 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans