26.08.2025
09:58
Hello.
I'm testing new User defined API:
I have endpoint for data source.
When I tested it manually, it works. But when I tried to do GET via API I got empty response.
GET: {{env}}/api/udef/db/1/MTBVENDOR?ComCode=PL12&InvoiceNum=ASDF&InvoiceDate=2025-08-25
RESPONSE: STATUS 200:
{
"Data": []
}
when i check sql query for data source is like this:
(([InvoiceNum] = N'ASDF') AND ((CAST([InvoiceDate] AS DATETIME) = '2025-08-25T00:00:00') AND ([ComCode] = N'PL12')))
and i works.
Do you have idea what can be a problem?
