Dynamics Community Forum Thread Details

What filter values to use when calling G/L Balance by Dimension over OData on Business Central OnPrem

I'm trying to get general ledger data by dimension using the OData interface on an OnPrem BC instance.

I've published page 408 "G/L Balance by Dimension" as a web service called GL_Balance_by_Dimension.

I'm using the REST client extension in VSCode to execute my call with the relevant url, tenant and company parameters filled in:

@rows = 'G/L Account'
@cols = 'Period'
GET https://{{url}}:18143/{{tenant}}/ODataV4/Company({{company}})/GL_Balance_by_Dimension?$filter=LineDimCode eq {{rows}} and ColumnDimCode eq {{cols}} HTTP/1.1
Authorization: Basic {{user}} {{wak}}
Content-Type: application/json

{
}

I only ever get an empty array returned:

HTTP/1.1 200 OK
Transfer-Encoding: chunked
Content-Type: application/json; odata.metadata=minimal
Content-Encoding: gzip
Server: Microsoft-HTTPAPI/2.0
OData-Version: 4.0
Access-Control-Allow-Origin: *
Access-Control-Allow-Credentials: true
Access-Control-Expose-Headers: Date, Content-Length, Server, OData-Version
request-id: 2b81c6fb-bc03-42f1-bee6-b77c1fb9229c
Date: Wed, 14 Dec 2022 11:47:47 GMT
Connection: close

{
"@odata.context": "https://*url*:18143/*tenant*/ODataV4/$metadata#Company(*company*)/GL_Balance_by_Dimension",
"value": []
}

I've tried to pass in more of the properties and filters specified in the metadata without a change in the results.

I suspect that the values I use in the LineDimCode and ColumnDimCode property filters are incorrect but I can't find what other values I can use. These are values that work if I run the page in GUI.

BTW - To verify my approach I have tried setting up, calling and filtering Chart_of_Accounts - that works as expected.

Where can I find the correct values for the properties in the $filter to use when executing a call to GL_Balance_by_Dimension?

Many thanks

Thorbjorn

Quick Links

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