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

How to create a GET API using Code unit.

(1) Share

Report

Posted on by SG-05091051-0

163

Hi All,

I am using On-Prem Business Central.

I have created the below code unit to get the sales price, and i have created web service of this code unit also.
now i am trying to call it from POST MAN with post type post, but i am getting error.

Does anyone have any idea about this. Please let me know.

codeunit 50102 "GetItemPrice"
{
    Permissions = tabledata "Price List Line" = rimd;
    [ServiceEnabled]
    procedure GetPrice(ItemNo: Text[50]; CustomerNo: Text[50]): Decimal
    var
        PriceListLine: Record "Price List Line";
    begin
        // Set a filter on "Item No." using the provided ItemCode (AssetNo in your case)
        PriceListLine.SetRange("Asset No.", ItemNo);
        PriceListLine.SetRange("Source No.", CustomerNo);
        // Check if there is a matching Price List Line and return the Price List Code
        if PriceListLine.FindFirst() then
            exit(PriceListLine."Unit Price")
        else
            exit(0); // Return empty if no matching record is found
    end;
}

Error : 400

{
    "error": {
        "code": "BadRequest",
        "message": "Exception of type 'Microsoft.Dynamics.Nav.Service.OData.NavODataBadRequestException' was thrown.  CorrelationId:  6a4a5157-5d90-4ab4-8ebd-fa4713f63e1f."
    }
}

Payload :

{
    "ItemNo": "111",
    "CustomerNo": "122"
}

Header included all the If Match, Content Type and company id also. but same error.

Thanks for your Help.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ramiz 597 on at

Like (1)

Report

Hi,

I created the same and its working fine. Kindly check the url.

https://api.businesscentral.dynamics.com/v2.0/TenantID/EnvironmentName/ODataV4/MyCode_GetPrice?company={companyId or Name}

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-creating-and-interacting-with-odatav4-unbound-action

https://www.kauffmann.nl/2020/03/05/codeunit-apis-in-business-central/

Was this reply helpful? Yes No
Suggested answer

Sami Ullah 315 Moderator on at

Like (1)

Report
Hi,

Example Codeunit:
codeunit 50100 "SalesOrderProcessing" { Permissions = tabledata "Sales Header" = rimd; procedure UpdateSalesOrderStatus(orderno: Text[50]; status: Text[50]): Text var SalesOrder: Record "Sales Header"; begin SalesOrder.Reset(); SalesOrder.SetRange("Document Type", "Sales Document Type"::Order); SalesOrder.SetRange("No.", orderno); if SalesOrder.FindFirst() then begin case status of 'Open': SalesOrder.Status := SalesOrder.Status::Open; 'Released': SalesOrder.Status := SalesOrder.Status::Released; end; SalesOrder.Modify(true); end else exit('Sales Order not found.'); end; }

Example HTTP API Call:
POST /v2.0/{your tenantID}/Production/ODataV4/SalesOrderProcessing_UpdateSalesOrderStatus Host: api.businesscentral.dynamics.com Content-Type: application/json If-Match: * company: 2006d1d5-1a4e-ef11-bfe7-6045bde9c989 // your company ID Authorization: Bearer {Provide Token} { "orderno": "S-ORD101001", "status": "Released" }

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hi, hope the following helps as well.

Dynamics 365 Business Central: How to use Standard/Custom API Bound Actions

https://yzhums.com/39196/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 25,268 Most Valuable Professional on at

Like (2)

Report

Hi

I hope this can help you:

Codeunit API’s in Business Central – Kauffmann @ Dynamics 365 Business Central

ODATA action bound parametrs issue (dynamics.com)

Best

GR

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,604 Super User 2025 Season 2 on at

Like (2)

Report

Ensure that your request URL is correctly formatted and that you’re using the right HTTP method. You might also want to double-check the payload structure and confirm that the web service is published properly.

Was this reply helpful? Yes No