I am trying to expose a Generic Inquiry as a REST endpoint. This Generic Inquiry has a filter parameter of date. When I try to call the endpoint from POSTMAN, it keeps on erroring out.
I followed the instructions in acumatica help that tell you to encode the datetime
You should encode date and time values in URL format before passing them as the value of the parameter. For example, you can encode the current date and time by using the System.Net.WebUtility.URLEncode() method as follows: WebUtility.UrlEncode(new DateTimeOffset(DateTime.Now).ToString("yyyy-MM-ddTHH:mm:ss.fffK")).
I have tried to call this using different syntax, but it looks like it is erroring out.
The parameter is ReportDate and is of type datetime.
I have tried
1) $filter=(ReportDate eq datetime '2024-03-01T00:00:00.000')
2) $filter=(ReportDate gt datetimeoffset '2024-03-01T00:00:00.000')
3) $filter=(ReportDate eq datetimeoffset '2024-03-01T00:00:00.000')
4) $filter=(ReportDate eq datetime '2024-03-01')Each of these calls is resulting in a syntax error. I have tried with brackets and without brackets around the call. I have also tried to encode the values, but since I am using POSTMAN for the call, encoding is not necessary as POSTMAN will do that for you.
