web
You’re offline. This is a read only version of the page.
close
  • 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.