RestAPI - DateTo filter not working for UutReport

Answered

Sebastien Matton

April 30, 2020 09:07

Hi,

I'm writing an application to extract some data using the RestAPI.

Unfortunately, the dateTo filter doesn't work for the "/api/App/UutReport" endpoint (both using GET and POST).

Furthermore, is it possible order by date ASC instead of getting the most recent reports first ?

Thank you

0

Comments

4 comments

Anders Kristiansen

April 30, 2020 09:34
Hi Sebastien,

The dateTo filter for /api/App/UutReport works for me. If I use this filter

GET:
```
/api/App/UutReport?dateFrom=2020-04-14T09%3A16%3A00.534Z&dateTo=2020-04-20T09%3A16%3A00.534Z
```
POST:

{
"dateFrom": "2020-04-14T00:00:00.000Z",
"dateTo": "2020-04-20T00:00:00.000Z"
}

it returns a list of reports from 14th of April to 20th of April.

There isn't a way to change the order of the returned reports.
0

Comment actions Permalink
Sebastien Matton

April 30, 2020 10:29
Hi Anders,

I've just found that it doesn't work if the seconds field is not 0. Could you check this on your side ?

Trying GET with 00 seconds:
```
/api/App/UutReport?dateFrom=2020-04-14T00:00:00.000Z&dateTo=2020-04-20T00:00:00.000Z
```
Will return a first result with dateTime field matching my filter:
```
dateTimeUtc":"2020-04-19T11:51:17.0968999"
```
Trying GET with 10 seconds:
```
/api/App/UutReport?dateFrom=2020-04-14T00:00:00.000Z&dateTo=2020-04-20T00:00:10.000Z
```
Will return a first result with dateTime field which DOESN'T match my filter:
```
dateTimeUtc":"2020-04-30T10:20:26.109"
```
0

Comment actions Permalink
Anders Kristiansen

April 30, 2020 10:37
Hi Sebastien,

You are right, for some reason dateTo doesn't work if the seconds part isn't 0. I will look into why.
0

Comment actions Permalink
Anders Kristiansen

May 14, 2020 12:24
Hi,

A bug has been identified and will be fixed in an upcoming release.
0

Comment actions Permalink

Please sign in to leave a comment.