Service Manager Portal
Simon_Zeinhofer
Simon_Zeinhofer
·Posted in Service Manager Portal

Calling the GetProjectionByCriteria Endpoint with non-generic Property does not return any results

We are currently trying to receive certain types of hardware assets via the v3 API. But as soon as we use a non generic Property in the crirteria, it returns no results

Right now we use the following:

$assetURL = "https://SERVER/api/V3/Projection/GetProjectionByCriteria"

$asset = @"
{
  "Id": "4becacc7-bc3f-502f-1e9e-973f59530763",
  "Criteria": {
    "Base": {
      "Expression": {
        "And": [
        {
          "SimpleExpression": {
            "ValueExpressionLeft": {
              "Property": "$Context/Property[Type='CiresonAssetManagement!Cireson.AssetManagement.HardwareAsset']/HardwareAssetStatus$"
            },
            "Operator": "Equal",
            "ValueExpressionRight": {
              "Value": "23b38f76-b3bf-0272-f2b5-71907c0bf224"
            }
          }
        },
        {
          "SimpleExpression": {
            "ValueExpressionLeft": {
              "Property": "$Context/Property[Type='CiresonAssetManagement!Cireson.AssetManagement.HardwareAsset']/HardwareAssetID$"
            },
            "Operator": "Like",
            "ValueExpressionRight": {
              "Value": "IT00%"
            }
          }
        }
      ]
    }
  }
}
"@

$rest = Invoke-RestMethod -Uri $assetURL -Method "POST" -Headers @{"Authorization"="$platformToken"} -Body $asset -ContentType "application/json"

The result is always empty. Also when I change the

"$Context/Property[Type='CiresonAssetManagement!Cireson.AssetManagement.HardwareAsset']/HardwareAssetID$"

to

"$Context/Property[Type='c0c58e7f-7865-55cc-4600-753305b9be64']/51b2740c-840e-4e7f-64a3-151eba35fffd$"

it is exactly the same empty result.

The problem is not the Id of the Type Projection, because if I use the following call

$asset = @"
{
  "Id": "4becacc7-bc3f-502f-1e9e-973f59530763",
  "Criteria": {
    "Base": {
      "Expression": {

          

          "SimpleExpression": {
            "ValueExpressionLeft": {
              "GenericProperty": "DisplayName"
            },
            "Operator": "Like",
            "ValueExpressionRight": {
              "Value": "DISPLAYNAME%"
            }
          

    }
  }
}
"@

$rest = Invoke-RestMethod -Uri $assetURL -Method "POST" -Headers @{"Authorization"="$platformToken"} -Body $asset -ContentType "application/json"

It returns all results.

There is no error message popping up and the rest call is much faster than when I use the DisplayName as Criteria. So for me it looks like, the Criteria is not correct. But it is the same as in the API Example document.
We also tried it with other non generic properties, and everytime no results are returned. So it seems like the API can't handle non generic properties at all.