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 :
Business Central forum

API: Unable to get all Journal Line Items via GET command (Business Central 365)

(0) ShareShare
ReportReport
Posted on by 5

Hi,

Does anyone here have experience with the Business Central 365 API?

We are trying to code up some integration with our software and Business Central and mainly at this stage we're just trying to get the Journal Line Items but every time we get do the GET command we only get the lines where the "ACCOUNT TYPE" equals "G/L Account".

So for example, we can have 2x line items in a Journal, both set with the "Account Type" of "G/L Account", we then do a GET command on it
api.businesscentral.dynamics.com/.../{{env_id}}/api/v1.0/companies({{companyid}})/journals({{Journal_ID}})/journalLines()
We get 2x line items back as we would expect.
However, if we were to change one of those lines to have the "Account Type" as "Bank Account" and then run the same API command we only get 1x line item.

I'm not completely sure if it's just me, if I'm using the wrong command or if the API simply doesn't do what we need it to do but any help or point in the right direction would be great.

Or if anyone knows who we can contact at Microsoft to see if they know the answer themselves that would also be great.

pastedimage1569897167195v1.png

Categories:

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans