-
Using a specific field in SortOrder causes the REST API request to fail
I am sending a request from my PHP web application to the following endpoint (I left the endpoint generic):
{{ServerUrl}}/{{Platform}}/FileCabinets/{{FileCabinetId}}/Query/DialogExpression?dialogId=00000000-0000-0000-0000-000000000000
The query in the body looks like this:
{"ForceRefresh":false, "Operation":"And", "AdditionalResultFields":[], "Start":0, "Count":25, "IncludeSuggestions":false, "Condition":[{"DBName":"DocuWareFulltext","Value":["test"]}], "SortOrder":[{"Direction":"Desc","Field":"DOKUMENT_ID"}], "AdditionalCabinets":["a2a20ddd-cedd-4541-8f1b-4c6ebd8c8591"]}
I am getting the following error with a status code of 500 and an internal code of 0.
"Message":"An item with the same key has already been added.","Exception":" ArgumentException: An item with the same key has already been added."
If I send the same request without "AdditionalCabinets," it works.It also works if I send the same request with "AdditionalCabinets" but use a field other than "DOKUMENT_ID" set in "SortOrder."
So, it obviously has a problem with the field "DOKUMENT_ID."
I thought maybe there was some kind of constraint set for the field "DOKUMENT_ID" in the database, but that's not the case.
I would appreciate it if someone could help me.
Thanks a lot.