Forum Stats

  • 3,780,784 Users
  • 2,254,438 Discussions
  • 7,879,452 Comments

Discussions

OSC Rest Api date fitlering

3296962
3296962 Member Posts: 1

Hello all,

I'm trying to filter the  crmCommonApi/resources/latest/accounts resource but it keeps failing.

The filter im trying to build is a date range.

Based on this document https://docs.oracle.com/cloud/latest/salescs_gs/FAAPS/Resource_Actions.html  the filter should look like : q=deptno>=10 and <= 30;

Related to my case , this filter should look like this : q=LastUpdateDate>2016-01-01 and < 2016-01-12 , and encoded it should be like this q=LastUpdateDate%3E2016-01-01%20and%20%3C%202016-01-12 .

The issue is that i keeps failing and returning this error : java.lang.NullPointerExceptionAn instance of type class java.sql.Timestamp cannot be created from string null. The string value must be in format YYYY-MM-DDTHH:MI:SS.sss+hh:mm.: null

Could you please help me on that?

Tagged:
This discussion has been closed.