Skip to main content
Solved

Filtering Data Retrieved Through API Call For Records Greater Than a Specified Date

  • Feb 12, 2025 9:14 AM UTC
  • 4 replies
  • 296 views
  • Translate All

I am trying to filter my API response to only make a get request of records from an endpoint of records that have to be greater than a specific date. I have tried to look at the documentation but unfortunately it does not contain any page on the documentation to give knowledge or show how this is done. 

When I add the filter parameters I get an error message as shown below :
 


The error message is caused when I try to invoke the following endpoint also containing the filters required : {{endpoint_url}}ProjectBudget?$filter=LastModifiedDateTime_value gt datetimeoffset'11/10/2024 12:00:00 AM'

​​​​​​​The endpoint URL is the specific company URL required to access the endpoints of the specific company

I require some assistance in being able to get past the error message so I can comfortably ingest data that is greater than a specified date.

Will appreciate the assistance.
 

Best answer by jinin

Hi ​@Williamqh ,

Try applying the filter as shown below.

$filter= LastModifiedDateTime ge datetimeoffset'2021-01-01T00:58:57.837-08:00'

View original

4 replies

kpopova
Acumatica Employee
Forum|alt.badge.img+3
  • Acumatica Employee
  • Feb 12, 2025 9:22 AM UTC

jinin
Pro I
Forum|alt.badge.img+12
  • Pro I
  • Answer
  • Feb 12, 2025 9:30 AM UTC

Hi ​@Williamqh ,

Try applying the filter as shown below.

$filter= LastModifiedDateTime ge datetimeoffset'2021-01-01T00:58:57.837-08:00'

Translate

  • Author
  • Freshman I
  • Feb 12, 2025 11:47 AM UTC

Thank you this was very helpful

I had to change my datetime to the required string format to make the API call work.

Translate

  • Author
  • Freshman I
  • Feb 12, 2025 12:24 PM UTC

Hi ​@Williamqh ,

Try applying the filter as shown below.

$filter= LastModifiedDateTime ge datetimeoffset'2021-01-01T00:58:57.837-08:00'

Thanks  lot, this was what I needed

Translate