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)

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

Like (0)

Report

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

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

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 463 on at

Like (0)

Report

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