Balance Sheet API Date filter wrong format

(1) Share

Report

Posted on by CU07100202-0

118

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!

I have the same question (0)

All responses (4)

Answers (0)

Sort by

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

Like (0)

Report
Copy link

Link copied!

Hi

Technically speaking I see that the treatment of the datefilter field is different.

Try using eq.

Dynamics Community Forum Thread Details

I hope it helps you.

BR

GR

Was this reply helpful? Yes No
CU07100202-0 118 on at

Like (0)

Report
Copy link

Link copied!

Thank yougdrenteria but I needed a date range that is why im using ge and le

Was this reply helpful? Yes No
CU07100202-0 118 on at

Like (0)

Report
Copy link

Link copied!

gdrenteria can you share please where I can download the source code from your screenshot? Thanks in advance!

Was this reply helpful? Yes No
Dynamics_Decoded_Gokul 487 on at

Like (0)

Report
Copy link

Link copied!

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>>

Was this reply helpful? Yes No