Skip to main content

Notifications

Announcements

No record found.

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

Balance Sheet API Date filter wrong format

(1) ShareShare
ReportReport
Posted on by 84
Hi,
 
I'm trying to call the Balance Sheet API but i'm receiving a invalid date format error (see screenshot). However, using the same filter, I can call the Income Statement API  (see 2nd screenshot) without an error. Do Balance Sheet API needs a different date format? Thank you in advance!
 
 
  • Tech_BC_Gokul Profile Picture
    Tech_BC_Gokul 331 on at
    Balance Sheet API Date filter wrong format
    Hi 
     
    could you please check this way 

    The API quite happily returns results if you encode spaces with "%20" or "+" (even within the OData filter).
     
     
    Example 
    <<documentDate%20le%2024-07-31>>
  • AS-05060801-0 Profile Picture
    AS-05060801-0 84 on at
    Balance Sheet API Date filter wrong format
    gdrenteria can you share please where I can download the source code from your screenshot? Thanks in advance!
  • AS-05060801-0 Profile Picture
    AS-05060801-0 84 on at
    Balance Sheet API Date filter wrong format
    Thank yougdrenteria but I needed a date range that is why im using ge and le
  • gdrenteria Profile Picture
    gdrenteria 14,028 Most Valuable Professional on at
    Balance Sheet API Date filter wrong format
    Hi
    Technically speaking I see that the treatment of the datefilter field is different.
    Try using eq.
     
    I hope it helps you.
    BR
    GR

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans