12-11-2017 07:33 AM
Hi. I would like to query the API on the module History but it seems that it's impossible to query the dates.
Here my query string:
strFilter = "?$filter=(startTime ge 2017-01-01T00:00:00Z and startTime le 2017-12-31T23:59:59Z)"
I get error 500
This filter work:
strFilter = "?$filter=historyTypeID ge 1000"
I'm trying to get all history in 2017.
12-12-2017 02:30 AM
It looks like there is an issue with this particular OData query, I'm not able to make requests on this either - any attempt to filter on startTime or endTime just returns:
"message": "An error has occurred.",
"exceptionMessage": "Unable to process filter",
I'm going to move this thread to the WebAPI development board, and raise this with the API team.
I've also attached the stackTrace for this error for their reference.
12-12-2017 11:46 AM
I was able to locate the exception when filtering on history dates. I have fixed the problem and will get this in on the next release of the API. This should be sometime this week.
01-12-2018 09:24 AM
Not sure if you already got the update, but this issue is fixed:
Get latest API build here.