API v3 "search_criteria" doesnt work with more than one field

API v3 "search_criteria" doesnt work with more than one field

I'm trying to use the API  for ServiceDesk Plus.

I am using the tester on https://servicedesk_url/SetUpWizard.do?forwardTo=apidoc -> Request -> View All Requests

It seems I cannot get the search_criteria to work unless I only have one simple field within it.

Example 1. This works and provides lots of request results:


  2. {
  3.     "list_info": {
  4.         "fields_required": [
  5.             "group",
  6.             "status"
  7.         ],
  8.         "search_criteria": {
  9.             "condition": "is not",
  10.             "field": "status.name",
  11.             "values": [
  12.                 "Lokið"
  13.             ]
  14.         },
  15.         "row_count": 100,
  16.         "get_total_count": true
  17.     }
  18. }
Example 2. This one also works and provides lots of request results:


  2. {
  3.     "list_info": {
  4.         "fields_required": [
  5.             "group",
  6.             "status"
  7.         ],
  8.         "search_criteria": {
  9.             "condition": "is",
  10.             "field": "group.name",
  11.             "values": [
  12.                 "6 Bakvinnsla"
  13.             ]
  14.         },
  15.         "row_count": 100,
  16.         "get_total_count": true
  17.     }
  18. }
However if I combine the two search_criteria fields using identical examples to the documentation here, it provdies error codes.

Example 3 which should work:


  2. {
  3.     "list_info": {
  4.         "fields_required": [
  5.             "group",
  6.             "status"
  7.         ],
  8.         "search_criteria": [
  9.             {
  10.                 "field": "group.name",
  11.                 "condition": "is",
  12.                 "values": [
  13.                     "6 Bakvinnsla"
  14.                 ]
  15.             },
  16.             {
  17.                 "field": "status.name",
  18.                 "condition": "is not",
  19.                 "values": [
  20.                     "Lokið"
  21.                 ]
  22.             }
  23.         ],
  24.         "row_count": 100,
  25.         "get_total_count": true
  26.     }
  27. }
This provides the following error code:


  2. {
  3.     "response_status": {
  4.         "status_code": 4000,
  5.         "status": "failed",
  6.         "messages": [
  7.             {
  8.                 "field": "list_info.search_criteria",
  9.                 "status_code": 4001,
  10.                 "type": "failed"
  11.             }
  12.         ]
  13.     }
  14. }
Example 4 also does not work:


  2. {
  3.     "list_info": {
  4.         "fields_required": [
  5.             "group",
  6.             "status"
  7.         ],
  8.         "search_criteria": [
  9.             {
  10.                 "field": "group",
  11.                 "condition": "is",
  12.                 "value": {
  13.                     "id": "11701",
  14.                     "name": "6 Bakvinnsla"
  15.                 }
  16.             },
  17.             {
  18.                 "field": "status",
  19.                 "condition": "is not",
  20.                 "value": {
  21.                     "id": "3",
  22.                     "name": "Lokið"
  23.                 }
  24.             }
  25.         ],
  26.         "row_count": 100,
  27.         "get_total_count": true
  28.     }
  29. }
This provides the same as the previous error code:


  2. {
  3.     "response_status": {
  4.         "status_code": 4000,
  5.         "status": "failed",
  6.         "messages": [
  7.             {
  8.                 "field": "list_info.search_criteria",
  9.                 "status_code": 4001,
  10.                 "type": "failed"
  11.             }
  12.         ]
  13.     }
  14. }
Example 5 using "Children" field also does not work:


  2. {
  3.     "list_info": {
  4.         "fields_required": [
  5.             "group",
  6.             "status"
  7.         ],
  8.         "search_criteria": [
  9.             "field": "group.name",
  10.             "condition": "is",
  11.             "values": [
  12.                 "6 Bakvinnsla"
  13.             ],
  14.             "children":[
  15.                 {
  16.                     "field": "status.name",
  17.                     "condition": "is not",
  18.                     "values": [
  19.                         "Lokið"
  20.                     ]
  21.                 }
  22.             ]
  23.         ],
  24.         "row_count": 100,
  25.         "get_total_count": true
  26.     }
  27. }
This gives the following error code:


  2. {
  3.     "response_status": {
  4.         "status": "failed",
  5.         "messages": [
  6.             {
  7.                 "field": "input_data",
  8.                 "message": "Unable to parse the JSON",
  9.                 "status_code": 4001,
  10.                 "type": "failed"
  11.             }
  12.         ]
  13.     }
  14. }

I have the following version:



































        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                        Related Products