AL API page that returns customer details as well as that customer's default dimensions

(3) Share

Report

Posted on by JB-20031303-0

I am creating essentially an extension of the default get customer endpoint, but need to return dimensions as part of the /customers endpoint, so part() won't work for me. I presume I need to do something along the lines of this:

var
Dimensions: Text;
trigger OnAfterGetRecord()
var
TDimensions: Record "Default Dimension";
begin
TDimensions.Reset();
TDimensions.Get();
Dimensions := TDimensions."Dimension Code";
end;

But obviously need to pass in some "query" stuff to specify what data I want, but not really sure how. Any help is much appreciated.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Why you don't want to create part for dimensions filter for Table ID and No. for that customer to view Default Dimensions.

Was this reply helpful? Yes No
JB-20031303-0 31 on at

Like (0)

Report

I'm creating an integration layer between an internal system and business central, and need a single api endpoint to pull customer data and default dimensions, multiple requests is possible but adds a lot of complexity

Was this reply helpful? Yes No
Verified answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report
Hi,

You can try below code:

trigger OnAfterGetRecord() var DefaultDimension: Record "Default Dimension"; DimensionText: Text; begin // Clear the Dimensions variable for each customer record Dimensions := ''; // Filter Default Dimension records for the current customer DefaultDimension.Reset(); DefaultDimension.SetRange("Table ID", Database::Customer); // Table ID for Customer table DefaultDimension.SetRange("No.", Rec."No."); // Filter by the current customer's No. // Loop through all dimensions for the customer if DefaultDimension.FindSet() then begin repeat // Append each dimension code to the text (e.g., "DEPARTMENT,PROJECT") if DimensionText = '' then DimensionText := DefaultDimension."Dimension Code" else DimensionText := DimensionText + ',' + DefaultDimension."Dimension Code"; until DefaultDimension.Next() = 0; end; // Assign the concatenated dimension codes to the Dimensions field Dimensions := DimensionText; end;

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hi, This functionality is available in the standard API.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/resources/dynamics_customer?wt.mc_id=DX-MVP-5004336

But if you don't want to use it, another way to consider is to add the Default Dimension as a real field in the Customer table (Add the dimension you need to display), so that you process the data when setting the Default Dimension and do not do any processing when the API obtains it.

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No