Hello, I am using Rest Web Services API to query a dataset in the organization. The functionality generally works.
However, there is a problem if I add a relative filter to a dataset.
E.g. I want to show on the transactional dataset only transactions for the Last Fiscal Year. See screenshot. When I add this filter (criteria) and query a dataset via REST Services API I am getting this error
{
"type": "https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1",
"title": "Internal Server Error",
"status": 500,
"o:errorDetails": [
{
"detail": "An unexpected error occurred. Error ID: kqvsh91d1nht6713qu94m",
"o:errorCode": "UNEXPECTED_ERROR"
}
]
}
Dataset works with no problem in NetSuite GUI.
If I remove the filter and query - it works. If I remove the filter and add a filter like e.g. January 2020 - it works fine as well. Seems it does not work with relative filters like Last Year, Last Month, etc..
Is this bug or some setup is missing to make it work?
Thank you
Nick